DBA Data[Home] [Help]

APPS.ONT_OEXOEORR_XMLP_PKG dependencies on MTL_CROSS_REFERENCES

Line 356: mtl_cross_references items,

352: select items.cross_reference item,
353: nvl(items.description,sitems.description) description
354: into v_item,v_description
355: from mtl_cross_reference_types xtypes,
356: mtl_cross_references items,
357: mtl_system_items_vl sitems
358: where xtypes.cross_reference_type = items.cross_reference_type
359: and items.inventory_item_id = sitems.inventory_item_id
360: and items.cross_reference = ordered_item

Line 373: mtl_cross_references items,

369: Exception When NO_DATA_FOUND Then
370: Select items.cross_reference item, nvl(items.description,sitems.description) description
371: into v_item,v_description
372: from mtl_cross_reference_types xtypes,
373: mtl_cross_references items,
374: mtl_system_items_vl sitems
375: where xtypes.cross_reference_type =
376: items.cross_reference_type
377: and items.inventory_item_id = sitems.inventory_item_id