APPS.ENG_ITEM_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 562: BOM_BILL_OF_MATERIALS BOM

558: AND ENG_ITEM_FLAG <> 'N'
559: AND INVENTORY_ITEM_ID IN
560: (SELECT BIC.COMPONENT_ITEM_ID
561: FROM BOM_INVENTORY_COMPONENTS BIC,
562: BOM_BILL_OF_MATERIALS BOM
563: WHERE BOM.ORGANIZATION_ID = X_org_id
564: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id
565: AND ((X_designator_option = 2 AND
566: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 599: BOM_BILL_OF_MATERIALS BOM

595: AND INVENTORY_ITEM_ID IN
596: (select BSC.SUBSTITUTE_COMPONENT_ID
597: from BOM_SUBSTITUTE_COMPONENTS BSC,
598: BOM_INVENTORY_COMPONENTS BIC,
599: BOM_BILL_OF_MATERIALS BOM
600: WHERE
601: BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
602: AND BOM.ORGANIZATION_ID = X_org_id
603: AND BOM.ASSEMBLY_ITEM_ID = X_eng_item_id

Line 652: BOM_BILL_OF_MATERIALS BOM

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

Line 719: FROM BOM_BILL_OF_MATERIALS BOM

715: l_primary_rtg_type NUMBER;
716:
717: CURSOR c_transfer_bills IS
718: SELECT *
719: FROM BOM_BILL_OF_MATERIALS BOM
720: WHERE BOM.ORGANIZATION_ID = X_org_id
721: AND BOM.ASSEMBLY_ITEM_ID = X_item_id
722: AND nvl(bom.effectivity_control, 1) <> 4 -- Bug 4210718
723: AND ((X_designator_option = 2 AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 894: BOM_BILL_OF_MATERIALS BOM,

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

Line 906: FROM BOM_BILL_OF_MATERIALS BOM2

902: AND BOR.COMMON_ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
903: AND BIC.OPERATION_SEQ_NUM = BOS.OPERATION_SEQ_NUM)
904: AND BIC.BILL_SEQUENCE_ID IN
905: (SELECT BOM2.BILL_SEQUENCE_ID
906: FROM BOM_BILL_OF_MATERIALS BOM2
907: WHERE BOM2.ORGANIZATION_ID = X_org_id
908: AND BOM2.ASSEMBLY_ITEM_ID = X_item_id
909: AND ((X_designator_option = 2 AND
910: BOM2.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 944: FROM BOM_BILL_OF_MATERIALS BOM

940: INTO DUMMY
941: FROM BOM_INVENTORY_COMPONENTS BIC
942: WHERE BIC.BILL_SEQUENCE_ID IN
943: (SELECT BOM.BILL_SEQUENCE_ID
944: FROM BOM_BILL_OF_MATERIALS BOM
945: WHERE BOM.ORGANIZATION_ID = X_org_id
946: AND BOM.ASSEMBLY_ITEM_ID = X_item_id
947: AND ((X_designator_option = 2 AND
948: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL)