337: select citems.customer_item_number item,
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