[Home] [Help]
APPS.ONT_OEXOECCL_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES
Line 354: from mtl_cross_reference_types xtypes,
350: elsif (p_item_description in ('C','P','O')) then
351: select items.cross_reference item,
352: nvl(items.description,sitems.description) description
353: into v_item,v_description
354: from mtl_cross_reference_types xtypes,
355: mtl_cross_references items,
356: mtl_system_items_vl sitems
357: where xtypes.cross_reference_type = items.cross_reference_type
358: and items.inventory_item_id = sitems.inventory_item_id