Required Project Hours: Required Project Hours by PA Period

Description
Categories: Discoverer
Columns: Child Org Name, Pa Period, Pa Period Start Date, Project Name, Quarter, Team Role, Year, Sum(Pa Rep Proj Reqhrs Pa V.Required Hours) ...
The required project hours workbook allows you to evaluate the number of hours currently required within Project Resource Management by project.
Owner: SYSADMIN (System Administrator)
Identifier: PAREQPRJ
SELECT PA_REP_ALL_REP_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_REQHRS_PA_V.PA_PERIOD, PA_REP_PROJ_REQHRS_PA_V.PA_PERIOD_START_DATE, PA_REP_PROJ_REQHRS_PA_V.PROJECT_NAME, PA_REP_PROJ_REQHRS_PA_V.QUARTER, PA_REP_PROJ_REQHRS_PA_V.TEAM_ROLE, PA_REP_PROJ_REQHRS_PA_V.YEAR, SUM(PA_REP_PROJ_REQHRS_PA_V.REQUIRED_HOURS)
FROM PA_REP_PROJ_REQHRS_PA_V PA_REP_PROJ_REQHRS_PA_V, PA_REP_ALL_REP_ORG_V PA_REP_ALL_REP_ORG_V WHERE 1=1 AND ((PA_REP_ALL_REP_ORG_V.CHILD_ORGANIZATION_ID = PA_REP_PROJ_REQHRS_PA_V.ORGANIZATION_ID ) )    
GROUP BY PA_REP_ALL_REP_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_REQHRS_PA_V.PA_PERIOD, PA_REP_PROJ_REQHRS_PA_V.PA_PERIOD_START_DATE, PA_REP_PROJ_REQHRS_PA_V.PROJECT_NAME, PA_REP_PROJ_REQHRS_PA_V.QUARTER, PA_REP_PROJ_REQHRS_PA_V.TEAM_ROLE, PA_REP_PROJ_REQHRS_PA_V.YEAR
Parameter Name SQL text Validation
Quarter_PA
 PA_REP_PROJ_REQHRS_PA_V.QUARTER = :quarter_pa
LOV
Year_PA
 PA_REP_PROJ_REQHRS_PA_V.YEAR = :year_pa
LOV
Starting Organization
 PA_REP_ALL_REP_ORG_V.PARENT_ORG_NAME = :starting_organization
LOV
Project Manager
 PA_REP_PROJ_REQHRS_PA_V.MANAGER_NAME = :project_manager
LOV