APPS.FND_OAM_EM dependencies on FND_CONCURRENT_QUEUES_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 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 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 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