APPS.CSF_UTIL_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 411: FROM mtl_units_of_measure_vl

407: RETURN VARCHAR2 IS
408: l_uom VARCHAR2(2000) := NULL;
409: CURSOR c_uom(p_code VARCHAR2) IS
410: SELECT unit_of_measure_tl
411: FROM mtl_units_of_measure_vl
412: WHERE uom_code = p_code;
413: BEGIN
414: OPEN c_uom(p_code);
415: FETCH c_uom INTO l_uom;

Line 424: FROM mtl_units_of_measure_vl

420: FUNCTION is_uom_valid(p_value VARCHAR2)
421: RETURN VARCHAR2 IS
422: CURSOR c_uom(p_value VARCHAR2) IS
423: SELECT 'TRUE'
424: FROM mtl_units_of_measure_vl
425: WHERE uom_code = p_value AND(TRUNC(disable_date) >= TRUNC(SYSDATE) OR disable_date IS NULL);
426: l_ret VARCHAR2(5);
427: BEGIN
428: OPEN c_uom(p_value);