APPS.ENG_ITEM_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 655: FROM BOM_INVENTORY_COMPONENTS BIC,

651: WHERE ORGANIZATION_ID = X_org_id
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

Line 695: BOM_INVENTORY_COMPONENTS BIC,

691: AND ENG_ITEM_FLAG <> 'N'
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

Line 752: FROM BOM_INVENTORY_COMPONENTS BIC,

748: WHERE ORGANIZATION_ID = X_master_org
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

Line 782: -- BOM_INVENTORY_COMPONENTS where there is no

778: -- SET_OP_SEQ
779:
780: -- DESCRIPTION
781: -- Set Operation Sequence: Set operation_seq_num to 1 in table
782: -- BOM_INVENTORY_COMPONENTS where there is no
783: -- corresponding manufacturing routing.
784:
785: -- REQUIRES
786: -- org_id: organization id

Line 833: -- Need to update the operation_seq_num in bom_inventory_components conditionally

829: BEGIN
830:
831: X_stmt_num := 300;
832: -- Changes for bug 3801212
833: -- Need to update the operation_seq_num in bom_inventory_components conditionally
834: -- Case A: Primary bill is transferred
835: -- 1) Primary routing_type = 1 (mfg): No update required
836: -- 2) Primary routing_type = 2 (eng): update required
837: -- Case B: Alternate bill is transferred

Line 910: UPDATE BOM_INVENTORY_COMPONENTS

906: BEGIN
907: IF ( l_routing_sequence_id = -1 )
908: THEN
909: X_stmt_num := 303;
910: UPDATE BOM_INVENTORY_COMPONENTS
911: SET OPERATION_SEQ_NUM = 1
912: WHERE BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID;
913: ELSE
914: X_stmt_num := 304;

Line 915: UPDATE BOM_INVENTORY_COMPONENTS BIC

911: SET OPERATION_SEQ_NUM = 1
912: WHERE BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID;
913: ELSE
914: X_stmt_num := 304;
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

Line 948: FROM BOM_INVENTORY_COMPONENTS BIC

944: BEGIN
945: X_stmt_num := 305;
946: SELECT count(*)
947: INTO DUMMY
948: FROM BOM_INVENTORY_COMPONENTS BIC
949: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
950: AND EXISTS
951: (SELECT NULL
952: FROM BOM_INVENTORY_COMPONENTS BIC2

Line 952: FROM BOM_INVENTORY_COMPONENTS BIC2

948: FROM BOM_INVENTORY_COMPONENTS BIC
949: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
950: AND EXISTS
951: (SELECT NULL
952: FROM BOM_INVENTORY_COMPONENTS BIC2
953: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
954: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
955: AND BIC2.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
956: AND NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2

Line 990: UPDATE BOM_INVENTORY_COMPONENTS BIC

986: END IF;
987: END LOOP;
988: /*
989: BEGIN
990: UPDATE BOM_INVENTORY_COMPONENTS BIC
991: SET OPERATION_SEQ_NUM = 1
992: WHERE NOT EXISTS
993: (SELECT 'X'
994: FROM BOM_OPERATIONAL_ROUTINGS BOR,

Line 1042: FROM BOM_INVENTORY_COMPONENTS BIC

1038: END IF;
1039:
1040: SELECT count(*)
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

Line 1057: FROM BOM_INVENTORY_COMPONENTS BIC2

1053: OR
1054: (X_designator_option = 1)))
1055: AND EXISTS
1056: (SELECT NULL
1057: FROM BOM_INVENTORY_COMPONENTS BIC2
1058: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
1059: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
1060: AND BIC2.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
1061: AND NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2