APPS.FND_OAM_COLLECTION dependencies on FND_CONCURRENT_QUEUES_VL

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