VIEW: APPS.PA_PROGRESS_REPORTS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)