DBA Data[Home] [Help]

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);