APPS.BOM_VALIDATE_OP_RES dependencies on BOM_DEPARTMENTS

Line 967: , BOM_DEPARTMENTS bd

963: SELECT 'No Dept Location'
964: FROM SYS.DUAL
965: WHERE NOT EXISTS( SELECT NULL
966: FROM BOM_OPERATION_SEQUENCES bos
967: , BOM_DEPARTMENTS bd
968: WHERE bd.location_id IS NOT NULL
969: AND bd.department_id = bos.department_id
970: AND bos.operation_sequence_id = p_op_seq_id
971: ) ;