Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_CURR_PROJ_TASK_PROG_V |
SELECT PPC.PROJECT_ID
, PPC.PERCENT_COMPLETE_ID
, PPC.TASK_ID TASK_ID
, PPC.OBJECT_ID
, PPC.OBJECT_VERSION_ID
, PPC.OBJECT_TYPE
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPC.DATE_COMPUTED AS_OF_DATE
, PPC.ACTUAL_START_DATE
, PPC.ACTUAL_FINISH_DATE
, PPC.ESTIMATED_START_DATE
, PPC.ESTIMATED_FINISH_DATE
, PPC.COMPLETED_PERCENTAGE
, PPR.BASE_PERCENT_COMPLETE
, PPR.INCREMENTAL_WORK_QUANTITY
, PPR.CUMULATIVE_WORK_QUANTITY
, PPR.ESTIMATED_REMAINING_EFFORT
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_BY_PARTY_ID
, HZP.PARTY_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER
FROM PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, HZ_PARTIES HZP
, PA_PROJECT_STATUSES PPS
WHERE PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPC.PUBLISHED_FLAG = 'Y'
AND PPC.CURRENT_FLAG = 'Y'
AND PPC.OBJECT_ID = PPR.OBJECT_ID
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE
AND TRUNC(PPC.DATE_COMPUTED) = TRUNC(PPR.AS_OF_DATE)
AND PPC.PUBLISHED_BY_PARTY_ID = HZP.PARTY_ID(+)