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 1360: FROM BOM_OPERATION_SEQUENCES bos

1356: IS
1357: SELECT 'Rev Sub Op Resource Not Exists'
1358: FROM DUAL
1359: WHERE NOT EXISTS (SELECT NULL
1360: FROM BOM_OPERATION_SEQUENCES bos
1361: , BOM_SUB_OPERATION_RESOURCES bsor
1362: WHERE bsor.substitute_group_num = p_sub_group_num
1363: AND bsor.resource_id = p_resource_id
1364: AND bsor.operation_sequence_id = bos.operation_sequence_id