VIEW: PA.PA_PROJ_PROGRESS_REPORTS#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PROGRESS_STATUS_CODE PROGRESS_STATUS_CODE, SHORT_DESCRIPTION SHORT_DESCRIPTION, PROGRESS_ASOF_DATE PROGRESS_ASOF_DATE, LONG_DESCRIPTION LONG_DESCRIPTION, ISSUES ISSUES, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ESTIMATED_START_DATE ESTIMATED_START_DATE, ESTIMATED_END_DATE ESTIMATED_END_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, PERCENT_COMPLETE PERCENT_COMPLETE, ESTIMATE_TO_COMPLETE ESTIMATE_TO_COMPLETE, UNIT_TYPE UNIT_TYPE, WF_STATUS_CODE WF_STATUS_CODE, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, WF_PROCESS WF_PROCESS, PROGRESS_REPORT_ID PROGRESS_REPORT_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PLANNED_ACTIVITIES PLANNED_ACTIVITIES, REPORT_STATUS REPORT_STATUS from "PA"."PA_PROJ_PROGRESS_REPORTS"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PROGRESS_STATUS_CODE PROGRESS_STATUS_CODE
, SHORT_DESCRIPTION SHORT_DESCRIPTION
, PROGRESS_ASOF_DATE PROGRESS_ASOF_DATE
, LONG_DESCRIPTION LONG_DESCRIPTION
, ISSUES ISSUES
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ESTIMATED_START_DATE ESTIMATED_START_DATE
, ESTIMATED_END_DATE ESTIMATED_END_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, PERCENT_COMPLETE PERCENT_COMPLETE
, ESTIMATE_TO_COMPLETE ESTIMATE_TO_COMPLETE
, UNIT_TYPE UNIT_TYPE
, WF_STATUS_CODE WF_STATUS_CODE
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, WF_PROCESS WF_PROCESS
, PROGRESS_REPORT_ID PROGRESS_REPORT_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PLANNED_ACTIVITIES PLANNED_ACTIVITIES
, REPORT_STATUS REPORT_STATUS
FROM "PA"."PA_PROJ_PROGRESS_REPORTS"