DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_OPERATION_SEQUENCES

Line 818: FROM BOM_OPERATION_SEQUENCES BOS

814: UPDATE BOM_INVENTORY_COMPONENTS BIC
815: SET BIC.OPERATION_SEQ_NUM = 1
816: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
817: AND NOT EXISTS (SELECT NULL
818: FROM BOM_OPERATION_SEQUENCES BOS
819: WHERE ROUTING_SEQUENCE_ID = l_routing_sequence_id
820: AND BOS.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM);
821: END IF;
822: EXCEPTION

Line 895: BOM_OPERATION_SEQUENCES BOS

891: WHERE NOT EXISTS
892: (SELECT 'X'
893: FROM BOM_OPERATIONAL_ROUTINGS BOR,
894: BOM_BILL_OF_MATERIALS BOM,
895: BOM_OPERATION_SEQUENCES BOS
896: WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
897: AND BOR.ROUTING_TYPE = 1
898: AND BOM.ASSEMBLY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
899: AND BOM.ORGANIZATION_ID = BOR.ORGANIZATION_ID