APPS.FND_OAM_EM dependencies on FND_APPLICATION_VL

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 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