234: select citems.customer_item_number item,
235: nvl(citems.customer_item_desc,sitems.description) description
236: into v_item,v_description
237: from mtl_customer_items citems,
238: mtl_customer_item_xrefs cxref,
239: mtl_system_items_vl sitems
240: where citems.customer_item_id = cxref.customer_item_id
241: and cxref.inventory_item_id = sitems.inventory_item_id
242: and citems.customer_item_id = ordered_item_id