eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISITS_PVT dependencies on FND_LOOKUPS

Line 1294: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP

1290: --TCHIMIRA::P2P CP ER 9151144::02-DEC-2009
1291: --Cursor to fetch CP related details
1292: CURSOR c_conc_req_details(x_cp_req_id IN NUMBER) IS
1293: SELECT FLS.MEANING CP_STATUS_CODE, FLP.MEANING CP_PHASE_CODE, FCR.REQUEST_DATE CP_REQUEST_DATE
1294: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP
1295: WHERE FCR.REQUEST_ID = x_cp_req_id
1296: AND ((FCR.STATUS_CODE = FLS.LOOKUP_CODE
1297: AND FLS.LOOKUP_TYPE = 'CP_STATUS_CODE')
1298: AND (FCR.PHASE_CODE = FLP.LOOKUP_CODE

Line 1383: -- To find meaning for fnd_lookups code

1379: --l_visit_rec.workorder_id := l_workorder_id;
1380: END IF;
1381: CLOSE c_workorder_csr;
1382:
1383: -- To find meaning for fnd_lookups code
1384: IF (visit_rec.project_flag IS NOT NULL) THEN
1385: SELECT MEANING INTO l_project_flag
1386: FROM FND_LOOKUP_VALUES_VL
1387: WHERE LOOKUP_CODE = visit_rec.project_flag