View: PA_REP_PROJ_SP_GL_V

Product:	PA - Projects
Description:	PA_REP_PROJ_SP_GL_V is a view that shows the sales pipeline of a project for a gl period
Implementation/DBA Data:	APPS.PA_REP_PROJ_SP_GL_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
, GLP.PERIOD_YEAR
, GLP.QUARTER_NUM
, GLP.PERIOD_NAME
, GLP.PERIOD_SET_NAME
, GLP.PERIOD_NUM
, 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
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS PAI
, GL_PERIODS GLP
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 GLP.START_DATE
AND GLP.END_DATE
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE 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
, GLP.PERIOD_YEAR
, GLP.QUARTER_NUM
, GLP.PERIOD_NAME
, GLP.PERIOD_SET_NAME
, GLP.PERIOD_NUM
, 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
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS PAI
, GL_PERIODS GLP
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 GLP.START_DATE
AND GLP.END_DATE
AND PPA.EXPECTED_APPROVAL_DATE NOT BETWEEN GLP.START_DATE
AND GLP.END_DATE )
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE

Columns