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_AMP_REQUESTS_V

Line 281: from Fnd_amp_requests_v rv,

277: end if;
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'

Line 295: Fnd_amp_requests_v rv,

291: Fnd_User U,
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'

Line 338: From Fnd_amp_requests_v rv,

334: end if;
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'

Line 352: Fnd_amp_requests_v rv,

348: Fnd_User U,
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'

Line 611: from Fnd_amp_requests_v rv,

607: PROCEDURE refresh_pending_req_user
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'

Line 679: from Fnd_amp_requests_v rv,

675: PROCEDURE refresh_pending_req_app
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'

Line 749: from Fnd_amp_requests_v rv,

745: PROCEDURE refresh_pending_req_resp
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'