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_CONCURRENT

Line 272: from fnd_concurrent_requests

268: BEGIN
269:
270: if(p_metric_name = 'REQ_RUNNING') then
271: select count(*) into ct_running
272: from fnd_concurrent_requests
273: where status_code = 'R';
274:
275: -- Update the number of running requests, use 0 for the metric_context
276: update_metric_internal(p_metric_name, '0', ct_running);

Line 290: from Fnd_Concurrent_Programs_vl CP,

286: and l.lookup_type = 'CP_PHASE_CODE';
287:
288: /*query from old request java code:
289: select count(distinct(R.Request_ID)) into ct_pending
290: from Fnd_Concurrent_Programs_vl CP,
291: Fnd_User U,
292: Fnd_Concurrent_Requests R,
293: Fnd_Responsibility_Tl RES,
294: Fnd_Application A,

Line 292: Fnd_Concurrent_Requests R,

288: /*query from old request java code:
289: select count(distinct(R.Request_ID)) into ct_pending
290: from Fnd_Concurrent_Programs_vl CP,
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

Line 318: from fnd_concurrent_requests

314: end if;
315:
316: if(p_metric_name = 'REQ_COMPLETED') then
317: select count(*) into ct_completed
318: from fnd_concurrent_requests
319: where phase_code = 'C' and (sysdate - actual_completion_date)*1440 <= 60;
320:
321: -- update the number of COMPLETED requests in the last 1 hour, use 0 for the metric_context
322: update_metric_internal(p_metric_name, '0', ct_completed);

Line 327: from fnd_concurrent_requests r, GV$SESSION WS

323: end if;
324:
325: if(p_metric_name = 'REQ_WAITING_ON_LOCK') then
326: select count(*) into ct_waiting_on_lock
327: from fnd_concurrent_requests r, GV$SESSION WS
328: where r.phase_code = 'R'
329: and r.oracle_session_id = WS.AUDSID
330: and WS.LOCKWAIT IS NOT NULL;
331:

Line 347: From Fnd_Concurrent_Programs_vl CP,

343: and l.lookup_type = 'CP_PHASE_CODE';
344:
345: /* query from old request java code:
346: select count(distinct(R.Request_ID)) into ct_inactive
347: From Fnd_Concurrent_Programs_vl CP,
348: Fnd_User U,
349: Fnd_Concurrent_Requests R,
350: Fnd_Responsibility_Tl RES,
351: Fnd_Application A,

Line 349: Fnd_Concurrent_Requests R,

345: /* query from old request java code:
346: select count(distinct(R.Request_ID)) into ct_inactive
347: From Fnd_Concurrent_Programs_vl CP,
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

Line 398: FROM fnd_concurrent_requests

394: PROCEDURE refresh_completed_req_status
395: IS
396: cursor req_c is
397: SELECT count(*) count, status_code
398: FROM fnd_concurrent_requests
399: WHERE status_code IN ('C', 'G', 'E', 'X' )
400: AND ((sysdate - actual_completion_date) * (1440)) <= 60
401: GROUP BY status_code;
402:

Line 465: FROM fnd_concurrent_requests

461: PROCEDURE refresh_pending_req_status
462: IS
463: cursor req_c is
464: SELECT count(*) count, status_code
465: FROM fnd_concurrent_requests
466: WHERE (status_code IN ('I', 'Q')
467: AND requested_start_date <= sysdate
468: AND phase_code = 'P'
469: AND hold_flag = 'N')

Line 490: FROM fnd_concurrent_requests

486: end if;
487: end loop;
488:
489: SELECT count(*) into ct_scheduled
490: FROM fnd_concurrent_requests
491: WHERE (phase_code = 'P' AND hold_flag = 'N')
492: AND ( (status_code = 'P' )
493: OR (status_code IN( 'I', 'Q')
494: AND requested_start_date > sysdate ));

Line 533: from fnd_concurrent_requests

529: ct_long number := 0;
530: BEGIN
531:
532: select count(*) into ct_10min
533: from fnd_concurrent_requests
534: where ((sysdate - actual_start_date) * (1440)) <= 10
535: and status_code in ('R');
536:
537: select count(*) into ct_60min

Line 538: from fnd_concurrent_requests

534: where ((sysdate - actual_start_date) * (1440)) <= 10
535: and status_code in ('R');
536:
537: select count(*) into ct_60min
538: from fnd_concurrent_requests
539: where ((sysdate - actual_start_date) * (1440)) between 10 and 60
540: and status_code in ('R');
541:
542: select count(*) into ct_long

Line 543: from fnd_concurrent_requests

539: where ((sysdate - actual_start_date) * (1440)) between 10 and 60
540: and status_code in ('R');
541:
542: select count(*) into ct_long
543: from fnd_concurrent_requests
544: where ((sysdate - actual_start_date) * (1440)) >= 60
545: and status_code in ('R');
546:
547: -- update the number of running requests with duration less than 10 minutes, use 0 for the metric_context

Line 577: from fnd_concurrent_requests, fnd_user

573: PROCEDURE refresh_running_req_user
574: IS
575: cursor req_c is
576: select count(*) count, user_name
577: from fnd_concurrent_requests, fnd_user
578: where requested_by = user_id and status_code = 'R'
579: group by user_name;
580:
581: BEGIN

Line 647: from fnd_concurrent_requests r, fnd_application_vl v

643: PROCEDURE refresh_running_req_app
644: IS
645: cursor req_c is
646: select count(*) count, application_name
647: from fnd_concurrent_requests r, fnd_application_vl v
648: where r.program_application_id = v.application_id and status_code = 'R'
649: group by application_name;
650:
651: BEGIN

Line 716: from fnd_concurrent_requests r, fnd_responsibility_vl v

712: PROCEDURE refresh_running_req_resp
713: IS
714: cursor req_c is
715: select count(*) count, responsibility_name
716: from fnd_concurrent_requests r, fnd_responsibility_vl v
717: where r.responsibility_application_id = v.application_id
718: and r.responsibility_id = v.responsibility_id and status_code = 'R'
719: group by responsibility_name;
720:

Line 786: from fnd_concurrent_worker_requests r

782: IS
783: ct_running number := 0;
784: BEGIN
785: select count(*) into ct_running
786: from fnd_concurrent_worker_requests r
787: where queue_application_id = p_queue_application_id
788: and concurrent_queue_name = p_concurrent_queue_name
789: and status_code = 'R';
790:

Line 813: from fnd_concurrent_worker_requests r

809: ct_pending number := 0;
810: BEGIN
811: --sql suggested by mike.
812: select count(*) into ct_pending
813: from fnd_concurrent_worker_requests r
814: where queue_application_id = p_queue_application_id
815: and concurrent_queue_name = p_concurrent_queue_name
816: and status_code = 'I' and hold_flag <> 'Y'
817: and requested_start_date <= sysdate;

Line 841: from fnd_concurrent_queues_vl

837: IS
838: ct_process number :=0;
839: BEGIN
840: select running_processes into ct_process
841: from fnd_concurrent_queues_vl
842: where application_id = p_queue_application_id
843: and concurrent_queue_name = p_concurrent_queue_name;
844:
845: update_metric_internal('RUNNING_PROCESS_MANAGER', p_user_concurrent_queue_name, ct_process);

Line 871: from fnd_concurrent_queues_vl

867: PROCEDURE refresh_run_req_process_mgr
868: IS
869: cursor mgr_c is
870: select application_id, concurrent_queue_name, user_concurrent_queue_name
871: from fnd_concurrent_queues_vl
872: where manager_type = 1;
873: BEGIN
874:
875: --Delete entries for running request count and running process count for all managers.

Line 903: from fnd_concurrent_queues_vl

899: PROCEDURE refresh_pend_req_mgr
900: IS
901: cursor mgr_c is
902: select application_id, concurrent_queue_name, user_concurrent_queue_name
903: from fnd_concurrent_queues_vl
904: where manager_type = 1;
905: BEGIN
906:
907: --Delete entries for pending request count for all managers.

Line 934: FROM fnd_concurrent_requests r

930: cursor s24h_c is
931: SELECT r.requested_by user_id,
932: count(r.actual_completion_date) count,
933: sum(r.actual_completion_date-nvl(r.actual_start_date,r.requested_start_date))*24*3600 runtime --in seconds
934: FROM fnd_concurrent_requests r
935: WHERE r.phase_code = 'C'
936: and (sysdate - r.actual_completion_date) <= 1
937: group by r.requested_by;
938:

Line 943: FROM fnd_concurrent_requests r

939: cursor s7day_c is
940: SELECT r.requested_by user_id,
941: count(r.actual_completion_date) count,
942: sum(r.actual_completion_date-nvl(r.actual_start_date,r.requested_start_date))*24*3600 runtime --in seconds
943: FROM fnd_concurrent_requests r
944: WHERE r.phase_code = 'C'
945: and (sysdate - r.actual_completion_date) <= 7
946: group by r.requested_by;
947:

Line 952: FROM fnd_concurrent_requests r

948: cursor s31day_c is
949: SELECT r.requested_by user_id,
950: count(r.actual_completion_date) count,
951: sum(r.actual_completion_date-nvl(r.actual_start_date,r.requested_start_date))*24*3600 runtime --in seconds
952: FROM fnd_concurrent_requests r
953: WHERE r.phase_code = 'C'
954: and (sysdate - r.actual_completion_date) <= 31
955: group by r.requested_by;
956:

Line 999: FROM fnd_concurrent_requests r

995: round(avg(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) ave, -- in seconds
996: round(min(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) minimum, -- in seconds
997: round(max(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) maximum, -- in seconds
998: count(*) count
999: FROM fnd_concurrent_requests r
1000: WHERE r.phase_code = 'C'
1001: and r.actual_completion_date is not null
1002: and r.actual_start_date is not null
1003: and (sysdate - r.actual_completion_date) <= 1

Line 1013: FROM fnd_concurrent_requests r

1009: round(avg(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) ave,
1010: round(min(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) minimum,
1011: round(max(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) maximum,
1012: count(*) count
1013: FROM fnd_concurrent_requests r
1014: WHERE r.phase_code = 'C'
1015: and r.actual_completion_date is not null
1016: and r.actual_start_date is not null
1017: and (sysdate - r.actual_completion_date) <= 7

Line 1027: FROM fnd_concurrent_requests r

1023: round(avg(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) ave,
1024: round(min(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) minimum,
1025: round(max(greatest(actual_completion_date-actual_start_date,0))*3600*24, 0) maximum,
1026: count(*) count
1027: FROM fnd_concurrent_requests r
1028: WHERE r.phase_code = 'C'
1029: and r.actual_completion_date is not null
1030: and r.actual_start_date is not null
1031: and (sysdate - r.actual_completion_date) <= 31

Line 1171: fnd_concurrent.get_request_status(

1167: BEGIN
1168: -- First query to see if there is a request already submitted for this
1169: -- program.
1170: outcome :=
1171: fnd_concurrent.get_request_status(
1172: request_id=>p_request_id,
1173: appl_shortname=>'FND',
1174: program=>'OAMCHARTCOL',
1175: phase=>p_phase,