APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_OPERATION_SEQUENCES

Line 1166: FROM BOM_OPERATION_SEQUENCES

1162: IS
1163: SELECT 'Invalid Op Seq Exists'
1164: FROM SYS.DUAL
1165: WHERE EXISTS ( SELECT 'X'
1166: FROM BOM_OPERATION_SEQUENCES
1167: WHERE change_notice = p_revised_item_rec.eco_name
1168: AND routing_sequence_id = p_rev_item_unexp_rec.routing_sequence_id
1169: AND revised_item_sequence_id =
1170: p_rev_item_unexp_rec.Revised_Item_Sequence_Id

Line 5978: FROM BOM_OPERATION_SEQUENCES

5974: CURSOR rev_op_seq IS
5975: SELECT 'Rev Op Exist'
5976: FROM SYS.DUAL
5977: WHERE EXISTS ( SELECT NULL
5978: FROM BOM_OPERATION_SEQUENCES
5979: WHERE revised_item_sequence_id =
5980: p_rev_item_unexp_rec.revised_item_sequence_id) ;
5981: -- Added by MK on 08/26/2000
5982:

Line 6515: FROM BOM_OPERATION_SEQUENCES

6511: SELECT 1
6512: FROM SYS.DUAL
6513: WHERE NOT EXISTS
6514: ( SELECT NULL
6515: FROM BOM_OPERATION_SEQUENCES
6516: WHERE NVL(operation_type, 1) = NVL(p_operation_type, 1)
6517: AND effectivity_date = p_effectivity_date
6518: AND routing_sequence_id = p_routing_sequence_id
6519: AND operation_seq_num = p_operation_seq_num