Scheduled Resource Hours: Scheduled Resource Hours by GL Period

Description
Categories: Discoverer
Columns: E257595, E257600, E257608, E257618, E257672, E257858, E257862, E-359 Sum, E-363 Sum, E257535 Sum ...
The scheduled resource hours workbook allows you to evaluate the number of hours currently scheduled within Project Resource Management by person.
Owner: SYSADMIN (System Administrator)
Identifier: PASCHRES
SELECT  i257595 as E257595,i257600 as E257600,i257608 as E257608,i257618 as E257618,i257672 as E257672,i257858 as E257858,i257862 as E257862,SUM(in359) as "E-359_SUM",SUM(in363) as "E-363_SUM",SUM(i257535) as E257535_SUM,i257854 as E257854
 FROM (SELECT SUM(i257823) AS in359, SUM(i257953) AS in363, i257849 AS in369, i257596 AS in371, i257605 AS in373 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 ) on357,
      (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 = in369(+) AND i257595 = in371(+) AND i257604 = in373(+))
   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