View: CSR_TIMERS_V

Product:	CSR - Scheduler
Description:	View which calculates the timing information from CSR_TIMERS_B which contains raw timing data
Implementation/DBA Data:	APPS.CSR_TIMERS_V

View Text

SELECT SEQ
, NAME
, 'TIME' MEANING
, SUM(NVL(VALUE
, 0)) VALUE
FROM CSR_TIMERS_B
WHERE UPPER(MEANING) = 'TIME' GROUP BY SEQ
, NAME
, MEANING UNION SELECT SEQ
, NAME
, 'COUNT' MEANING
, SUM(NVL(VALUE
, 0)) VALUE
FROM CSR_TIMERS_B
WHERE UPPER(MEANING) = 'COUNT' GROUP BY SEQ
, NAME
, MEANING UNION SELECT SEQ
, NAME
, MEANING
, VALUE
FROM CSR_TIMERS_B
WHERE UPPER(MEANING) = 'ID' UNION SELECT 120
, ' > TOTAL FORMS BEFORE
AND AFTER RETRIEVING RESOURCES'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99
AND SEQ NOT BETWEEN 105
AND 115 UNION SELECT 130
, ' > TOTAL RETRIEVING QUALIFIED RESOURCES'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 105
AND 115 UNION SELECT 990
, ' > TOTAL AFTER PRESSING SEARCH BUTTON'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99 UNION SELECT 1391
, ' > TOTAL LOADING TRIPS'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1300
AND 1390 UNION SELECT 1392
, ' > NUMBER OF LOADED TRIPS'
, 'COUNT'
, COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 1340 UNION SELECT 1393
, ' > AVERAGE LOADED TRIP'
, 'TIME'
, NVL( ( SELECT SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1300
AND 1390 ) / ( SELECT COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 1340 )
, 0 )
FROM DUAL
WHERE EXISTS ( SELECT ''
FROM CSR_TIMERS_B
WHERE SEQ = 1340 ) UNION SELECT 1395
, ' > NUMBER OF RESOURCES ANALYZED'
, 'COUNT'
, COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 1330 UNION SELECT 1430
, ' > TOTAL CALCULATING ROUTES'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1431
AND 1439 UNION SELECT 1491
, ' > TOTAL CALCULATING PLAN OPTIONS'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1400
AND 1490 UNION SELECT 1492
, ' > NUMBER OF PLAN OPTIONS ANALYZED'
, 'COUNT'
, COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 1450 UNION SELECT 1493
, ' > NUMBER OF ROUTE CALCULATIONS'
, 'COUNT'
, COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 1439 UNION SELECT 1494
, ' > AVERAGE TDS ROUTE CALCULATION'
, 'TIME'
, NVL( ( SELECT SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1431
AND 1439 ) / ( SELECT COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ = 9603 )
, 0 )
FROM DUAL
WHERE EXISTS ( SELECT ''
FROM CSR_TIMERS_B
WHERE SEQ = 9603 ) UNION SELECT 9100
, ' > TOTAL SCHEDULER JAVA-CORE (PLAN OPTIONS)'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 8999 UNION SELECT 9200
, ' > NUMBER OF TIMING MARKS
AND INFOS IN JAVA-CORE (PLAN OPTIONS)'
, 'COUNT'
, COUNT(*)
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 9999 UNION SELECT 11900
, ' > SENDING OPTIONS TO FORMS
, COMMUNICATION'
, 'TIME'
, ( SELECT SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (11000
, 11100) ) - ( SELECT SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 8999 )
FROM DUAL UNION SELECT 99100
, ' > TOTAL AFTER SENDING OPTIONS TO FORMS'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ > 11100 UNION SELECT 99200
, ' > TOTAL TIME SPENT IN FORMS'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM CSR_TIMERS_B
WHERE ( SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99 ) OR SEQ > 11000 UNION ALL SELECT 99300
, ' > GRAND TOTAL'
, 'TIME'
, SUM(NVL(VALUE
, 0))
FROM ( SELECT VALUE
FROM CSR_TIMERS_B
WHERE EXISTS ( SELECT NULL
FROM CSR_TIMERS_B
WHERE SEQ = 1150 )
AND SEQ BETWEEN 1000
AND 8999 UNION ALL SELECT VALUE
FROM CSR_TIMERS_B
WHERE NOT EXISTS ( SELECT NULL
FROM CSR_TIMERS_B
WHERE SEQ = 1150 )
AND ( ( SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99 ) OR SEQ > 10000 ) )

Columns