DBA Data[Home] [Help]

APPS.ONT_OEXOEITR_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 532: from mtl_cross_reference_types xtypes,

528: Begin
529: select items.cross_reference item,
530: nvl(items.description,sitems.description) description
531: into v_item,v_description
532: from mtl_cross_reference_types xtypes,
533: mtl_cross_references items,
534: mtl_system_items_vl sitems
535: where xtypes.cross_reference_type = items.cross_reference_type
536: and items.inventory_item_id = sitems.inventory_item_id

Line 550: from mtl_cross_reference_types xtypes,

546: Exception When NO_DATA_FOUND Then
547: Select items.cross_reference item,
548: nvl(items.description,sitems.description) description
549: into v_item,v_description
550: from mtl_cross_reference_types xtypes,
551: mtl_cross_references items,
552: mtl_system_items_vl sitems
553: where xtypes.cross_reference_type =
554: items.cross_reference_type