SELECT cro.*
FROM bom_resources_v brv,
mtl_parameters mp,
cst_resource_overheads_v cro
WHERE mp.organization_id = brv.organization_id
AND cro.resource_id = brv.resource_id
AND cro.organization_id = mp.organization_id
--
AND mp.organization_code IN (
'BGA'
)
AND nvl(brv.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
AND brv.resource_code NOT IN (
SELECT brv1.resource_code
FROM bom_resources_v brv1,
mtl_parameters mp1
WHERE mp1.organization_id = brv1.organization_id
AND mp1.organization_code IN ('ABC' )
)
ORDER BY brv.resource_code
No comments:
Post a Comment