DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on MTL_UNITS_OF_MEASURE

Line 808: AND EXISTS (SELECT 1 from mtl_units_of_measure_tl b

804: FROM mtl_uom_conversions muc
805: WHERE muc.uom_code = user_uom_code
806: AND muc.inventory_item_id = 0
807: AND NVL(muc.disable_date, SYSDATE + 1) > SYSDATE
808: AND EXISTS (SELECT 1 from mtl_units_of_measure_tl b
809: WHERE b.uom_code = prf_uom_code
810: AND b.uom_class = muc.uom_class);
811:
812: BEGIN

Line 960: from mtl_units_of_measure

956: BEGIN
957:
958: select uom_code
959: into lv_uom_code
960: from mtl_units_of_measure
961: where uom_class = v_yield_uom_class
962: and base_uom_flag = 'Y';
963: EXCEPTION
964: WHEN NO_DATA_FOUND THEN return -99999;