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.FND_OAM_CPCHARTS_COL dependencies on FND_LOOKUPS

Line 282: Fnd_lookups l

278:
279: if(p_metric_name = 'REQ_PENDING') then
280: select count(rv.Request_ID) into ct_pending
281: from Fnd_amp_requests_v rv,
282: Fnd_lookups l
283: Where rv.phase_code = 'P'
284: and l.meaning = rv.phase
285: and l.lookup_code = 'P'
286: and l.lookup_type = 'CP_PHASE_CODE';

Line 296: Fnd_lookups l

292: Fnd_Concurrent_Requests R,
293: Fnd_Responsibility_Tl RES,
294: Fnd_Application A,
295: Fnd_amp_requests_v rv,
296: Fnd_lookups l
297: Where rv.phase_code = 'P'
298: and l.meaning = rv.phase
299: and l.lookup_code = 'P'
300: and l.lookup_type = 'CP_PHASE_CODE'

Line 339: Fnd_lookups l

335:
336: if(p_metric_name = 'REQ_INACTIVE') then
337: select count(rv.Request_ID) into ct_inactive
338: From Fnd_amp_requests_v rv,
339: Fnd_lookups l
340: Where rv.phase_code = 'P'
341: and l.meaning = rv.phase
342: and l.lookup_code = 'I'
343: and l.lookup_type = 'CP_PHASE_CODE';

Line 353: Fnd_lookups l

349: Fnd_Concurrent_Requests R,
350: Fnd_Responsibility_Tl RES,
351: Fnd_Application A,
352: Fnd_amp_requests_v rv,
353: Fnd_lookups l
354: Where rv.phase_code = 'P'
355: and l.meaning = rv.phase
356: and l.lookup_code = 'I'
357: and l.lookup_type = 'CP_PHASE_CODE'

Line 612: Fnd_lookups l

608: IS
609: cursor req_c is
610: select count(rv.Request_ID) count, user_name
611: from Fnd_amp_requests_v rv,
612: Fnd_lookups l
613: Where rv.phase_code = 'P'
614: and l.meaning = rv.phase
615: and l.lookup_code = 'P'
616: and l.lookup_type = 'CP_PHASE_CODE'

Line 680: Fnd_lookups l

676: IS
677: cursor req_c is
678: select count(rv.Request_ID) count, application_name
679: from Fnd_amp_requests_v rv,
680: Fnd_lookups l
681: Where rv.phase_code = 'P'
682: and l.meaning = rv.phase
683: and l.lookup_code = 'P'
684: and l.lookup_type = 'CP_PHASE_CODE'

Line 750: Fnd_lookups l

746: IS
747: cursor req_c is
748: select count(rv.Request_ID) count, responsibility_name
749: from Fnd_amp_requests_v rv,
750: Fnd_lookups l
751: Where rv.phase_code = 'P'
752: and l.meaning = rv.phase
753: and l.lookup_code = 'P'
754: and l.lookup_type = 'CP_PHASE_CODE'