DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 2894: from MTL_UNITS_OF_MEASURE_TL

2890: WHERE uom_code = p_uom_code AND inventory_item_id = p_inventory_item_id;
2891: */
2892: --AnRaj: Changed query, Perf Bug#4908609,Issue#2
2893: SELECT 'X'
2894: from MTL_UNITS_OF_MEASURE_TL
2895: where uom_class = (
2896: select distinct uom.uom_class
2897: from MTL_UNITS_OF_MEASURE_TL uom
2898: where uom.uom_code = ( select distinct primary_uom_code

Line 2897: from MTL_UNITS_OF_MEASURE_TL uom

2893: SELECT 'X'
2894: from MTL_UNITS_OF_MEASURE_TL
2895: where uom_class = (
2896: select distinct uom.uom_class
2897: from MTL_UNITS_OF_MEASURE_TL uom
2898: where uom.uom_code = ( select distinct primary_uom_code
2899: from mtl_system_items
2900: where inventory_item_id = p_inventory_item_id
2901: )