APPS.ENG_ITEM_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 561: FROM BOM_INVENTORY_COMPONENTS BIC,

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

Line 598: BOM_INVENTORY_COMPONENTS BIC,

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

Line 651: FROM BOM_INVENTORY_COMPONENTS BIC,

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

Line 681: -- BOM_INVENTORY_COMPONENTS where there is no

677: -- SET_OP_SEQ
678:
679: -- DESCRIPTION
680: -- Set Operation Sequence: Set operation_seq_num to 1 in table
681: -- BOM_INVENTORY_COMPONENTS where there is no
682: -- corresponding manufacturing routing.
683:
684: -- REQUIRES
685: -- org_id: organization id

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

728: BEGIN
729:
730: X_stmt_num := 300;
731: -- Changes for bug 3801212
732: -- Need to update the operation_seq_num in bom_inventory_components conditionally
733: -- Case A: Primary bill is transferred
734: -- 1) Primary routing_type = 1 (mfg): No update required
735: -- 2) Primary routing_type = 2 (eng): update required
736: -- Case B: Alternate bill is transferred

Line 809: UPDATE BOM_INVENTORY_COMPONENTS

805: BEGIN
806: IF ( l_routing_sequence_id = -1 )
807: THEN
808: X_stmt_num := 303;
809: UPDATE BOM_INVENTORY_COMPONENTS
810: SET OPERATION_SEQ_NUM = 1
811: WHERE BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID;
812: ELSE
813: X_stmt_num := 304;

Line 814: UPDATE BOM_INVENTORY_COMPONENTS BIC

810: SET OPERATION_SEQ_NUM = 1
811: WHERE BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID;
812: ELSE
813: X_stmt_num := 304;
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

Line 847: FROM BOM_INVENTORY_COMPONENTS BIC

843: BEGIN
844: X_stmt_num := 305;
845: SELECT count(*)
846: INTO DUMMY
847: FROM BOM_INVENTORY_COMPONENTS BIC
848: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
849: AND EXISTS
850: (SELECT NULL
851: FROM BOM_INVENTORY_COMPONENTS BIC2

Line 851: FROM BOM_INVENTORY_COMPONENTS BIC2

847: FROM BOM_INVENTORY_COMPONENTS BIC
848: WHERE BIC.BILL_SEQUENCE_ID = ctb.BILL_SEQUENCE_ID
849: AND EXISTS
850: (SELECT NULL
851: FROM BOM_INVENTORY_COMPONENTS BIC2
852: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
853: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
854: AND BIC2.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
855: AND NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2

Line 889: UPDATE BOM_INVENTORY_COMPONENTS BIC

885: END IF;
886: END LOOP;
887: /*
888: BEGIN
889: UPDATE BOM_INVENTORY_COMPONENTS BIC
890: SET OPERATION_SEQ_NUM = 1
891: WHERE NOT EXISTS
892: (SELECT 'X'
893: FROM BOM_OPERATIONAL_ROUTINGS BOR,

Line 941: FROM BOM_INVENTORY_COMPONENTS BIC

937: END IF;
938:
939: SELECT count(*)
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

Line 956: FROM BOM_INVENTORY_COMPONENTS BIC2

952: OR
953: (X_designator_option = 1)))
954: AND EXISTS
955: (SELECT NULL
956: FROM BOM_INVENTORY_COMPONENTS BIC2
957: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
958: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
959: AND BIC2.OPERATION_SEQ_NUM = BIC.OPERATION_SEQ_NUM
960: AND NVL(BIC2.ECO_FOR_PRODUCTION,2) = 2