SELECT mp.organization_code,
bdv.department_code,
description,
disable_date,
department_class_code,
class_description,
location_code,
location_description,
bdv.attribute1,
bdv.attribute2
FROM bom_departments_v bdv,
mtl_parameters mp
WHERE mp.organization_id = bdv.organization_id
AND mp.organization_code IN ( 'ABC','PQR' )
AND nvl(disable_date,(sysdate + 1)) > sysdate
No comments:
Post a Comment