DBA Data[Home] [Help]

APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1030: from mtl_cross_reference_types xtypes,

1026: Begin
1027: select items.cross_reference item,
1028: nvl(items.description,sitems.description) description
1029: into v_item,v_description
1030: from mtl_cross_reference_types xtypes,
1031: mtl_cross_references items,
1032: mtl_system_items_vl sitems
1033: where xtypes.cross_reference_type = items.cross_reference_type
1034: and items.inventory_item_id = sitems.inventory_item_id

Line 1045: from mtl_cross_reference_types xtypes,

1041: Exception When NO_DATA_FOUND Then
1042: Select items.cross_reference item,
1043: nvl(items.description,sitems.description) description
1044: into v_item,v_description
1045: from mtl_cross_reference_types xtypes,
1046: mtl_cross_references items,
1047: mtl_system_items_vl sitems
1048: where xtypes.cross_reference_type = items.cross_reference_type
1049: and items.inventory_item_id = sitems.inventory_item_id