View: PA_REP_PROJ_SP_PA_V

Product:	PA - Projects
Description:	PA_REP_PROJ_SP_PA_V is a view that shows the sales pipeline for a project for a pa period
Implementation/DBA Data:	APPS.PA_REP_PROJ_SP_PA_V

View Text

SELECT PPA.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PPC.CODE_PERCENTAGE
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_ID
, PPP.PROJECT_ROLE_TYPE
, PPP.PERSON_ID
, PPM.PROBABILITY_PERCENTAGE
, PPA.PROJECT_TYPE
, PPS.PROJECT_STATUS_NAME
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, PAP.PERIOD_NAME
, PAP.PA_START_DATE
, PPA.EXPECTED_APPROVAL_DATE
, NVL(PPA.PROJECT_VALUE
, 0) * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, NVL(PPA.PROJECT_VALUE
, 0) * PPM.PROBABILITY_PERCENTAGE/100 * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID)
, PAI.ORG_ID
FROM PA_PROJECT_CLASSES PPC
, PA_PROJECTS_ALL PPA
, PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_PLAYERS PPP
, PA_IMPLEMENTATIONS PAI
, PA_PERIODS_V PAP
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPA.PROJECT_ID = PPP.PROJECT_ID
AND PPM.PROBABILITY_MEMBER_ID = PPA.PROBABILITY_MEMBER_ID
AND PPS.PROJECT_STATUS_CODE = PPA.PROJECT_STATUS_CODE
AND PPA.EXPECTED_APPROVAL_DATE BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID UNION SELECT PPA.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PPC.CODE_PERCENTAGE
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_ID
, PPP.PROJECT_ROLE_TYPE
, PPP.PERSON_ID
, PPM.PROBABILITY_PERCENTAGE
, PPA.PROJECT_TYPE
, PPS.PROJECT_STATUS_NAME
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, PAP.PERIOD_NAME
, PAP.PA_START_DATE
, PPA.EXPECTED_APPROVAL_DATE
, NVL(PPA.PROJECT_VALUE
, 0) * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, NVL(PPA.PROJECT_VALUE
, 0) * PPM.PROBABILITY_PERCENTAGE/100 * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID)
, PAI.ORG_ID
FROM PA_PROJECT_CLASSES PPC
, PA_PROJECTS_ALL PPA
, PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_PLAYERS PPP
, PA_IMPLEMENTATIONS PAI
, PA_PERIODS_V PAP
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPA.PROJECT_ID = PPP.PROJECT_ID
AND PPM.PROBABILITY_MEMBER_ID = PPA.PROBABILITY_MEMBER_ID
AND PPS.PROJECT_STATUS_CODE = PPA.PROJECT_STATUS_CODE
AND ( PPA.EXPECTED_APPROVAL_DATE < SYSDATE
AND SYSDATE BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE
AND PPA.EXPECTED_APPROVAL_DATE NOT BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE )
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID

Columns