VIEW: APPS.PA_TASK_PROG_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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