Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_PROJ_PROGRESS_REPORTS_V |
SELECT PROGRESS_REPORT_ID
, RECORD_VERSION_NUMBER
, PROJECT_ID
, TASK_ID
, PROGRESS_STATUS_CODE
, PAL.MEANING
, SHORT_DESCRIPTION
, PROGRESS_ASOF_DATE
, LONG_DESCRIPTION
, ISSUES
, ESTIMATED_START_DATE
, ESTIMATED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, PERCENT_COMPLETE
, ESTIMATE_TO_COMPLETE
, UNIT_TYPE
, PLANNED_ACTIVITIES
, REPORT_STATUS
, PPR.CREATED_BY
, PPR.CREATION_DATE
, PPR.LAST_UPDATED_BY
, PPR.LAST_UPDATE_DATE
, PPR.LAST_UPDATE_LOGIN
FROM PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS PAL
WHERE PPR.PROGRESS_STATUS_CODE = PAL.LOOKUP_CODE
AND PAL.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'