View: PA_TASK_PROGRESS_AMG_V

Product:	PA - Projects
Description:	This view provides progress data for structure tasks
Implementation/DBA Data:	APPS.PA_TASK_PROGRESS_AMG_V

View Text

SELECT /*+ INDEX(PPR
, PA_PROGRESS_ROLLUP_U2) */ PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPR.AS_OF_DATE
, NVL(PPR.COMPLETED_PERCENTAGE
, NVL(PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP)) COMPLETED_PERCENTAGE
, DECODE(PPC.PUBLISHED_FLAG
, 'N'
, PPC.STATUS_CODE
, PPE.STATUS_CODE)
, PPS1.PROJECT_STATUS_NAME
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_FINISH_DATE
, PPR.CUMULATIVE_WORK_QUANTITY
, PA_PROGRESS_UTILS.SUM_ETC_VALUES((NVL(PXPV.LABOR_EFFORT
, 0)+NVL(PXPV.EQUIPMENT_EFFORT
, 0))
, PPR.ESTIMATED_REMAINING_EFFORT
, PPR.EQPMT_ETC_EFFORT
, NULL
, PPR.SUBPRJ_PPL_ETC_EFFORT
, PPR.SUBPRJ_EQPMT_ETC_EFFORT
, NULL
, NULL
, (NVL(PPR.PPL_ACT_EFFORT_TO_DATE
, 0)+NVL(PPR.EQPMT_ACT_EFFORT_TO_DATE
, 0) +NVL(PPR.SUBPRJ_PPL_ACT_EFFORT
, 0)+NVL(PPR.SUBPRJ_EQPMT_ACT_EFFORT
, 0))) EST_REMAINING_EFFORT
, PPC.PUBLISHED_BY_PARTY_ID
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PTT.PROG_ENTRY_ENABLE_FLAG
, PPR.OBJECT_ID
, PPR.OBJECT_VERSION_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, (NVL(PPR.OTH_ACT_COST_TO_DATE_PC
, 0)+NVL(PPR.PPL_ACT_COST_TO_DATE_PC
, 0) +NVL(PPR.EQPMT_ACT_COST_TO_DATE_PC
, 0)+NVL(PPR.SUBPRJ_OTH_ACT_COST_TO_DT_PC
, 0) +NVL(PPR.SUBPRJ_PPL_ACT_COST_PC
, 0)+NVL(PPR.SUBPRJ_EQPMT_ACT_COST_PC
, 0)) ACTUAL_COST
, (NVL(PPR.PPL_ACT_EFFORT_TO_DATE
, 0)+NVL(PPR.EQPMT_ACT_EFFORT_TO_DATE
, 0) +NVL(PPR.SUBPRJ_PPL_ACT_EFFORT
, 0)+NVL(PPR.SUBPRJ_EQPMT_ACT_EFFORT
, 0)) ACTUAL_EFFORT
, (NVL(PPR.OTH_ACT_COST_TO_DATE_PC
, 0)+NVL(PPR.PPL_ACT_COST_TO_DATE_PC
, 0) +NVL(PPR.EQPMT_ACT_COST_TO_DATE_PC
, 0)+NVL(PPR.SUBPRJ_OTH_ACT_COST_TO_DT_PC
, 0) +NVL(PPR.SUBPRJ_PPL_ACT_COST_PC
, 0)+NVL(PPR.SUBPRJ_EQPMT_ACT_COST_PC
, 0) +NVL(PPR.PPL_ETC_COST_PC
, 0)+NVL(PPR.EQPMT_ETC_COST_PC
, 0)+NVL(PPR.OTH_ETC_COST_PC
, 0) +NVL(PPR.SUBPRJ_PPL_ETC_COST_PC
, 0)+NVL(PPR.SUBPRJ_EQPMT_ETC_COST_PC
, 0) +NVL(PPR.SUBPRJ_OTH_ETC_COST_PC
, 0)) ESTIMATE_AT_COMPLETION_COST
, (NVL(PXPV.LABOR_EFFORT
, 0)+ NVL(PXPV.EQUIPMENT_EFFORT
, 0)) PLANNED_EFFORT
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS1
, PA_TASK_TYPES PTT
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PJI_XBS_PLANS_V PXPV
WHERE PPE.LINK_TASK_FLAG <> 'Y'
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPVS.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID(+)
AND PTT.OBJECT_TYPE = 'PA_TASKS'
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PPST.PROJ_ELEMENT_ID = PPVS.PROJ_ELEMENT_ID
AND (NVL(PPR.CURRENT_FLAG
, 'N') = 'W' OR (PPR.CURRENT_FLAG = 'Y'
AND NOT EXISTS (SELECT 1
FROM PA_PROGRESS_ROLLUP PPC1
WHERE PPC1.PROJECT_ID = PPEV.PROJECT_ID
AND PPC1.OBJECT_ID = PPEV.PROJ_ELEMENT_ID
AND PPC1.OBJECT_TYPE = PPEV.OBJECT_TYPE
AND PPC1.STRUCTURE_TYPE = 'WORKPLAN'
AND PPC1.STRUCTURE_VERSION_ID IS NULL
AND PPC1.CURRENT_FLAG = 'W')))
AND PPR.PERCENT_COMPLETE_ID = PPC.PERCENT_COMPLETE_ID(+)
AND PPR.STRUCTURE_VERSION_ID IS NULL
AND PPR.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND DECODE(PPC.PUBLISHED_FLAG
, 'N'
, PPC.STATUS_CODE
, NVL(PPE.STATUS_CODE
, 'IN_PROGRESS')) = PPS1.PROJECT_STATUS_CODE
AND PPEV.PROJECT_ID = PPR.PROJECT_ID
AND PPEV.PROJ_ELEMENT_ID = PPR.OBJECT_ID
AND PPEV.OBJECT_TYPE = PPR.OBJECT_TYPE
AND TRUNC(NVL(PPC.DATE_COMPUTED(+)
, PPR.AS_OF_DATE)) = TRUNC(PPR.AS_OF_DATE)
AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPC.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PXPV.PROJECT_ID(+) = PPEV.PROJECT_ID
AND PXPV.STRUCTURE_VERSION_ID(+) = PPEV.PARENT_STRUCTURE_VERSION_ID
AND PXPV.PROJ_ELEMENT_ID(+) = PPEV.PROJ_ELEMENT_ID
AND PXPV.STRUCTURE_TYPE(+) = 'WORKPLAN'

Columns