APPS.CSF_GANTT_DATA_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

Line 197: FROM mtl_units_of_measure_vl

193: l_uom VARCHAR2(2000) := NULL;
194:
195: CURSOR c_uom(p_code VARCHAR2) IS
196: SELECT unit_of_measure_tl
197: FROM mtl_units_of_measure_vl
198: WHERE uom_code = p_code;
199: BEGIN
200: OPEN c_uom(p_code);
201: FETCH c_uom INTO l_uom;

Line 304: FROM mtl_units_of_measure_vl

300: l_Res_Timezone_id Number;
301: l_res_tz_cd varchar2(100);
302: CURSOR c_uom(p_code VARCHAR2) IS
303: SELECT unit_of_measure_tl
304: FROM mtl_units_of_measure_vl
305: WHERE uom_code = p_code;
306:
307: CURSOR c_parts(b_task_id NUMBER) IS
308: SELECT 'Y' required

Line 889: FROM mtl_units_of_measure_vl

885: l_Res_Timezone_id Number;
886: l_res_tz_cd varchar2(100);
887: CURSOR c_uom(p_code VARCHAR2) IS
888: SELECT unit_of_measure_tl
889: FROM mtl_units_of_measure_vl
890: WHERE uom_code = p_code;
891:
892: CURSOR c_parts(b_task_id NUMBER) IS
893: SELECT 'Y' required

Line 1567: FROM mtl_units_of_measure_vl

1563: l_uom VARCHAR2(2000) := NULL;
1564:
1565: CURSOR c_uom(p_code VARCHAR2) IS
1566: SELECT unit_of_measure_tl
1567: FROM mtl_units_of_measure_vl
1568: WHERE uom_code = p_code;
1569:
1570: l_api_name CONSTANT VARCHAR2(30) := 'get_planned_task';
1571: l_return_status VARCHAR2(1);

Line 1669: FROM mtl_units_of_measure_vl

1665: l_inc_tz_desc VARCHAR2(100);
1666:
1667: CURSOR c_uom(p_code VARCHAR2) IS
1668: SELECT unit_of_measure_tl
1669: FROM mtl_units_of_measure_vl
1670: WHERE uom_code = p_code;
1671:
1672: BEGIN
1673: IF nvl(p_inc_tz_code,'ERROR') ='ERROR'