1027: select items.cross_reference item,
1028: nvl(items.description,sitems.description) description
1029: into v_item,v_description
1030: from mtl_cross_reference_types xtypes,
1031: mtl_cross_references items,
1032: mtl_system_items_vl sitems
1033: where xtypes.cross_reference_type = items.cross_reference_type
1034: and items.inventory_item_id = sitems.inventory_item_id
1035: and items.cross_reference = ORDERED_ITEM
1042: Select items.cross_reference item,
1043: nvl(items.description,sitems.description) description
1044: into v_item,v_description
1045: from mtl_cross_reference_types xtypes,
1046: mtl_cross_references items,
1047: mtl_system_items_vl sitems
1048: where xtypes.cross_reference_type = items.cross_reference_type
1049: and items.inventory_item_id = sitems.inventory_item_id
1050: and items.cross_reference = ORDERED_ITEM