View: PA_PROGRESS_REPORTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROGRESS_REPORTS_V

View Text

SELECT PPDVER.OBJECT_TYPE
, PPDVER.OBJECT_ID
, PPDVER.PAGE_TYPE_CODE
, PPDVER.PAGE_ID
, PPDVER.VERSION_ID
, PPDVER.REPORT_STATUS_CODE
, PPS1.PROJECT_STATUS_NAME PAGE_STATUS_MEANING
, PPDVER.PROGRESS_STATUS_CODE
, PPS2.PROJECT_STATUS_NAME PROGRESS_STATUS_MEANING
, PPS2.STATUS_ICON_IND
, PPS2.STATUS_ICON_ACTIVE_IND
, PPDVER.REPORT_START_DATE
, PPDVER.REPORT_END_DATE
, PPDVER.REPORTED_BY
, PA_RESOURCE_UTILS.GET_RESOURCE_NAME(PPDVER.REPORTED_BY)
, PPDVER.OVERVIEW
, PPDVER.COMMENTS
, PPDVER.PUBLISHED_DATE
, PPDVER.CANCELED_DATE
, PPDVER.RECORD_VERSION_NUMBER
, PPDVER.REPORT_TYPE_ID
, RTYP.NAME
, PA_RESOURCE_UTILS.GET_RESOURCE_NAME(PA_RESOURCE_UTILS.GET_RESOURCE_ID(NULL
, PPDVER.LAST_UPDATED_BY)) FROM PA_PROGRESS_REPORT_VERS PPDVER
, PA_PROJECT_STATUSES PPS1
, PA_PROJECT_STATUSES PPS2
, PA_REPORT_TYPES RTYP
WHERE PPDVER.PAGE_TYPE_CODE = 'PPR'
AND PPDVER.REPORT_TYPE_ID = RTYP.REPORT_TYPE_ID(+)
AND PPDVER.REPORT_STATUS_CODE = PPS1.PROJECT_STATUS_CODE
AND PPDVER.PROGRESS_STATUS_CODE = PPS2.PROJECT_STATUS_CODE(+)

Columns