DBA Data[Home] [Help]

APPS.ONT_OEXOHOHS_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 52: from mtl_cross_reference_types xtypes,

48: Begin
49: select items.cross_reference item,
50: nvl(items.description,sitems.description) description
51: into v_item,v_description
52: from mtl_cross_reference_types xtypes,
53: mtl_cross_references items,
54: mtl_system_items_vl sitems
55: where xtypes.cross_reference_type = items.cross_reference_type
56: and items.inventory_item_id = sitems.inventory_item_id

Line 70: from mtl_cross_reference_types xtypes,

66: Exception When NO_DATA_FOUND Then
67: select items.cross_reference item,
68: nvl(items.description,sitems.description) description
69: into v_item,v_description
70: from mtl_cross_reference_types xtypes,
71: mtl_cross_references items,
72: mtl_system_items_vl sitems
73: where xtypes.cross_reference_type =
74: items.cross_reference_type