View: PA_PROJ_CURR_STATUS_REP_V

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

View Text

SELECT PRV.OBJECT_ID
, PRV.REPORT_TYPE_ID
, PRT.NAME
, PRV.PROGRESS_STATUS_CODE
, PS.PROJECT_STATUS_NAME
, PS.STATUS_ICON_IND
, PS.STATUS_ICON_ACTIVE_IND
, PRV.REPORT_START_DATE
, PRV.REPORT_END_DATE
, PRV.PUBLISHED_DATE
, PRV.OVERVIEW
, PRV.COMMENTS
FROM PA_PROGRESS_REPORT_VERS PRV
, PA_PROJECT_STATUSES PS
, PA_REPORT_TYPES PRT
WHERE PRV.OBJECT_TYPE = 'PA_PROJECTS'
AND PRV.PAGE_TYPE_CODE = 'PPR'
AND PRV.REPORT_STATUS_CODE = 'PROGRESS_REPORT_PUBLISHED'
AND PRV.CURRENT_FLAG = 'Y'
AND PRV.PROGRESS_STATUS_CODE = PS.PROJECT_STATUS_CODE
AND PS.STATUS_TYPE = 'PROGRESS'
AND PRV.REPORT_TYPE_ID = PRT.REPORT_TYPE_ID
AND PRT.REPORT_TYPE_ID = 1

Columns