Sales Pipeline: Sales Pipeline by Fiscal Year

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_GL_V.EXPECTED_APPROVAL_DATE, PA_REP_PROJ_SP_GL_V.YEAR, PA_REP_FORECAST_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_SP_GL_V.PROJECT_NAME, PA_REP_PROJ_SP_GL_V.STATUS, PA_REP_PROJ_SP_GL_V.TYPE, SUM(PA_REP_PROJ_SP_GL_V.NET_VALUE), SUM(PA_REP_PROJ_SP_GL_V.TOTAL_VALUE), PA_REP_PROJ_SP_GL_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_GL_V PA_REP_PROJ_SP_GL_V
WHERE ( ( PA_PROJ_MANAGER_V.MANAGER_ID = PA_REP_PROJ_SP_GL_V.PROJECT_MANAGER_ID ) AND ( PA_REP_FORECAST_ORG_V.CHILD_ORGANIZATION_ID = PA_REP_PROJ_SP_GL_V.ORGANIZATION_ID ) )
GROUP BY PA_REP_PROJ_SP_GL_V.CLASS_CATEGORY, PA_REP_PROJ_SP_GL_V.EXPECTED_APPROVAL_DATE, PA_REP_PROJ_SP_GL_V.YEAR, PA_REP_FORECAST_ORG_V.CHILD_ORG_NAME, PA_REP_PROJ_SP_GL_V.PROBABILITY, PA_PROJ_MANAGER_V.MANAGER_NAME, PA_REP_PROJ_SP_GL_V.PROJECT_NAME, PA_REP_PROJ_SP_GL_V.STATUS, PA_REP_PROJ_SP_GL_V.TYPE, PA_REP_FORECAST_ORG_V.PARENT_ORG_NAME
HAVING ( PA_REP_PROJ_SP_GL_V.CLASS_CATEGORY = :class_category_ AND PA_REP_PROJ_SP_GL_V.YEAR = :year_ AND PA_PROJ_MANAGER_V.MANAGER_NAME = :manager_ AND PA_REP_FORECAST_ORG_V.PARENT_ORG_NAME = :starting_organization_ AND ( SUM(PA_REP_PROJ_SP_GL_V.TOTAL_VALUE) ) >= :include_values_over_ )
Parameter Name SQL text Validation
Year
 
LOV
Manager
 
LOV
Class Category
 
LOV
Starting Organization
 
LOV
Include Values Over
 
Number