393: select items.cross_reference item,
394: nvl(items.description,sitems.description) description
395: into v_item,v_description
396: from mtl_cross_reference_types xtypes,
397: mtl_cross_references items,
398: mtl_system_items_vl sitems
399: where xtypes.cross_reference_type = items.cross_reference_type
400: and items.inventory_item_id = sitems.inventory_item_id
401: and items.cross_reference = ordered_item