DBA Data[Home] [Help]

APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_OPERATION_SEQUENCES

Line 382: FROM BOM_OPERATION_SEQUENCES

378: BEGIN
379:
380: SELECT old_operation_sequence_id
381: INTO l_old_op_seq_id
382: FROM BOM_OPERATION_SEQUENCES
383: WHERE operation_sequence_id = p_op_seq_id ;
384:
385: RETURN l_old_op_seq_id ;
386:

Line 1390: FROM BOM_OPERATION_SEQUENCES bos

1386: IS
1387: SELECT 'Rev Sub Op Resource Not Exists'
1388: FROM DUAL
1389: WHERE NOT EXISTS (SELECT NULL
1390: FROM BOM_OPERATION_SEQUENCES bos
1391: , BOM_SUB_OPERATION_RESOURCES bsor
1392: WHERE bsor.substitute_group_num = p_sub_group_num
1393: AND bsor.resource_id = p_resource_id
1394: AND bsor.operation_sequence_id = bos.operation_sequence_id