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_VISIT_CST_PR_PVT dependencies on FND_LOOKUPS

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

87: --salogan::Added Cursor to fetch conc request details CP ER 9299910::01-JUN-2009::BEGIN
88: CURSOR c_conc_req_details(x_cp_req_id IN NUMBER) IS
89: SELECT FLS.MEANING CP_STATUS, FLP.MEANING CP_PHASE, FCR.REQUEST_DATE CP_REQUEST_DATE
90: , FCR.PHASE_CODE CP_PHASE_CODE
91: FROM FND_CONCURRENT_REQUESTS FCR, FND_LOOKUPS FLS, FND_LOOKUPS FLP
92: WHERE FCR.REQUEST_ID = x_cp_req_id
93: AND ((FCR.STATUS_CODE = FLS.LOOKUP_CODE
94: AND FLS.LOOKUP_TYPE = 'CP_STATUS_CODE')
95: AND (FCR.PHASE_CODE = FLP.LOOKUP_CODE