Overcommitted Resource Hours: Overcommitted Resource Hours by GL Period

Description
Categories: Discoverer
Columns: E257595, E257600, E257608, E257618, E257672, E257858, E257862, E 367, E 373, E257535 Sum ...
The overcommitted resource hours workbook allows you to evaluate the number of hours people are currently scheduled over their capacity.
Owner: SYSADMIN (System Administrator)
Identifier: PAOVCRES
SELECT  i257595 as E257595,i257600 as E257600,i257608 as E257608,i257618 as E257618,i257672 as E257672,i257858 as E257858,i257862 as E257862,(DECODE(SIGN(NVL((SUM(in349) ),0)-NVL((SUM(i257535) ),0)),-1,0,NVL((SUM(in349) ),0)-NVL((SUM(i257535) ),0)) )/DECODE(NVL((SUM(i257535) ),1),0,1,NVL((SUM(i257535) ),1))*100 as E_367,DECODE(SIGN(NVL((SUM(in349) ),0)-NVL((SUM(i257535) ),0)),-1,0,NVL((SUM(in349) ),0)-NVL((SUM(i257535) ),0)) as E_373,SUM(i257535) as E257535_SUM,SUM(in349) as "E-349_SUM",i257854 as E257854
 FROM (SELECT SUM(i257547) AS in349, i257849 AS in355, i257596 AS in357, i257605 AS in359 FROM (SELECT CONFIRMED_HOURS AS i257547, GL_PERIOD AS i257596, GL_PERIOD_SET_NAME AS i257605, PROVISIONAL_HOURS AS i257823, RESOURCE_ID AS i257849, NVL(CONFIRMED_HOURS,0)+NVL(PROVISIONAL_HOURS,0) AS i257953 FROM PA_REP_RES_SCHHRS_GL_V ) IO257422  GROUP BY i257605, i257596, i257849 ) on347,
      (SELECT CAPACITY_HOURS AS i257535, GL_PERIOD_NAME AS i257595, GL_PERIOD_NUMBER AS i257600, GL_PERIOD_SET_NAME AS i257604, QUARTER AS i257608, YEAR AS i257610, JOB_NAME AS i257618, MANAGER_ID AS i257627, ORGANIZATION_ID AS i257662, RESOURCE_ID AS i257845, RESOURCE_JOB_LEVEL AS i257854, MANAGER_NAME AS i257858, RESOURCE_NAME AS i257862 FROM PA_REP_RES_CAP_GL_V ) o257417,
      (SELECT CHILD_ORGANIZATION_ID AS i257538, CHILD_ORG_NAME AS i257672, PARENT_ORGANIZATION_ID AS i257693, PARENT_ORG_NAME AS i257874 FROM PA_REP_ALL_REP_ORG_V ) o257434
 WHERE 1=1 AND ((i257845 = in355(+) AND i257595 = in357(+) AND i257604 = in359(+))
   and i257538 = i257662)
   AND (1 = 1 )
 GROUP BY i257595, i257600, i257608, i257618, i257672, i257854, i257858, i257862
Parameter Name SQL text Validation
Resource Manager
o257417.i257858 = :resource_manager
Quarter
o257417.i257608 = :quarter
Year
o257417.i257610 = :year
Starting Organization
o257434.i257874 = :starting_organization