DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 2122: from mtl_cross_reference_types xtypes,

2118: Begin
2119: select items.cross_reference item,
2120: nvl(items.description,sitems.description) description
2121: into v_item,v_description
2122: from mtl_cross_reference_types xtypes,
2123: mtl_cross_references items,
2124: mtl_system_items_vl sitems
2125: where xtypes.cross_reference_type = items.cross_reference_type
2126: and items.inventory_item_id = sitems.inventory_item_id

Line 2138: from mtl_cross_reference_types xtypes,

2134: Exception When NO_DATA_FOUND Then
2135: select items.cross_reference item,
2136: nvl(items.description,sitems.description) description
2137: into v_item, v_description
2138: from mtl_cross_reference_types xtypes,
2139: mtl_cross_references items,
2140: mtl_system_items_vl sitems
2141: where xtypes.cross_reference_type =
2142: items.cross_reference_type