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_EM dependencies on FND_CONCURRENT

Line 24: from fnd_concurrent_queues_vl q, fnd_application_vl a,

20: a.application_name srvc_app_name,
21: a.application_short_name srvc_app_short_name,
22: q.concurrent_queue_name srvc_short_name,
23: s.service_handle srvc_handle
24: from fnd_concurrent_queues_vl q, fnd_application_vl a,
25: fnd_cp_services s
26: where q.application_id = a.application_id
27: and s.service_id = q.manager_type;
28:

Line 129: fnd_concurrent_queues_vl fcq,

125: decode(foa.type,NULL,'N/A',foa.type),
126: decode(fcq.manager_type,NULL,'N/A',fcq.manager_type)
127:
128: FROM fnd_oam_app_sys_status foa,
129: fnd_concurrent_queues_vl fcq,
130: FND_OAM_FNDNODES_VL fn,
131: fnd_lookups fl
132: WHERE foa.application_id = fcq.application_id (+)
133: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)

Line 395: FROM fnd_concurrent_processes

391:
392:
393: SELECT to_char(count(*))
394: INTO SERVICE_PROCS
395: FROM fnd_concurrent_processes
396: WHERE process_status_code in ('R','A','P','C','M','D','T');
397:
398: SELECT to_char(count(*))
399: INTO RUNNING_REQ

Line 400: FROM fnd_concurrent_requests

396: WHERE process_status_code in ('R','A','P','C','M','D','T');
397:
398: SELECT to_char(count(*))
399: INTO RUNNING_REQ
400: FROM fnd_concurrent_requests
401: WHERE phase_code = 'R';
402:
403: OPEN ret FOR
404: SELECT ACTIVE_USERS,

Line 462: fnd_concurrent_queues_vl fcq,

458:
459: FOR pair_1 IN
460: ( SELECT foa.status_code sta
461: FROM fnd_oam_app_sys_status foa,
462: fnd_concurrent_queues_vl fcq,
463: FND_OAM_FNDNODES_VL fn,
464: fnd_lookups fl
465: WHERE foa.application_id = fcq.application_id (+)
466: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)

Line 515: FROM fnd_concurrent_requests r, fnd_application_vl a

