DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 2118: from mtl_cross_reference_types xtypes,

2114: Begin
2115: select items.cross_reference item,
2116: nvl(items.description,sitems.description) description
2117: into v_item,v_description
2118: from mtl_cross_reference_types xtypes,
2119: mtl_cross_references items,
2120: mtl_system_items_vl sitems
2121: where xtypes.cross_reference_type = items.cross_reference_type
2122: and items.inventory_item_id = sitems.inventory_item_id

Line 2134: from mtl_cross_reference_types xtypes,

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