Sales Pipeline: Sales Pipeline by PA Period

Description
Categories: Discoverer
The Sales Pipeline workbook allows you to view the value of projects currently within your pipeline (those that are in an unapproved status and have a probability of less than 100%).
Owner: SYSADMIN (System Administrator)
Identifier: PASALPIP
SELECT PA_REP_PROJ_SP_PA_V.EXPECTED_APPROVAL_DATE, PA_REP_FORECAST_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_SP_PA_V.PA_PERIOD, PA_REP_PROJ_SP_PA_V.QUARTER, PA_REP_PROJ_SP_PA_V.PERIOD_START_DATE, PA_REP_PROJ_SP_PA_V.PROJECT_NAME, PA_REP_PROJ_SP_PA_V.STATUS, PA_REP_PROJ_SP_PA_V.TYPE, SUM(PA_REP_PROJ_SP_PA_V.NET_VALUE), SUM(PA_REP_PROJ_SP_PA_V.TOTAL_VALUE), PA_REP_PROJ_SP_PA_V.PROBABILITY
FROM PA_REP_FORECAST_ORG_V PA_REP_FORECAST_ORG_V, PA_PROJ_MANAGER_V PA_PROJ_MANAGER_V, PA_REP_PROJ_SP_PA_V PA_REP_PROJ_SP_PA_V
WHERE 1=1 AND ( ( PA_PROJ_MANAGER_V.MANAGER_ID = PA_REP_PROJ_SP_PA_V.PROJECT_MANAGER_ID ) AND ( PA_REP_FORECAST_ORG_V.CHILD_ORGANIZATION_ID = PA_REP_PROJ_SP_PA_V.ORGANIZATION_ID ) ) AND ( PA_REP_PROJ_SP_PA_V.PROBABILITY < 100 )  
GROUP BY PA_REP_PROJ_SP_PA_V.EXPECTED_APPROVAL_DATE, PA_REP_FORECAST_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_SP_PA_V.PA_PERIOD, PA_REP_PROJ_SP_PA_V.QUARTER, PA_REP_PROJ_SP_PA_V.PERIOD_START_DATE, PA_REP_PROJ_SP_PA_V.PROBABILITY, PA_REP_PROJ_SP_PA_V.PROJECT_NAME, PA_REP_PROJ_SP_PA_V.STATUS, PA_REP_PROJ_SP_PA_V.TYPE
Parameter Name SQL text Validation
Quarter
PA_REP_PROJ_SP_PA_V.QUARTER = :quarter
LOV
Year
PA_REP_PROJ_SP_PA_V.YEAR = :year
LOV
Manager
PA_PROJ_MANAGER_V.MANAGER_NAME = :manager
LOV
Class Category
PA_REP_PROJ_SP_PA_V.CLASS_CATEGORY = :class_category
LOV
Starting Organization
PA_REP_FORECAST_ORG_V.PARENT_ORG_NAME = :starting_organization
LOV
Include Values Over
PA_REP_PROJ_SP_PA_V.TOTAL_VALUE >= :include_values_over
Number