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 848: FROM BOM_INVENTORY_COMPONENTS BIC,

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

Line 871: FROM BOM_INVENTORY_COMPONENTS BICN,

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

Line 2402: FROM BOM_INVENTORY_COMPONENTS A,

2398: a.attribute13,
2399: a.attribute14,
2400: a.attribute15,
2401: a.original_system_reference
2402: FROM BOM_INVENTORY_COMPONENTS A,
2403: MTL_SYSTEM_ITEMS C,
2404: BOM_OPERATION_SEQUENCES BOS
2405: WHERE a.bill_sequence_id = p_common_bill_seq_id
2406: AND a.component_item_id = c.inventory_item_id

Line 3131: FROM BOM_INVENTORY_COMPONENTS A,

3127: a.attribute12,
3128: a.attribute13,
3129: a.attribute14,
3130: a.attribute15
3131: FROM BOM_INVENTORY_COMPONENTS A,
3132: MTL_SYSTEM_ITEMS C,
3133: BOM_EXPLOSION_TEMP BE
3134: WHERE BE.GROUP_ID = l_phantom_expl_group_id--l_explosion_group_id
3135: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID

Line 3144: FROM BOM_INVENTORY_COMPONENTS BIC,

3140: AND p_bom_rev_date BETWEEN A.EFFECTIVITY_DATE and
3141: nvl(A.DISABLE_DATE, p_bom_rev_date+1)
3142: AND A.EFFECTIVITY_DATE =
3143: (SELECT MAX(EFFECTIVITY_DATE)
3144: FROM BOM_INVENTORY_COMPONENTS BIC,
3145: ENG_REVISED_ITEMS ERI
3146: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
3147: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
3148: AND (decode(BIC.IMPLEMENTATION_DATE,

Line 3167: FROM BOM_INVENTORY_COMPONENTS BICN,

3163: ERI.REVISED_ITEM_SEQUENCE_ID(+)
3164: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
3165: AND NOT EXISTS
3166: (SELECT 'X'
3167: FROM BOM_INVENTORY_COMPONENTS BICN,
3168: ENG_REVISED_ITEMS ERI1
3169: WHERE BICN.BILL_SEQUENCE_ID =
3170: A.BILL_SEQUENCE_ID
3171: AND BICN.OLD_COMPONENT_SEQUENCE_ID =