DBA Data[Home] [Help]

APPS.ONT_OEXOEORR_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 355: from mtl_cross_reference_types xtypes,

351: Begin
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

Line 372: from mtl_cross_reference_types xtypes,

368: -- and sitems.bom_item_type in (1,4)
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