DBA Data[Home] [Help]

APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1112: from mtl_cross_reference_types xtypes,

1108: Begin
1109: select items.cross_reference item,
1110: nvl(items.description,sitems.description) description
1111: into v_item,v_description
1112: from mtl_cross_reference_types xtypes,
1113: mtl_cross_references items,
1114: mtl_system_items_vl sitems
1115: where xtypes.cross_reference_type = items.cross_reference_type
1116: and items.inventory_item_id = sitems.inventory_item_id

Line 1130: from mtl_cross_reference_types xtypes,

1126: Exception When NO_DATA_FOUND Then
1127: select items.cross_reference item,
1128: nvl(items.description,sitems.description) description
1129: into v_item,v_description
1130: from mtl_cross_reference_types xtypes,
1131: mtl_cross_references items,
1132: mtl_system_items_vl sitems
1133: where xtypes.cross_reference_type =
1134: items.cross_reference_type