VIEW: APPS.PA_PROJ_CURR_STATUS_REP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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