SELECT brv.resource_code,
cst.cost_type_code,
resource_rate
FROM bom_resources_v brv,
mtl_parameters mp,
cst_resource_costs_v cst
WHERE mp.organization_id = brv.organization_id
AND cst.resource_id = brv.resource_id
AND cst.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