APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_OPERATION_SEQUENCES

Line 1110: FROM BOM_OPERATION_SEQUENCES

1106: IS
1107: SELECT 'Invalid Op Seq Exists'
1108: FROM SYS.DUAL
1109: WHERE EXISTS ( SELECT 'X'
1110: FROM BOM_OPERATION_SEQUENCES
1111: WHERE change_notice = p_revised_item_rec.eco_name
1112: AND routing_sequence_id = p_rev_item_unexp_rec.routing_sequence_id
1113: AND revised_item_sequence_id =
1114: p_rev_item_unexp_rec.Revised_Item_Sequence_Id

Line 5897: FROM BOM_OPERATION_SEQUENCES

5893: CURSOR rev_op_seq IS
5894: SELECT 'Rev Op Exist'
5895: FROM SYS.DUAL
5896: WHERE EXISTS ( SELECT NULL
5897: FROM BOM_OPERATION_SEQUENCES
5898: WHERE revised_item_sequence_id =
5899: p_rev_item_unexp_rec.revised_item_sequence_id) ;
5900: -- Added by MK on 08/26/2000
5901:

Line 6429: FROM BOM_OPERATION_SEQUENCES

6425: SELECT 1
6426: FROM SYS.DUAL
6427: WHERE NOT EXISTS
6428: ( SELECT NULL
6429: FROM BOM_OPERATION_SEQUENCES
6430: WHERE NVL(operation_type, 1) = NVL(p_operation_type, 1)
6431: AND effectivity_date = p_effectivity_date
6432: AND routing_sequence_id = p_routing_sequence_id
6433: AND operation_seq_num = p_operation_seq_num