DBA Data[Home] [Help]

APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 252: from mtl_cross_reference_types xtypes,

248: Begin
249: select items.cross_reference item,
250: nvl(items.description,sitems.description) description
251: into v_item,v_description
252: from mtl_cross_reference_types xtypes,
253: mtl_cross_references items,
254: mtl_system_items_vl sitems
255: where xtypes.cross_reference_type = items.cross_reference_type
256: and items.inventory_item_id = sitems.inventory_item_id

Line 270: from mtl_cross_reference_types xtypes,

266: Exception When NO_DATA_FOUND Then
267: select items.cross_reference item,
268: nvl(items.description,sitems.description) description
269: into v_item,v_description
270: from mtl_cross_reference_types xtypes,
271: mtl_cross_references items,
272: mtl_system_items_vl sitems
273: where xtypes.cross_reference_type =
274: items.cross_reference_type