APPS.WSM_JOBCOPIES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 611: MTL_SYSTEM_ITEMS C,

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
615: AND a.component_sequence_id = be.component_sequence_id

Line 825: MTL_SYSTEM_ITEMS C,

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
828: AND BE.TOP_BILL_SEQUENCE_ID = l_top_level_bill_seq_id
829: AND A.COMPONENT_SEQUENCE_ID=BE.COMPONENT_SEQUENCE_ID

Line 2173: MTL_SYSTEM_ITEMS C,

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
2177: AND c.organization_id = p_org_id

Line 2369: MTL_SYSTEM_ITEMS C,

2365: a.attribute14,
2366: a.attribute15,
2367: wcro.original_system_reference
2368: FROM BOM_SUBSTITUTE_COMPONENTS A,
2369: MTL_SYSTEM_ITEMS C,
2370: WSM_COPY_REQUIREMENT_OPS wcro
2371: WHERE wcro.wip_entity_id = p_wip_entity_id
2372: AND a.component_sequence_id = wcro.component_sequence_id
2373: AND a.SUBSTITUTE_COMPONENT_ID = c.inventory_item_id

Line 2559: from mtl_system_items msi

2555: l_stmt_num := 185;
2556: begin
2557: select 'Y'
2558: into l_ato_phantom
2559: from mtl_system_items msi
2560: where msi.inventory_item_id = t_comp_details(l_first_level_comps_ctr).component_item_id
2561: and msi.organization_id = p_org_id
2562: and msi.replenish_to_order_flag = 'Y'
2563: and msi.bom_item_type in (1,2);

Line 2901: MTL_SYSTEM_ITEMS C,

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
2905: AND C.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID

Line 3348: MTL_SYSTEM_ITEMS MSI --BUG 7598223

3344: BOM_DEPARTMENT_RESOURCES BDR1,
3345: BOM_OPERATION_SEQUENCES BOS,
3346: BOM_OPERATIONAL_ROUTINGS BRTG,
3347: WSM_COPY_REQUIREMENT_OPS WCRO,
3348: MTL_SYSTEM_ITEMS MSI --BUG 7598223
3349: WHERE wcro.wip_entity_id=p_wip_entity_id
3350: AND wcro.organization_id=p_org_id
3351: AND wcro.Operation_seq_num = -l_curr_op_seq_num
3352: AND BRTG.assembly_item_id = wcro.component_item_id

Line 5530: MTL_SYSTEM_ITEMS MSI

5526: WCRO.department_id,
5527: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5528: FROM WIP_DISCRETE_JOBS WDJ,
5529: WSM_COPY_REQUIREMENT_OPS WCRO,
5530: MTL_SYSTEM_ITEMS MSI
5531: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5532: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num
5533: AND MSI.inventory_item_id = WCRO.component_item_id
5534: AND MSI.organization_id = WCRO.organization_id