511: OPEN ret FOR
512: select asn,an,to_char(sum(nac)),to_char(sum(ac)) from
513: (
514: SELECT a.application_short_name asn, a.application_name an, COUNT(*) nac, 0 ac
515: FROM fnd_concurrent_requests r, fnd_application_vl a
516: WHERE r.program_application_id = a.application_id
517: AND phase_code in ('P', 'R')
518: AND r.resubmit_time is null
519: GROUP BY a.application_short_name,a.application_name

Line 522: FROM fnd_concurrent_requests r, fnd_application_vl a

518: AND r.resubmit_time is null
519: GROUP BY a.application_short_name,a.application_name
520: UNION ALL
521: SELECT a.application_short_name asn, a.application_name an, 0 nac, COUNT(*) ac
522: FROM fnd_concurrent_requests r, fnd_application_vl a
523: WHERE r.program_application_id = a.application_id
524: AND phase_code in ('P', 'R')
525: AND r.resubmit_time is not null
526: GROUP BY a.application_short_name,a.application_name

Line 545: FROM fnd_concurrent_requests

541: c.c/decode(a.a+b.b+c.c, 0, 1, a.a+b.b+c.c)*100
542: FROM
543: (
544: SELECT COUNT(*) a
545: FROM fnd_concurrent_requests
546: WHERE phase_code = 'C' AND status_code = 'C'
547: AND actual_completion_date between (sysdate - 1/24) and sysdate
548: ) a,
549: (

Line 551: FROM fnd_concurrent_requests

547: AND actual_completion_date between (sysdate - 1/24) and sysdate
548: ) a,
549: (
550: SELECT COUNT(*) b
551: FROM fnd_concurrent_requests
552: WHERE phase_code = 'C' AND status_code = 'G'
553: AND actual_completion_date between (sysdate - 1/24) and sysdate
554: ) b,
555: (

Line 557: FROM fnd_concurrent_requests

553: AND actual_completion_date between (sysdate - 1/24) and sysdate
554: ) b,
555: (
556: SELECT COUNT(*) c
557: FROM fnd_concurrent_requests
558: WHERE phase_code = 'C' AND status_code = 'E'
559: AND actual_completion_date between (sysdate - 1/24) and sysdate
560: ) c ;
561:

Line 610: FROM fnd_concurrent_requests

606:
607: BEGIN
608: FOR p_r_pair_1 IN
609: ( SELECT count(*) prc, status_code
610: FROM fnd_concurrent_requests
611: WHERE status_code IN ('I', 'Q' )
612: AND requested_start_date <= sysdate
613: AND phase_code = 'P'
614: AND hold_flag = 'N'

Line 628: FROM fnd_concurrent_requests

624:
625:
626: FOR p_r_pair_2 IN
627: ( SELECT count(*) prc
628: FROM fnd_concurrent_requests
629: WHERE phase_code = 'P'
630: AND hold_flag = 'N'
631: AND ( (status_code = 'P' )
632: OR ( status_code IN( 'I', 'Q')

Line 643: FROM fnd_concurrent_requests

639: END LOOP;
640:
641: FOR p_r_pair_3 IN
642: ( SELECT count(*) prc
643: FROM fnd_concurrent_requests
644: WHERE status_code IN( 'R', 'T')
645: )
646: LOOP
647: running_ct := p_r_pair_3.prc;

Line 652: FROM fnd_concurrent_requests

648: END LOOP;
649:
650: FOR p_r_pair_4 IN
651: ( SELECT count(*) prc
652: FROM fnd_concurrent_requests
653: WHERE phase_code = 'P' AND status_code = 'M'
654: )
655: LOOP
656: no_manager_ct := p_r_pair_4.prc;

Line 661: FROM fnd_concurrent_requests

657: END LOOP;
658:
659: FOR p_r_pair_5 IN
660: ( SELECT count(*) prc
661: FROM fnd_concurrent_requests
662: WHERE phase_code = 'P' AND hold_flag = 'Y'
663: )
664: LOOP
665: on_hold_ct := p_r_pair_5.prc;

Line 695: from fnd_concurrent_processes cp

691: ( SELECT user_concurrent_queue_name r_n,
692: fnd_conc_request_pkg.running_requests(concurrent_queue_name,
693: application_id) r_c,
694: (select count(*)
695: from fnd_concurrent_processes cp
696: where cp.queue_application_id = cq.application_id
697: and cp.concurrent_queue_id = cq.concurrent_queue_id
698: and (cp.process_status_code in ('C','M')
699: or (cp.process_status_code in ('A', 'D', 'T')

Line 708: FROM fnd_concurrent_queues_vl CQ,

704: ) a_p,
705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,
706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c
707:
708: FROM fnd_concurrent_queues_vl CQ,
709: WHERE manager_type = 1
710: ORDER BY decode(CQ.control_code, 'X',2,'E',2,1), user_concurrent_queue_name
711: )
712: LOOP

Line 746: ' FROM Fnd_concurrent_worker_requests '||

742: sql_stmt VARCHAR2(1024);
743:
744: BEGIN
745: sql_stmt := 'SELECT count(R.Request_ID) rc '||
746: ' FROM Fnd_concurrent_worker_requests '||
747: ' WHERE phase_code = ''P'''||
748: ' AND status_code = :status_code'||
749: ' AND queue_application_id = :app_id'||
750: ' AND concurrent_queue_id = :mgr_id'||

Line 839: FROM fnd_concurrent_processes p, v$session ws, v$lock wl, v$lock hl ,

835: hl.ctime,
836: hl.type, to_char(hl.id1), to_char(hl.id2),
837: DECODE(hl.lmode, 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE',
838: 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?')
839: FROM fnd_concurrent_processes p, v$session ws, v$lock wl, v$lock hl ,
840: v$session hs
841: WHERE p.queue_application_id = 0 AND p.concurrent_queue_id IN (1,4)
842: AND p.session_id = ws.audsid AND ws.lockwait IS NOT NULL
843: AND ws.lockwait = wl.kaddr AND wl.id1 = hl.id1 AND wl.id2 = hl.id2

Line 896: fnd_concurrent.get_manager_status(APPLID=>appId, MANAGERID=>mgrId, targetp =>target, activep=>active, pmon_method =>pmon, callstat =>stat);

892: BEGIN
893: appId :=0;
894: mgrId :=1;
895:
896: fnd_concurrent.get_manager_status(APPLID=>appId, MANAGERID=>mgrId, targetp =>target, activep=>active, pmon_method =>pmon, callstat =>stat);
897: --dbms_output.put_line('stat=' || stat);
898: --dbms_output.put_line('active=' || active);
899: --dbms_output.put_line('target=' || target);
900: --dbms_output.put_line('pmon=' || pmon);

Line 926: fnd_concurrent.get_manager_status(APPLID=>appId, MANAGERID=>mgrId, targetp =>target, activep=>active, pmon_method =>pmon, callstat =>stat);

922: BEGIN
923: appId :=0;
924: mgrId :=0;
925:
926: fnd_concurrent.get_manager_status(APPLID=>appId, MANAGERID=>mgrId, targetp =>target, activep=>active, pmon_method =>pmon, callstat =>stat);
927: --dbms_output.put_line('stat=' || stat);
928: --dbms_output.put_line('active=' || active);
929: --dbms_output.put_line('target=' || target);
930: --dbms_output.put_line('pmon=' || pmon);