DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on MTL_UNITS_OF_MEASURE

Line 2382: mtl_units_of_measure meas

2378: = 'MATERIAL_ITEMS'
2379: AND res_temp.inventory_item_id IS NOT NULL
2380: AND NOT EXISTS (select 'Y'
2381: from mtl_system_items_b item,
2382: mtl_units_of_measure meas
2383: where item.inventory_item_id =
2384: res_temp.inventory_item_id
2385: and item.organization_id = res_temp.organization_id -- bug 10121923
2386: and item.primary_uom_code = meas.uom_code

Line 7489: mtl_units_of_measure meas

7485: INTO l_rate_based_flag
7486: FROM dual
7487: WHERE NOT EXISTS (select 'Y'
7488: from mtl_system_items_b item,
7489: mtl_units_of_measure meas
7490: where item.inventory_item_id =
7491: l_res_details.inventory_item_id
7492: and item.primary_uom_code = meas.uom_code
7493: and meas.uom_class = 'Currency');