DBA Data[Home] [Help]

APPS.ONT_OEXOEACK_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1339: from mtl_cross_reference_types xtypes,

1335: Begin
1336: select items.cross_reference item,
1337: nvl(items.description,sitems.description) description
1338: into v_item,v_description
1339: from mtl_cross_reference_types xtypes,
1340: mtl_cross_references items,
1341: mtl_system_items_vl sitems
1342: where xtypes.cross_reference_type = items.cross_reference_type
1343: and items.inventory_item_id = sitems.inventory_item_id

Line 1357: from mtl_cross_reference_types xtypes,

1353: Exception When NO_DATA_FOUND Then
1354: select items.cross_reference item,
1355: nvl(items.description,sitems.description) description
1356: into v_item,v_description
1357: from mtl_cross_reference_types xtypes,
1358: mtl_cross_references items,
1359: mtl_system_items_vl sitems
1360: where xtypes.cross_reference_type = items.cross_reference_type
1361: and items.inventory_item_id = sitems.inventory_item_id