FND Design Data [Home] [Help]

View: AP_AUD_QUEUE_SUMMARIES_V

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.AP_AUD_QUEUE_SUMMARIES_V
View Text

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

Columns

Name
AUDITOR_ID
CURRENT_TOTAL_WORKLOAD
COUNT_REPORT_WEIGHTS
COUNT_REPORTS