APPS.WSM_JOBCOPIES_PVT dependencies on BOM_INVENTORY_COMPONENTS

Line 610: BOM_INVENTORY_COMPONENTS A,

606: a.attribute13,
607: a.attribute14,
608: a.attribute15
609: FROM WSM_COPY_OPERATIONS O,
610: BOM_INVENTORY_COMPONENTS A,
611: MTL_SYSTEM_ITEMS C,
612: BOM_EXPLOSION_TEMP BE
613: WHERE be.group_id = l_explosion_group_id
614: AND be.top_bill_sequence_id = l_top_level_bill_seq_id

Line 632: FROM BOM_INVENTORY_COMPONENTS BIC,

628: (l_curr_first_op_attach_opseq1 = 1 and a.operation_seq_num = 1)
629: )
630: AND p_bom_rev_date between a.effectivity_date and nvl(a.disable_date, p_bom_rev_date+1)
631: AND A.EFFECTIVITY_DATE = (SELECT MAX(EFFECTIVITY_DATE)
632: FROM BOM_INVENTORY_COMPONENTS BIC,
633: ENG_REVISED_ITEMS ERI
634: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
635: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
636: AND (decode(BIC.IMPLEMENTATION_DATE,

Line 655: FROM BOM_INVENTORY_COMPONENTS BICN,

651: ERI.REVISED_ITEM_SEQUENCE_ID(+)
652: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
653: AND NOT EXISTS
654: (SELECT 'X'
655: FROM BOM_INVENTORY_COMPONENTS BICN,
656: ENG_REVISED_ITEMS ERI1
657: WHERE BICN.BILL_SEQUENCE_ID =
658: A.BILL_SEQUENCE_ID
659: AND BICN.OLD_COMPONENT_SEQUENCE_ID =

Line 823: BOM_INVENTORY_COMPONENTS A,

819: s.attribute13,
820: s.attribute14,
821: s.attribute15
822: FROM WSM_COPY_OPERATIONS O,
823: BOM_INVENTORY_COMPONENTS A,
824: BOM_SUBSTITUTE_COMPONENTS S,
825: MTL_SYSTEM_ITEMS C,
826: BOM_EXPLOSION_TEMP BE
827: WHERE BE.GROUP_ID=l_explosion_group_id

Line 847: FROM BOM_INVENTORY_COMPONENTS BIC,

843: (l_curr_first_op_attach_opseq1 = 1 AND A.OPERATION_SEQ_NUM = 1)
844: )
845: AND p_bom_rev_date BETWEEN A.EFFECTIVITY_DATE and nvl(A.DISABLE_DATE, p_bom_rev_date+1)
846: AND A.EFFECTIVITY_DATE = (SELECT MAX(EFFECTIVITY_DATE)
847: FROM BOM_INVENTORY_COMPONENTS BIC,
848: ENG_REVISED_ITEMS ERI
849: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
850: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
851: AND (decode(BIC.IMPLEMENTATION_DATE,

Line 870: FROM BOM_INVENTORY_COMPONENTS BICN,

866: ERI.REVISED_ITEM_SEQUENCE_ID(+)
867: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
868: AND NOT EXISTS
869: (SELECT 'X'
870: FROM BOM_INVENTORY_COMPONENTS BICN,
871: ENG_REVISED_ITEMS ERI1
872: WHERE BICN.BILL_SEQUENCE_ID =
873: A.BILL_SEQUENCE_ID
874: AND BICN.OLD_COMPONENT_SEQUENCE_ID =

Line 2172: FROM BOM_INVENTORY_COMPONENTS A,

2168: a.attribute13,
2169: a.attribute14,
2170: a.attribute15,
2171: a.original_system_reference
2172: FROM BOM_INVENTORY_COMPONENTS A,
2173: MTL_SYSTEM_ITEMS C,
2174: BOM_OPERATION_SEQUENCES BOS
2175: WHERE a.bill_sequence_id = p_common_bill_seq_id
2176: AND a.component_item_id = c.inventory_item_id

Line 2900: FROM BOM_INVENTORY_COMPONENTS A,

2896: a.attribute12,
2897: a.attribute13,
2898: a.attribute14,
2899: a.attribute15
2900: FROM BOM_INVENTORY_COMPONENTS A,
2901: MTL_SYSTEM_ITEMS C,
2902: BOM_EXPLOSION_TEMP BE
2903: WHERE BE.GROUP_ID = l_phantom_expl_group_id--l_explosion_group_id
2904: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID

Line 2913: FROM BOM_INVENTORY_COMPONENTS BIC,

2909: AND p_bom_rev_date BETWEEN A.EFFECTIVITY_DATE and
2910: nvl(A.DISABLE_DATE, p_bom_rev_date+1)
2911: AND A.EFFECTIVITY_DATE =
2912: (SELECT MAX(EFFECTIVITY_DATE)
2913: FROM BOM_INVENTORY_COMPONENTS BIC,
2914: ENG_REVISED_ITEMS ERI
2915: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
2916: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
2917: AND (decode(BIC.IMPLEMENTATION_DATE,

Line 2936: FROM BOM_INVENTORY_COMPONENTS BICN,

2932: ERI.REVISED_ITEM_SEQUENCE_ID(+)
2933: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
2934: AND NOT EXISTS
2935: (SELECT 'X'
2936: FROM BOM_INVENTORY_COMPONENTS BICN,
2937: ENG_REVISED_ITEMS ERI1
2938: WHERE BICN.BILL_SEQUENCE_ID =
2939: A.BILL_SEQUENCE_ID
2940: AND BICN.OLD_COMPONENT_SEQUENCE_ID =