APPS.BOMPVALR dependencies on BOM_DEPARTMENT_RESOURCES
Line 1269: from bom_Resources br, bom_department_resources bdr
1265: into res_cnt
1266: from bom_op_resources_interface ori
1267: where ori.operation_sequence_id = c1rec.OSI
1268: and ori.resource_id not in (select br.resource_id 1269: from bom_Resources br, bom_department_resources bdr 1270: where br.resource_id = ori.resource_id
1271: and nvl(br.disable_date, dummy_eff + 1) > dummy_eff
1272: and bdr.department_id = dept_id
1273: and bdr.resource_id = ori.resource_id);