APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 957: FROM FND_LOOKUP_VALUES_VL

953:
954: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
955: IS
956: SELECT lookup_code
957: FROM FND_LOOKUP_VALUES_VL
958: WHERE lookup_code = c_lookup_code
959: AND lookup_type = c_lookup_type
960: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
961: AND NVL(end_date_active,SYSDATE);

Line 1042: FND_LOOKUP_VALUES_VL FNDL

1038: IS
1039: SELECT AWOS.status_code,
1040: FNDL.meaning
1041: FROM AHL_WORKORDERS AWOS,
1042: FND_LOOKUP_VALUES_VL FNDL
1043: WHERE AWOS.WORKORDER_ID = c_workorder_id
1044: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
1045: AND FNDL.lookup_code(+) = AWOS.status_code;
1046: -- cursor to retrieve minimum actual start date and maximum actual

Line 3413: FND_LOOKUP_VALUES_VL FNDL

3409: SELECT AWOS.status_code,
3410: AWOS.workorder_name,
3411: FNDL.meaning
3412: FROM AHL_WORKORDERS AWOS,
3413: FND_LOOKUP_VALUES_VL FNDL
3414: WHERE AWOS.WORKORDER_ID = c_workorder_id
3415: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
3416: AND FNDL.lookup_code(+) = AWOS.status_code;
3417: -- Bug # 6680137 -- end

Line 3677: FROM fnd_lookup_values_vl

3673: CLOSE get_wo_status;
3674:
3675: --Get status meaning
3676: SELECT meaning INTO l_status_meaning
3677: FROM fnd_lookup_values_vl
3678: WHERE lookup_type = 'AHL_JOB_STATUS'
3679: AND LOOKUP_CODE = p_x_prd_workorder_rec.status_code;
3680: -- Bug # 6680137 -- end
3681: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');

Line 6386: FROM fnd_lookup_values_vl

6382: l_status_code = G_JOB_STATUS_DELETED ) THEN
6383:
6384: --Get status meaning
6385: SELECT meaning INTO l_status_meaning
6386: FROM fnd_lookup_values_vl
6387: WHERE lookup_type = 'AHL_JOB_STATUS'
6388: AND LOOKUP_CODE = l_status_code;
6389: --
6390: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_VISIT_STATUS');

Line 6542: FROM fnd_lookup_values_vl

6538: l_status_code = G_JOB_STATUS_CLOSED OR
6539: l_status_code = G_JOB_STATUS_DELETED ) THEN
6540: --Get status meaning
6541: SELECT meaning INTO l_status_meaning
6542: FROM fnd_lookup_values_vl
6543: WHERE lookup_type = 'AHL_JOB_STATUS'
6544: AND LOOKUP_CODE = l_status_code;
6545:
6546: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_MR_STATUS');

Line 6904: FROM fnd_lookup_values_vl

6900: l_status_code = G_JOB_STATUS_CLOSED OR
6901: l_status_code = G_JOB_STATUS_DELETED ) THEN
6902: --Get status meaning
6903: SELECT meaning INTO l_status_meaning
6904: FROM fnd_lookup_values_vl
6905: WHERE lookup_type = 'AHL_JOB_STATUS'
6906: AND LOOKUP_CODE = l_status_code;
6907:
6908: FND_MESSAGE.set_name('AHL','AHL_PRD_CANCEL_WO_STATUS');