DBA Data[Home] [Help]

VIEW: APPS.AP_AUD_QUEUE_SUMMARIES_V

Source

View Text - Preformatted

SELECT AUDITOR_ID, SUM(REPORT_WEIGHT) AS CURRENT_TOTAL_WORKLOAD, count(REPORT_WEIGHT) AS COUNT_REPORT_WEIGHTS, count(*) AS COUNT_REPORTS FROM AP_AUD_QUEUES GROUP BY AUDITOR_ID
View Text - HTML Formatted

SELECT AUDITOR_ID
, SUM(REPORT_WEIGHT) AS CURRENT_TOTAL_WORKLOAD
, COUNT(REPORT_WEIGHT) AS COUNT_REPORT_WEIGHTS
, COUNT(*) AS COUNT_REPORTS
FROM AP_AUD_QUEUES GROUP BY AUDITOR_ID