APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1063: FROM FND_LOOKUP_VALUES_VL

1059:
1060: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
1061: IS
1062: SELECT lookup_code
1063: FROM FND_LOOKUP_VALUES_VL
1064: WHERE lookup_code = c_lookup_code
1065: AND lookup_type = c_lookup_type
1066: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
1067: AND NVL(end_date_active,SYSDATE)

Line 1150: FND_LOOKUP_VALUES_VL FNDL

1146: IS
1147: SELECT AWOS.status_code,
1148: FNDL.meaning
1149: FROM AHL_WORKORDERS AWOS,
1150: FND_LOOKUP_VALUES_VL FNDL
1151: WHERE AWOS.WORKORDER_ID = c_workorder_id
1152: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
1153: AND FNDL.lookup_code(+) = AWOS.status_code;
1154: -- cursor to retrieve minimum actual start date and maximum actual

Line 4464: FND_LOOKUP_VALUES_VL FNDL

4460: SELECT AWOS.status_code,
4461: AWOS.workorder_name,
4462: FNDL.meaning
4463: FROM AHL_WORKORDERS AWOS,
4464: FND_LOOKUP_VALUES_VL FNDL
4465: WHERE AWOS.WORKORDER_ID = c_workorder_id
4466: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
4467: AND FNDL.lookup_code(+) = AWOS.status_code;
4468: -- Bug # 6680137 -- end

Line 4937: FROM fnd_lookup_values_vl

4933: CLOSE get_wo_status;
4934:
4935: --Get status meaning
4936: SELECT meaning INTO l_status_meaning
4937: FROM fnd_lookup_values_vl
4938: WHERE lookup_type = 'AHL_JOB_STATUS'
4939: AND LOOKUP_CODE = p_x_prd_workorder_rec.status_code;
4940: -- Bug # 6680137 -- end
4941: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');

Line 8762: FROM fnd_lookup_values_vl

8758: l_status_code = G_JOB_STATUS_DELETED ) THEN
8759:
8760: --Get status meaning
8761: SELECT meaning INTO l_status_meaning
8762: FROM fnd_lookup_values_vl
8763: WHERE lookup_type = 'AHL_JOB_STATUS'
8764: AND LOOKUP_CODE = l_status_code;
8765: --
8766: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_VISIT_STATUS');

Line 8997: FROM fnd_lookup_values_vl

8993: l_status_code = G_JOB_STATUS_CLOSED OR
8994: l_status_code = G_JOB_STATUS_DELETED ) THEN
8995: --Get status meaning
8996: SELECT meaning INTO l_status_meaning
8997: FROM fnd_lookup_values_vl
8998: WHERE lookup_type = 'AHL_JOB_STATUS'
8999: AND LOOKUP_CODE = l_status_code;
9000:
9001: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_MR_STATUS');

Line 9360: FROM fnd_lookup_values_vl

9356: l_status_code = G_JOB_STATUS_CLOSED OR
9357: l_status_code = G_JOB_STATUS_DELETED ) THEN
9358: --Get status meaning
9359: SELECT meaning INTO l_status_meaning
9360: FROM fnd_lookup_values_vl
9361: WHERE lookup_type = 'AHL_JOB_STATUS'
9362: AND LOOKUP_CODE = l_status_code;
9363:
9364: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_WO_STATUS');

Line 12149: from FND_LOOKUP_VALUES_VL

12145: and fu.user_id = fnd_global.user_id;
12146: --Cursor to get lookup meaning against code and type
12147: CURSOR Get_Lkp_Meaning(c_lookup_code VARCHAR2, c_lookup_type VARCHAR2) IS
12148: select meaning
12149: from FND_LOOKUP_VALUES_VL
12150: where
12151: lookup_type = c_lookup_type
12152: and lookup_code = c_lookup_code
12153: and enabled_flag = 'Y'

Line 12443: FROM FND_LOOKUP_VALUES_VL

12439: p_new_inst_rtng IN VARCHAR2 := NULL
12440: ) IS
12441: CURSOR Get_Meaning_From_Code(c_inst_routing_code IN VARCHAR2) IS
12442: SELECT MEANING
12443: FROM FND_LOOKUP_VALUES_VL
12444: WHERE
12445: LOOKUP_TYPE = 'AHL_INSTANCE_ROUTING'
12446: AND LOOKUP_CODE = c_inst_routing_code
12447: AND NVL(ENABLED_FLAG,'N') = 'Y'

Line 12688: l_sql_string := 'SELECT AW.WORKORDER_ID, AW.WORKORDER_NAME, AW.STATUS_CODE, FLV.MEANING WO_STATUS FROM AHL_WORKORDERS AW, FND_LOOKUP_VALUES_VL FLV WHERE AW.STATUS_CODE = FLV.LOOKUP_CODE AND FLV.LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND WORKORDER_ID IN (0';

12684: END IF;
12685: RETURN;
12686: END IF;
12687:
12688: l_sql_string := 'SELECT AW.WORKORDER_ID, AW.WORKORDER_NAME, AW.STATUS_CODE, FLV.MEANING WO_STATUS FROM AHL_WORKORDERS AW, FND_LOOKUP_VALUES_VL FLV WHERE AW.STATUS_CODE = FLV.LOOKUP_CODE AND FLV.LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND WORKORDER_ID IN (0';
12689:
12690: FOR i IN p_workorder_id_tbl.first .. p_workorder_id_tbl.last
12691: LOOP
12692: l_sql_string := l_sql_string || ',' || p_workorder_id_tbl(i).WORKORDER_ID;