APPS.FND_OAM_COLLECTION dependencies on FND_CONCURRENT_QUEUES

Line 733: from fnd_cp_services fcs, fnd_concurrent_queues fcq

729: select
730: fcq.application_id application_id,
731: fcq.concurrent_queue_id concurrent_queue_id,
732: fcq.concurrent_queue_name concurrent_queue_name
733: from fnd_cp_services fcs, fnd_concurrent_queues fcq
734: where
735: fcs.service_id = to_number(fcq.manager_type)
736: and fcs.server_type in (v_server_type, 'E')
737: and upper(fcq.target_node) = upper(v_node_name)

Line 1430: from fnd_concurrent_queues_vl

1426: if (is_collection_enabled('SERVICES_UP')) then
1427: -- Now get the number of Services Up
1428: select count(concurrent_queue_id)
1429: into ct_services_up
1430: from fnd_concurrent_queues_vl
1431: where running_processes = max_processes and max_processes > 0;
1432:
1433: -- Update Services Up
1434: update_metric_internal('SERVICES_UP', to_char(ct_services_up), 0);

Line 1441: from fnd_concurrent_queues_vl

1437: if (is_collection_enabled('SERVICES_DOWN')) then
1438: -- Get the number of services down
1439: select count(concurrent_queue_id)
1440: into ct_services_down
1441: from fnd_concurrent_queues_vl
1442: where running_processes = 0 and max_processes > 0;
1443:
1444: -- Update Services down
1445: update_metric_internal('SERVICES_DOWN', to_char(ct_services_down), 2);

Line 1934: fnd_concurrent_queues fcq,

1930: foa.concurrent_queue_name concurrent_queue_name,
1931: fcq.concurrent_queue_id concurrent_queue_id,
1932: foa.status_code status_code
1933: from fnd_oam_app_sys_status foa,
1934: fnd_concurrent_queues fcq,
1935: fnd_oam_svci_info fsi
1936: where foa.application_id = fcq.application_id
1937: and foa.concurrent_queue_name = fcq.concurrent_queue_name
1938: and foa.application_id = fsi.application_id (+)