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 2403: MTL_SYSTEM_ITEMS C,

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

Line 2600: MTL_SYSTEM_ITEMS C,

2596: a.attribute14,
2597: a.attribute15,
2598: wcro.original_system_reference
2599: FROM BOM_SUBSTITUTE_COMPONENTS A,
2600: MTL_SYSTEM_ITEMS C,
2601: WSM_COPY_REQUIREMENT_OPS wcro
2602: WHERE wcro.wip_entity_id = p_wip_entity_id
2603: AND a.component_sequence_id = wcro.component_sequence_id
2604: AND a.SUBSTITUTE_COMPONENT_ID = c.inventory_item_id

Line 2790: from mtl_system_items msi

2786: l_stmt_num := 185;
2787: begin
2788: select 'Y'
2789: into l_ato_phantom
2790: from mtl_system_items msi
2791: where msi.inventory_item_id = t_comp_details(l_first_level_comps_ctr).component_item_id
2792: and msi.organization_id = p_org_id
2793: and msi.replenish_to_order_flag = 'Y'
2794: and msi.bom_item_type in (1,2);

Line 3132: MTL_SYSTEM_ITEMS C,

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

Line 3579: MTL_SYSTEM_ITEMS MSI --BUG 6495025

3575: BOM_DEPARTMENT_RESOURCES BDR1,
3576: BOM_OPERATION_SEQUENCES BOS,
3577: BOM_OPERATIONAL_ROUTINGS BRTG,
3578: WSM_COPY_REQUIREMENT_OPS WCRO,
3579: MTL_SYSTEM_ITEMS MSI --BUG 6495025
3580: WHERE wcro.wip_entity_id=p_wip_entity_id
3581: AND wcro.organization_id=p_org_id
3582: AND wcro.Operation_seq_num = -l_curr_op_seq_num
3583: AND BRTG.assembly_item_id = wcro.component_item_id

Line 5761: MTL_SYSTEM_ITEMS MSI

5757: WCRO.department_id,
5758: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5759: FROM WIP_DISCRETE_JOBS WDJ,
5760: WSM_COPY_REQUIREMENT_OPS WCRO,
5761: MTL_SYSTEM_ITEMS MSI
5762: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5763: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num
5764: AND MSI.inventory_item_id = WCRO.component_item_id
5765: AND MSI.organization_id = WCRO.organization_id