DBA Data[Home] [Help]

APPS.ONT_OEXOEUBK_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 58: from mtl_cross_reference_types xtypes,

54: Begin
55: select items.cross_reference item,
56: nvl(items.description,sitems.description) description
57: into v_item,v_description
58: from mtl_cross_reference_types xtypes,
59: mtl_cross_references items,
60: mtl_system_items_vl sitems
61: where xtypes.cross_reference_type = items.cross_reference_type
62: and items.inventory_item_id = sitems.inventory_item_id

Line 76: from mtl_cross_reference_types xtypes,

72: Exception When NO_DATA_FOUND Then
73: select items.cross_reference item,
74: nvl(items.description,sitems.description) description
75: into v_item,v_description
76: from mtl_cross_reference_types xtypes,
77: mtl_cross_references items,
78: mtl_system_items_vl sitems
79: where xtypes.cross_reference_type =
80: items.cross_reference_type