DBA Data[Home] [Help]

APPS.BOM_RTG_EAM_UTIL dependencies on BOM_OPERATION_RESOURCES

Line 1218: -- FROM BOM_OPERATION_RESOURCES bor

1214: AND bd.department_id = p_dept_id
1215: AND bd.organization_id = p_org_id
1216: AND (
1217: -- (NOT EXISTS (SELECT NULL
1218: -- FROM BOM_OPERATION_RESOURCES bor
1219: -- WHERE bor.operation_sequence_id = NVL(p_op_seq_id, -1)
1220: -- )
1221: -- ) OR
1222: ( NOT EXISTS ( SELECT 'Dept Invalid'

Line 1223: FROM BOM_OPERATION_RESOURCES bor2

1219: -- WHERE bor.operation_sequence_id = NVL(p_op_seq_id, -1)
1220: -- )
1221: -- ) OR
1222: ( NOT EXISTS ( SELECT 'Dept Invalid'
1223: FROM BOM_OPERATION_RESOURCES bor2
1224: WHERE bor2.operation_sequence_id = NVL(p_op_seq_id,-1)
1225: AND NOT EXISTS (SELECT 'x'
1226: FROM BOM_DEPARTMENT_RESOURCES bdr
1227: WHERE bdr.department_id = bd.department_id