APPS.ENG_ITEM_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 656: BOM_BILL_OF_MATERIALS BOM

652: AND ENG_ITEM_FLAG <> 'N'
653: AND INVENTORY_ITEM_ID IN
654: (SELECT BIC.COMPONENT_ITEM_ID
655: FROM BOM_INVENTORY_COMPONENTS BIC,
656: BOM_BILL_OF_MATERIALS BOM
657: WHERE BOM.ORGANIZATION_ID = X_org_id
658: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id
659: AND ((X_designator_option = 2 AND
660: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 696: BOM_BILL_OF_MATERIALS BOM

692: AND INVENTORY_ITEM_ID IN
693: (select BSC.SUBSTITUTE_COMPONENT_ID
694: from BOM_SUBSTITUTE_COMPONENTS BSC,
695: BOM_INVENTORY_COMPONENTS BIC,
696: BOM_BILL_OF_MATERIALS BOM
697: WHERE
698: BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
699: AND BOM.ORGANIZATION_ID = X_org_id
700: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id

Line 753: BOM_BILL_OF_MATERIALS BOM

749: AND ENG_ITEM_FLAG <> 'N'
750: AND INVENTORY_ITEM_ID IN
751: (SELECT BIC.COMPONENT_ITEM_ID
752: FROM BOM_INVENTORY_COMPONENTS BIC,
753: BOM_BILL_OF_MATERIALS BOM
754: WHERE BOM.ORGANIZATION_ID = X_org_id
755: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id
756: AND ((X_designator_option = 2 AND
757: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 820: FROM BOM_BILL_OF_MATERIALS BOM

816: l_primary_rtg_type NUMBER;
817:
818: CURSOR c_transfer_bills IS
819: SELECT *
820: FROM BOM_BILL_OF_MATERIALS BOM
821: WHERE BOM.ORGANIZATION_ID = X_org_id
822: AND BOM.ASSEMBLY_ITEM_ID = X_item_id
823: AND nvl(bom.effectivity_control, 1) <> 4 -- Bug 4210718
824: AND ((X_designator_option = 2 AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 995: BOM_BILL_OF_MATERIALS BOM,

991: SET OPERATION_SEQ_NUM = 1
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

Line 1007: FROM BOM_BILL_OF_MATERIALS BOM2

1003: AND BOR.COMMON_ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
1004: AND BIC.OPERATION_SEQ_NUM = BOS.OPERATION_SEQ_NUM)
1005: AND BIC.BILL_SEQUENCE_ID IN
1006: (SELECT BOM2.BILL_SEQUENCE_ID
1007: FROM BOM_BILL_OF_MATERIALS BOM2
1008: WHERE BOM2.ORGANIZATION_ID = X_org_id
1009: AND BOM2.ASSEMBLY_ITEM_ID = X_item_id
1010: AND ((X_designator_option = 2 AND
1011: BOM2.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 1045: FROM BOM_BILL_OF_MATERIALS BOM

1041: INTO DUMMY
1042: FROM BOM_INVENTORY_COMPONENTS BIC
1043: WHERE BIC.BILL_SEQUENCE_ID IN
1044: (SELECT BOM.BILL_SEQUENCE_ID
1045: FROM BOM_BILL_OF_MATERIALS BOM
1046: WHERE BOM.ORGANIZATION_ID = X_org_id
1047: AND BOM.ASSEMBLY_ITEM_ID = X_item_id
1048: AND ((X_designator_option = 2 AND
1049: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)