View: PA_RPT_PROJECT_ATTRIBUTES

Product:	PA - Projects
Description:	Reporting view which displays information about projects.
Implementation/DBA Data:	APPS.PA_RPT_PROJECT_ATTRIBUTES

View Text

SELECT PPA.PROJECT_ID
, PPS.PROJECT_STATUS_NAME
, PPA.NAME
, PPA.SEGMENT1
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, PPA.PM_PRODUCT_CODE
, PPA.PM_PROJECT_REFERENCE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, POU1.NAME
, PPA.PROJECT_TYPE
, PPT.PROJECT_TYPE_CLASS_CODE
, PPA.ORG_ID
, POU2.NAME
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(1)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(1))
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(2)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(2))
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(3)
, PA_RPT_UTILS.PROJECT_RPT_CLASS( PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_CLASS_CATEGORY(3))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(1)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(1))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(2)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(2))
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(3)
, PA_RPT_UTILS.PROJECT_RPT_KEYMEMBER(PPA.PROJECT_ID
, PA_RPT_UTILS.GET_RPT_ROLE_TYPE(3))
, PPSC.ENABLED_FLAG
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES PPT
, HR_ORGANIZATION_UNITS POU1
, HR_ALL_ORGANIZATION_UNITS POU2
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUS_CONTROLS PPSC
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.CARRYING_OUT_ORGANIZATION_ID = POU1.ORGANIZATION_ID
AND PPA.ORG_ID=POU2.ORGANIZATION_ID(+)
AND PPA.TEMPLATE_FLAG = 'N'
AND PA_SECURITY.ALLOW_QUERY(PPA.PROJECT_ID) = 'Y'
AND PPS.PROJECT_STATUS_CODE = PPSC.PROJECT_STATUS_CODE
AND PPSC.ACTION_CODE = 'STATUS_REPORTING'
AND PPA.ORG_ID = PPT.ORG_ID

Columns