View: PA_TASK_PROG_HIST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TASK_PROG_HIST_V

View Text

SELECT PLPST.PROJECT_ID
, PLPST.PROJECT_NAME
, PLPST.PROJECT_NUMBER
, PLPST.PROJ_ELEMENT_ID
, PLPST.PROJ_ELEMENT_ID
, PLPST.ELEMENT_VERSION_ID
, PLPST.OBJECT_TYPE
, PLPST.ELEMENT_NAME
, PLPST.ELEMENT_NUMBER
, PLPST.WBS_NUMBER
, PLPST.WBS_LEVEL
, PLPST.TASK_MANAGER_ID
, PLPST.TASK_MANAGER
, PLPST.MILESTONE_FLAG
, PLPST.CRITICAL_FLAG
, PLPST.SUMMARY_ELEMENT_FLAG
, PLPST.STATUS_CODE
, PLPST.STATUS_CODE_MEANING
, PLPST.PLANNED_EFFORT
, PLPST.WQ_PLANNED_QUANTITY
, PLPST.WQ_ITEM_CODE
, ''
, PLPST.WQ_UOM_CODE
, ''
, PPC.DATE_COMPUTED AS_OF_DATE
, PPC.PERCENT_COMPLETE_ID
, PPC.COMPLETED_PERCENTAGE
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PLPST.SCHEDULED_START_DATE
, PLPST.SCHEDULED_FINISH_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_FINISH_DATE
, PPR.INCREMENTAL_WORK_QUANTITY
, PPR.CUMULATIVE_WORK_QUANTITY
, PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP
, PPR.ESTIMATED_REMAINING_EFFORT
, PPC.PUBLISHED_BY_PARTY_ID
, HZP.PARTY_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER
FROM PA_LATEST_PUB_STRUC_TASKS_V PLPST
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, HZ_PARTIES HZP
, PA_PROJECT_STATUSES PPS
WHERE PLPST.STRUCTURE_TYPE_CLASS_CODE='WORKPLAN'
AND PLPST.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND PLPST.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND PPC.PUBLISHED_FLAG(+) = 'Y'
AND PPC.OBJECT_ID = PPR.OBJECT_ID(+)
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE(+)
AND PPR.CURRENT_FLAG(+) <> 'W'
AND TRUNC(NVL(PPC.DATE_COMPUTED
, SYSDATE)) = TRUNC(NVL(PPR.AS_OF_DATE
, SYSDATE))
AND PPC.PUBLISHED_BY_PARTY_ID = HZP.PARTY_ID(+)
AND PPS.PROJECT_STATUS_CODE (+)= PPC.PROGRESS_STATUS_CODE

Columns