DBA Data[Home] [Help]

APPS.ONT_OEXOEORD_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 609: from mtl_cross_reference_types xtypes,

605: Begin
606: select items.cross_reference item,
607: nvl(items.description,sitems.description) description
608: into v_item,v_description
609: from mtl_cross_reference_types xtypes,
610: mtl_cross_references items,
611: mtl_system_items_vl sitems
612: where xtypes.cross_reference_type = items.cross_reference_type
613: and items.inventory_item_id = sitems.inventory_item_id

Line 627: from mtl_cross_reference_types xtypes,

623: Exception When NO_DATA_FOUND Then
624: Select items.cross_reference item,
625: nvl(items.description,sitems.description) description into
626: v_item,v_description
627: from mtl_cross_reference_types xtypes,
628: mtl_cross_references items,
629: mtl_system_items_vl sitems
630: where xtypes.cross_reference_type =
631: items.cross_reference_type