APPS.CSF_GANTT_DATA_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

Line 250: FROM mtl_units_of_measure_vl

246: l_uom VARCHAR2(2000) := NULL;
247:
248: CURSOR c_uom(p_code VARCHAR2) IS
249: SELECT unit_of_measure_tl
250: FROM mtl_units_of_measure_vl
251: WHERE uom_code = p_code;
252: BEGIN
253: OPEN c_uom(p_code);
254: FETCH c_uom INTO l_uom;

Line 360: FROM mtl_units_of_measure_vl

356: l_Res_Timezone_id Number;
357: l_res_tz_cd varchar2(100);
358: CURSOR c_uom(p_code VARCHAR2) IS
359: SELECT unit_of_measure_tl
360: FROM mtl_units_of_measure_vl
361: WHERE uom_code = p_code;
362:
363: CURSOR c_parts(b_task_id NUMBER) IS
364: SELECT 'Y' required

Line 1499: FROM mtl_units_of_measure_vl

1495: l_Res_Timezone_id Number;
1496: l_res_tz_cd varchar2(100);
1497: CURSOR c_uom(p_code VARCHAR2) IS
1498: SELECT unit_of_measure_tl
1499: FROM mtl_units_of_measure_vl
1500: WHERE uom_code = p_code;
1501:
1502: CURSOR c_parts(b_task_id NUMBER) IS
1503: SELECT 'Y' required

Line 2469: FROM mtl_units_of_measure_vl

2465: l_Res_Timezone_id Number;
2466: l_res_tz_cd varchar2(100);
2467: CURSOR c_uom(p_code VARCHAR2) IS
2468: SELECT unit_of_measure_tl
2469: FROM mtl_units_of_measure_vl
2470: WHERE uom_code = p_code;
2471:
2472: CURSOR c_parts(b_task_id NUMBER) IS
2473: SELECT 'Y' required

Line 3196: FROM mtl_units_of_measure_vl

3192: l_Res_Timezone_id Number;
3193: l_res_tz_cd varchar2(100);
3194: CURSOR c_uom(p_code VARCHAR2) IS
3195: SELECT unit_of_measure_tl
3196: FROM mtl_units_of_measure_vl
3197: WHERE uom_code = p_code;
3198:
3199: CURSOR c_parts(b_task_id NUMBER) IS
3200: SELECT 'Y' required

Line 4076: FROM mtl_units_of_measure_vl

4072: l_uom VARCHAR2(2000) := NULL;
4073:
4074: CURSOR c_uom(p_code VARCHAR2) IS
4075: SELECT unit_of_measure_tl
4076: FROM mtl_units_of_measure_vl
4077: WHERE uom_code = p_code;
4078:
4079: l_api_name CONSTANT VARCHAR2(30) := 'get_planned_task';
4080: l_return_status VARCHAR2(1);

Line 4182: FROM mtl_units_of_measure_vl

4178: l_territory number;
4179:
4180: CURSOR c_uom(p_code VARCHAR2) IS
4181: SELECT unit_of_measure_tl
4182: FROM mtl_units_of_measure_vl
4183: WHERE uom_code = p_code;
4184:
4185: Cursor c_terr
4186: IS