[Home] [Help]
325: or (p_print_description in ('I','D','F')) then
326: select sitems.concatenated_segments item,
327: sitems.description description
328: into v_item,v_description
329: from mtl_system_items_vl sitems
330: -- where sitems.customer_order_enabled_flag = 'Y'
331: -- and sitems.bom_item_type in (1,4)
332: where nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
333: and sitems.inventory_item_id = inventory_item_id1;
338: nvl(citems.customer_item_desc,sitems.description) description
339: into v_item,v_description
340: from mtl_customer_items citems,
341: mtl_customer_item_xrefs cxref,
342: mtl_system_items_vl sitems
343: where citems.customer_item_id = cxref.customer_item_id
344: and cxref.inventory_item_id = sitems.inventory_item_id
345: and citems.customer_item_id = ordered_item_id
346: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID) ,0)
353: nvl(items.description,sitems.description) description
354: into v_item,v_description
355: from mtl_cross_reference_types xtypes,
356: mtl_cross_references items,
357: mtl_system_items_vl sitems
358: where xtypes.cross_reference_type = items.cross_reference_type
359: and items.inventory_item_id = sitems.inventory_item_id
360: and items.cross_reference = ordered_item
361: and items.cross_reference_type = item_identifier_type
370: Select items.cross_reference item, nvl(items.description,sitems.description) description
371: into v_item,v_description
372: from mtl_cross_reference_types xtypes,
373: mtl_cross_references items,
374: mtl_system_items_vl sitems
375: where xtypes.cross_reference_type =
376: items.cross_reference_type
377: and items.inventory_item_id = sitems.inventory_item_id
378: and items.cross_reference = ordered_item