DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_OPERATION_SEQUENCES

Line 919: FROM BOM_OPERATION_SEQUENCES BOS

915: UPDATE BOM_INVENTORY_COMPONENTS BIC
916: SET BIC.OPERATION_SEQ_NUM = 1
917: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
918: AND NOT EXISTS (SELECT NULL
919: FROM BOM_OPERATION_SEQUENCES BOS
920: WHERE ROUTING_SEQUENCE_ID = l_routing_sequence_id
921: AND BOS.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM);
922: END IF;
923: EXCEPTION

Line 996: BOM_OPERATION_SEQUENCES BOS

992: WHERE NOT EXISTS
993: (SELECT 'X'
994: FROM BOM_OPERATIONAL_ROUTINGS BOR,
995: BOM_BILL_OF_MATERIALS BOM,
996: BOM_OPERATION_SEQUENCES BOS
997: WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
998: AND BOR.ROUTING_TYPE = 1
999: AND BOM.ASSEMBLY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
1000: AND BOM.ORGANIZATION_ID = BOR.ORGANIZATION_ID