eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_PROJ_TASK_PROG_DET_V

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

View Text

SELECT /*+ INDEX(PFXAT PJI_FM_XBS_ACCUM_TMP1_N1)*/ DECODE(PPC.PUBLISHED_FLAG
, 'Y'
, TO_NUMBER(NULL)
, PPC.PERCENT_COMPLETE_ID)
, PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, PPE.PROJ_ELEMENT_ID
, PPE.PROJ_ELEMENT_ID
, TO_NUMBER(NULL)
, PPEV.ELEMENT_VERSION_ID
, TO_NUMBER(NULL)
, PPE.OBJECT_TYPE
, 'WORKPLAN'
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, 'PA_STRUCTURES'
, PPVS.NAME )
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, 'PA_STRUCTURES'
, TO_CHAR( PPVS.VERSION_NUMBER ) )
, PPE.MANAGER_PERSON_ID
, NULL
, PPEV.WBS_LEVEL
, PPEV.WBS_NUMBER
, PPVSCH.MILESTONE_FLAG
, PPVSCH.CRITICAL_FLAG
, PPE.PRIORITY_CODE
, NULL PRIORITY_DESCRIPTION
, 'Y'
, PPR.AS_OF_DATE
, PPC.DESCRIPTION
, PPC.PROGRESS_COMMENT
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, NVL(PPC.PROGRESS_STATUS_CODE
, NVL(PPR.EFF_ROLLUP_PROG_STAT_CODE
, 'PROGRESS_STAT_ON_TRACK'))
, 'PA_TASKS'
, NVL(PPC.PROGRESS_STATUS_CODE
, NVL(PPR.EFF_ROLLUP_PROG_STAT_CODE
, PTT.INITIAL_PROGRESS_STATUS_CODE)))
, PPS.PROJECT_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPS2.STATUS_ICON_IND
, PPS2.STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_FINISH_DATE
, NVL(PPR.COMPLETED_PERCENTAGE
, PPR.EFF_ROLLUP_PERCENT_COMP) COMPLETED_PERCENTAGE
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_BY_PARTY_ID
, NULL PUBLISHED_BY_PARTY_NAME
, PPC.CURRENT_FLAG
, PPC.PUBLISHED_FLAG
, DECODE( PPEV.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE( PPEV.ELEMENT_VERSION_ID ) ) SUMMARY_ELEMENT_FLAG
, PPC.RECORD_VERSION_NUMBER
, NVL(PPC.STATUS_CODE
, NVL(PPE.STATUS_CODE
, '124'))
, PPS3.PROJECT_STATUS_NAME
, PPS3.PROJECT_SYSTEM_STATUS_CODE
, ROUND(PPVSCH.WQ_PLANNED_QUANTITY
, 2)
, PPR.INCREMENTAL_WORK_QUANTITY
, PPR.CUMULATIVE_WORK_QUANTITY
, NVL(PFXAT.LABOR_HOURS
, 0) + NVL(PFXAT.EQUIPMENT_HOURS
, 0)
, PPR.ESTIMATED_REMAINING_EFFORT
, PPR.BASE_PERCENT_COMPLETE
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.WQ_ENABLE_FLAG
, DECODE(PTT.WQ_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.WQ_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.REMAIN_EFFORT_ENABLE_FLAG
, DECODE(PTT.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, PTT.BASE_PERCENT_COMP_DERIV_CODE
, NVL(PPE.WQ_ACTUAL_ENTRY_CODE
, PTT.ACTUAL_WQ_ENTRY_CODE)
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPE.LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE
, PPR.EFF_ROLLUP_PERCENT_COMP
, PPR.RECORD_VERSION_NUMBER
, NVL(PPE.WQ_ITEM_CODE
, PTT.WORK_ITEM_CODE)
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS'
, NVL(PPE.WQ_ITEM_CODE
, PTT.WORK_ITEM_CODE))
, PPE.WQ_UOM_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT'
, PPE.WQ_UOM_CODE)
, PPR.BASE_PROGRESS_STATUS_CODE
, NULL BASE_PROGRESS_STATUS_NAME
, PPR.EFF_ROLLUP_PROG_STAT_CODE
, PPS2.PROJECT_STATUS_NAME
, PA_PROGRESS_UTILS.GET_NEXT_PROGRESS_CYCLE(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID)
, PA_PROGRESS_UTILS.GET_PROG_DT_CLOSEST_TO_SYS_DT(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID)
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.PERCENT_COMP_ENABLE_FLAG
, DECODE(PTT.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, DECODE(PPE.OBJECT_TYPE
, 'PA_TASKS'
, PTT.PROG_ENTRY_ENABLE_FLAG
, 'Y')
, PTT.PROG_ENTRY_REQ_FLAG
, PPE.ROWID
, PA_PROGRESS_UTILS.PERCENT_COMPLETE_VALUE( (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.OTH_ETC_COST_PC
, 0)+NVL(PPR.PPL_ETC_COST_PC
, 0)+NVL(PPR.EQPMT_ETC_COST_PC
, 0)+NVL(PPR.SUBPRJ_OTH_ETC_COST_PC
, 0) +NVL(PPR.SUBPRJ_PPL_ETC_COST_PC
, 0) +NVL(PPR.SUBPRJ_EQPMT_ETC_COST_PC
, 0)) ) PERCENT_COMPLETE_COST
, PA_PROGRESS_UTILS.PERCENT_COMPLETE_VALUE( (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))
, ( NVL(PPR.ESTIMATED_REMAINING_EFFORT
, 0)+NVL(PPR.EQPMT_ETC_EFFORT
, 0)+NVL(PPR.SUBPRJ_PPL_ETC_EFFORT
, 0) +NVL(PPR.SUBPRJ_EQPMT_ETC_EFFORT
, 0)) ) PERCENT_COMPLETE_EFFORT
, PA_PROGRESS_UTILS.PERCENT_SPENT_VALUE( (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(PFXAT.PRJ_BRDN_COST
, 0)) ) PERCENT_SPENT_COST
, PA_PROGRESS_UTILS.PERCENT_SPENT_VALUE( (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))
, (NVL(PFXAT.LABOR_HOURS
, 0) +NVL(PFXAT.EQUIPMENT_HOURS
, 0)) ) PERCENT_SPENT_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) 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
, PFXAT.PRJ_BASE_BRDN_COST BASELINE_COST
, NVL(PFXAT.BASE_LABOR_HOURS
, 0)+NVL(PFXAT.BASE_EQUIP_HOURS
, 0) BASELINED_EFFORT
, (PA_PROGRESS_UTILS.GET_NEXT_PROGRESS_CYCLE(PPA.PROJECT_ID
, PPE.PROJ_ELEMENT_ID)-SYSDATE) DAYS_UNTIL_PROGRESS_DUE
, (TRUNC(PPVSCH.SCHEDULED_START_DATE)-TRUNC(SYSDATE)) DAYS_UNTIL_START
, PPR.EARNED_VALUE EARNED_VALUE
, 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) +PA_PROGRESS_UTILS.SUM_ETC_VALUES(PFXAT.PRJ_BRDN_COST
, PPR.PPL_ETC_COST_PC
, PPR.EQPMT_ETC_COST_PC
, PPR.OTH_ETC_COST_PC
, PPR.SUBPRJ_PPL_ETC_COST_PC
, PPR.SUBPRJ_EQPMT_ETC_COST_PC
, PPR.SUBPRJ_OTH_ETC_COST_PC
, NULL
, (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))) EST_AT_COMPLETION_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) +PA_PROGRESS_UTILS.SUM_ETC_VALUES((NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 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_AT_COMPLETION_EFFORT
, (PPR.ESTIMATED_START_DATE - PPE.BASELINE_START_DATE) EST_BAS_START_VAR
, (PPR.ESTIMATED_FINISH_DATE - PPE.BASELINE_FINISH_DATE) EST_BAS_FINISH_VAR
, PA_PROGRESS_UTILS.SUM_ETC_VALUES(PFXAT.PRJ_BRDN_COST
, PPR.PPL_ETC_COST_PC
, PPR.EQPMT_ETC_COST_PC
, PPR.OTH_ETC_COST_PC
, PPR.SUBPRJ_PPL_ETC_COST_PC
, PPR.SUBPRJ_EQPMT_ETC_COST_PC
, PPR.SUBPRJ_OTH_ETC_COST_PC
, NULL
, (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))) ETC_COST
, PA_PROGRESS_UTILS.SUM_ETC_VALUES((NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 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))) ETC_EFFORT
, ROUND(( NVL(PPVSCH.WQ_PLANNED_QUANTITY
, 0) - NVL(CUMULATIVE_WORK_QUANTITY
, 0))
, 2) ETC_WORK_QUANTITY
, NVL(PFXAT.PRJ_BRDN_COST
, 0) PLANNED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((NVL(PFXAT.PRJ_BRDN_COST
, 0)/DECODE(NVL(CUMULATIVE_WORK_QUANTITY
, 0)
, 0
, 1
, NVL(CUMULATIVE_WORK_QUANTITY
, 0)))
, PPA.PROJECT_CURRENCY_CODE) PLANNED_COST_PER_UNIT
, PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(PPE.PROJ_ELEMENT_ID) PREDECESSORS
, TO_CHAR(NULL) RESOURCES
, ROUND((NVL(PPR.EARNED_VALUE
, 0)/DECODE(NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)
, 0
, 1
, NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)))
, 2) SCH_PERFORMANCE_INDEX
, ROUND(DECODE (PPR.TASK_WT_BASIS_CODE
, 'EFFORT'
, (((NVL(PFXAT.BASE_LABOR_HOURS
, 0)+NVL(PFXAT.BASE_EQUIP_HOURS
, 0))-PPR.EARNED_VALUE)/DECODE(((NVL(PFXAT.BASE_LABOR_HOURS
, 0) +NVL(PFXAT.BASE_EQUIP_HOURS
, 0))-(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)))
, 0
, 1
, ((NVL(PFXAT.BASE_LABOR_HOURS
, 0)+NVL(PFXAT.BASE_EQUIP_HOURS
, 0))-(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)))))
, ((NVL(PFXAT.PRJ_BASE_BRDN_COST
, 0)-PPR.EARNED_VALUE)/DECODE((NVL(PFXAT.PRJ_BASE_BRDN_COST
, 0)-(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)))
, 0
, 1
, (NVL(PFXAT.PRJ_BASE_BRDN_COST
, 0)-(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))))))
, 2) TO_COMPLETE_PERFORMANCE_INDEX
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT'
, 'HOURS') UNIT_OF_MEASURE
, NVL(PFXAT.PRJ_BASE_BRDN_COST
, 0)-(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) +PA_PROGRESS_UTILS.SUM_ETC_VALUES(PFXAT.PRJ_BRDN_COST
, PPR.PPL_ETC_COST_PC
, PPR.EQPMT_ETC_COST_PC
, PPR.OTH_ETC_COST_PC
, PPR.SUBPRJ_PPL_ETC_COST_PC
, PPR.SUBPRJ_EQPMT_ETC_COST_PC
, PPR.SUBPRJ_OTH_ETC_COST_PC
, NULL
, (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)))) VAR_AT_COMPLETION_COST
, NVL(PFXAT.BASE_LABOR_HOURS
, 0)+NVL(PFXAT.BASE_EQUIP_HOURS
, 0)-(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) +PA_PROGRESS_UTILS.SUM_ETC_VALUES((NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 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)))) VAR_AT_COMPLETION_EFFORT
, TO_NUMBER(NULL) WORK_TYPE
, NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_DEF_AS_OF_DATE_PROG_REPORT(PPA.PROJECT_ID
, PPE.PROJ_ELEMENT_ID)
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0) BCWS
, PPA.PROJECT_CURRENCY_CODE
, ROUND(DECODE(PPR.TASK_WT_BASIS_CODE
, 'EFFORT'
, (NVL(PPR.EARNED_VALUE
, 0)/DECODE((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))
, 0
, 1
, (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))))
, (NVL(PPR.EARNED_VALUE
, 0)/DECODE((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))
, 0
, 1
, (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)))))
, 2) COST_PERFORMANCE_INDEX
, PA_PROGRESS_UTILS.RETURN_START_END_DATE(PPVSCH.SCHEDULED_START_DATE
, PPE.BASELINE_START_DATE
, PPA.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, 'PA_TASKS'
, 'S')+ ((PA_PROGRESS_UTILS.RETURN_START_END_DATE(PPVSCH.SCHEDULED_FINISH_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, 'PA_TASKS'
, 'E')- PA_PROGRESS_UTILS.RETURN_START_END_DATE(PPVSCH.SCHEDULED_START_DATE
, PPE.BASELINE_START_DATE
, PPA.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, 'PA_TASKS'
, 'S')) /DECODE(ROUND((NVL(PPR.EARNED_VALUE
, 0)/DECODE(NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)
, 0
, 1
, NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)))
, 2)
, 0
, 1
, ROUND(( NVL(PPR.EARNED_VALUE
, 0)/DECODE(NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)
, 0
, 1
, NVL(PA_PROGRESS_UTILS.GET_BCWS(PPA.PROJECT_ID
, PPR.OBJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PPPA.TASK_WEIGHT_BASIS_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPA.PROJECT_CURRENCY_CODE)
, 0)))
, 2))) SCH_AT_COMPLETION
, PPR.LAST_UPDATE_DATE
, PPR.LAST_UPDATE_DATE
, PPVS.ELEMENT_VERSION_ID
, (PPR.ACTUAL_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE) ACTUAL_SCH_FINISH_VAR
, (PPR.ACTUAL_START_DATE - PPVSCH.SCHEDULED_START_DATE) ACTUAL_SCH_START_VAR
, PPR.CUMULATIVE_WORK_QUANTITY ACTUAL_WORK_QUANTITY
, TO_CHAR(NULL) COLUMN_NAME
, (PPVSCH.SCHEDULED_FINISH_DATE - SYSDATE) DAYS_UNTIL_FINISH
, (PPVSCH.ESTIMATED_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE) ESTIMATED_SCH_FINISH_VAR
, (PPVSCH.SCHEDULED_FINISH_DATE - PPE.BASELINE_FINISH_DATE) SCH_BASELINE_FINISH_VAR
, (PPVSCH.SCHEDULED_START_DATE - PPE.BASELINE_START_DATE) SCH_BASELINE_START_VAR
, PPVSCH.LATE_START_DATE LATE_START_DATE
, PPVSCH.LATE_FINISH_DATE LATE_FINISH_DATE
, NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 0) - (NVL(PFXAT.BASE_LABOR_HOURS
, 0)+NVL(PFXAT.BASE_EQUIP_HOURS
, 0)) PLANNED_BASELINE_EFFORT_VAR
, NVL(PFXAT.PRJ_BRDN_COST
, 0) - NVL(PFXAT.PRJ_BASE_BRDN_COST
, 0) PLANNED_BASELINE_COST_VAR
, TO_NUMBER(NULL) BASELINE_SCHEDULE_VAR
, DECODE(PPVSCH.ACTUAL_FINISH_DATE
, NULL
, (PPVSCH.ESTIMATED_FINISH_DATE-PPVSCH.SCHEDULED_FINISH_DATE)
, (PPVSCH.ACTUAL_FINISH_DATE-PPVSCH.SCHEDULED_FINISH_DATE)) VARIANCE_FROM_SCHEDULE
, 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) +PA_PROGRESS_UTILS.SUM_ETC_VALUES((NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 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))) -(NVL(PFXAT.LABOR_HOURS
, 0)+NVL(PFXAT.EQUIPMENT_HOURS
, 0)) EAC_PLANNED_EFFORT_VAR
, PA_PROGRESS_UTILS.GET_ACT_EFFORT_THIS_PERIOD(PPR.AS_OF_DATE
, PPR.PROJECT_ID
, PPR.OBJECT_ID
, PPR.OBJECT_VERSION_ID) ACTUAL_EFFORT_THIS_PERIOD
, PPPA.ALLOW_PHY_PRCNT_CMP_OVERRIDES
, PPA.PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PPR.TASK_WT_BASIS_CODE PROGRESS_ROLLUP_METHOD
, DECODE(PPEV.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'N'
, DECODE(PPEV.PRG_GROUP
, NULL
, 'N'
, DECODE(PA_PROGRESS_UTILS.CHECK_ASSIGNMENT_EXISTS(PPEV.PROJECT_ID
, PPEV.ELEMENT_VERSION_ID
, 'PA_TASKS')
, 'Y'
, 'N'
, 'Y'))) LINKED_TASK_FLAG
, DECODE(PPEV.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'N'
, DECODE(PPA.STRUCTURE_SHARING_CODE
, 'SHARE_FULL'
, 'N'
, DECODE(PPEV.PRG_GROUP
, NULL
, 'N'
, DECODE(PA_PROGRESS_UTILS.CHECK_ASSIGNMENT_EXISTS(PPEV.PROJECT_ID
, PPEV.ELEMENT_VERSION_ID
, 'PA_TASKS')
, 'Y'
, 'N'
, 'Y')))) LINKED_TASK_FLAG_SHARED
, PA_PROGRESS_UTILS.GET_SELF_AMOUNTS('ACT_COST'
, PPA.STRUCTURE_SHARING_CODE
, PPEV.PRG_GROUP
, PPR.PROJECT_ID
, PPR.OBJECT_VERSION_ID
, PPR.PROJ_ELEMENT_ID
, PPR.AS_OF_DATE
, PPR.CURRENT_FLAG
, PPR.RECORD_VERSION_NUMBER) SELF_ACTUAL_COST
, PA_PROGRESS_UTILS.GET_SELF_AMOUNTS('ACT_EFFORT'
, PPA.STRUCTURE_SHARING_CODE
, PPEV.PRG_GROUP
, PPR.PROJECT_ID
, PPR.OBJECT_VERSION_ID
, PPR.PROJ_ELEMENT_ID
, PPR.AS_OF_DATE
, PPR.CURRENT_FLAG
, PPR.RECORD_VERSION_NUMBER) SELF_ACTUAL_EFFORT
, PA_PROGRESS_UTILS.GET_SELF_AMOUNTS('ETC_COST'
, PPA.STRUCTURE_SHARING_CODE
, PPEV.PRG_GROUP
, PPR.PROJECT_ID
, PPR.OBJECT_VERSION_ID
, PPR.PROJ_ELEMENT_ID
, PPR.AS_OF_DATE
, PPR.CURRENT_FLAG
, PPR.RECORD_VERSION_NUMBER) SELF_ETC_COST
, PA_PROGRESS_UTILS.GET_SELF_AMOUNTS('ETC_EFFORT'
, PPA.STRUCTURE_SHARING_CODE
, PPEV.PRG_GROUP
, PPR.PROJECT_ID
, PPR.OBJECT_VERSION_ID
, PPR.PROJ_ELEMENT_ID
, PPR.AS_OF_DATE
, PPR.CURRENT_FLAG
, PPR.RECORD_VERSION_NUMBER) SELF_ETC_EFFORT
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_TASK_TYPES PTT
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS2
, PA_PROJECT_STATUSES PPS3
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PJI_FM_XBS_ACCUM_TMP1 PFXAT
WHERE PPA.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = 1
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPVS.PROJECT_ID = PPE.PROJECT_ID
AND PPE.LINK_TASK_FLAG = 'N'
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 PPVSCH.PROJECT_ID = PPA.PROJECT_ID
AND PPVSCH.ELEMENT_VERSION_ID = PPEV.ELEMENT_VERSION_ID
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID(+)
AND PTT.OBJECT_TYPE (+) = 'PA_TASKS'
AND PPVS.PROJECT_ID = PPPA.PROJECT_ID
AND PPVS.PROJ_ELEMENT_ID = PPPA.OBJECT_ID
AND PPE.PROJECT_ID = PPR.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID(+)
AND PPE.OBJECT_TYPE = PPR.OBJECT_TYPE(+)
AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPR.STRUCTURE_VERSION_ID(+) IS NULL
AND PPC.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPR.PERCENT_COMPLETE_ID = PPC.PERCENT_COMPLETE_ID(+)
AND PPR.PROGRESS_ROLLUP_ID(+) = PA_PROGRESS_UTILS.GET_W_PUB_PRUPID_ASOFDATE(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.GET_PROG_ASOFDATE()
, 'N')
AND NVL(PPR.PROGRESS_STATUS_CODE
, NVL(PPR.EFF_ROLLUP_PROG_STAT_CODE
, NVL(PTT.INITIAL_PROGRESS_STATUS_CODE
, 'PROGRESS_STAT_ON_TRACK'))) = PPS.PROJECT_STATUS_CODE
AND PPR.EFF_ROLLUP_PROG_STAT_CODE = PPS2.PROJECT_STATUS_CODE(+)
AND NVL(PPC.STATUS_CODE
, NVL(PPE.STATUS_CODE
, '124')) = PPS3.PROJECT_STATUS_CODE
AND PFXAT.PROJECT_ID(+) = PPEV.PROJECT_ID
AND PFXAT.STRUCT_VERSION_ID(+) = PPEV.PARENT_STRUCTURE_VERSION_ID
AND PFXAT.PROJECT_ELEMENT_ID(+) = PPEV.PROJ_ELEMENT_ID
AND PFXAT.CALENDAR_TYPE(+) = 'A'
AND PFXAT.PLAN_VERSION_ID(+) > 0
AND PFXAT.TXN_CURRENCY_CODE(+) IS NULL
AND PPPA.STRUCTURE_TYPE = 'WORKPLAN'

Columns

Name
PERCENT_COMPLETE_ID
PROJECT_ID
PROJECT_NAME
PROJECT_NUMBER
LONG_NAME
TASK_ID
PROJ_ELEMENT_ID
PARENT_TASK_ID
ELEMENT_VERSION_ID
PARENT_ELEMENT_VERSION_ID
OBJECT_TYPE
STRUCTURE_TYPE
TASK_NAME
TASK_NUMBER
TASK_MANAGER_PERSON_ID
TASK_MANAGER_NAME
WBS_LEVEL
WBS_NUMBER
MILESTONE_FLAG
CRITICAL_FLAG
PRIORITY_CODE
PRIORITY_DESCRIPTION
LATEST_EFF_PUBLISHED_FLAG
AS_OF_DATE
PROGRESS_OVERVIEW
PROGRESS_COMMENT
PROGRESS_STATUS_CODE
PROGRESS_STATUS_NAME
SYSTEM_PROGRESS_STAT_CODE
STATUS_ICON_IND
STATUS_ICON_ACTIVE_IND
SCHEDULED_START_DATE
SCHEDULED_FINISH_DATE
ACTUAL_START_DATE
ACTUAL_FINISH_DATE
ESTIMATED_START_DATE
ESTIMATED_FINISH_DATE
COMPLETED_PERCENTAGE
LAST_UPDATED_DATE
PUBLISHED_BY_PARTY_ID
PUBLISHED_BY_PARTY_NAME
CURRENT_FLAG
PUBLISHED_FLAG
SUMMARY_ELEMENT_FLAG
RECORD_VERSION_NUMBER
TASK_STATUS_CODE
TASK_STATUS_NAME
SYSTEM_TASK_STATUS_CODE
PLANNED_WORK_QUANTITY
INCREMENTAL_WORK_QUANTITY
CUMULATIVE_WORK_QUANTITY
PLANNED_EFFORT
ESTIMATED_REMAINING_EFFORT
BASE_PERCENT_COMPLETE
WQ_ENABLED_FLAG
EFFORT_ENABLED_FLAG
BASE_PERCENT_COMP_DERIV_CODE
WQ_ACTUAL_ENTRY_CODE
BASELINE_START_DATE
BASELINE_FINISH_DATE
BASELINE_AS_OF_DATE
SCHEDULE_AS_OF_DATE
EFF_ROLLUP_PERCENT_COMP
ROLLUP_REC_VER_NUMBER
WQ_ITEM_CODE
WQ_ITEM_NAME
WQ_UOM_CODE
WQ_UOM_NAME
BASE_PROGRESS_STATUS_CODE
BASE_PROGRESS_STATUS_NAME
EFF_ROLLUP_PROG_STAT_CODE
EFF_ROLLUP_PROG_STAT_NAME
NEXT_PROGRESS_DUE_DATE
DEFAULT_AS_OF_DATE
PERCENT_COMP_ENABLED_FLAG
PROG_ENTRY_ENABLE_FLAG
PROG_ENTRY_REQ_FLAG
ELEM_ROW_ID
PERCENT_COMPLETE_COST
PERCENT_COMPLETE_EFFORT
PERCENT_SPENT_COST
PERCENT_SPENT_EFFORT
ACTUAL_COST
ACTUAL_EFFORT
BASELINE_COST
BASELINED_EFFORT
DAYS_UNTIL_PROGRESS_DUE
DAYS_UNTIL_START
EARNED_VALUE
EST_AT_COMPLETION_COST
EST_AT_COMPLETION_EFFORT
EST_BAS_START_VAR
EST_BAS_FINISH_VAR
ETC_COST
ETC_EFFORT
ETC_WORK_QUANTITY
PLANNED_COST
PLANNED_COST_PER_UNIT
PREDECESSORS
RESOURCES
SCH_PERFORMANCE_INDEX
TO_COMPLETE_PERFORMANCE_INDEX
UNIT_OF_MEASURE
VAR_AT_COMPLETION_COST
VAR_AT_COMPLETION_EFFORT
WORK_TYPE
BCWS
PROJECT_CURRENCY_CODE
COST_PERFORMANCE_INDEX
SCH_AT_COMPLETION
ESTIMATE_AS_OF_DATE
ACTUAL_AS_OF_DATE
STRUCTURE_VERSION_ID
ACTUAL_SCH_FINISH_VAR
ACTUAL_SCH_START_VAR
ACTUAL_WORK_QUANTITY
COLUMN_NAME
DAYS_UNTIL_FINISH
ESTIMATED_SCH_FINISH_VAR
SCH_BASELINE_FINISH_VAR
SCH_BASELINE_START_VAR
LATE_START_DATE
LATE_FINISH_DATE
PLANNED_BASELINE_EFFORT_VAR
PLANNED_BASELINE_COST_VAR
BASELINE_SCHEDULE_VAR
VARIANCE_FROM_SCHEDULE
EAC_PLANNED_EFFORT_VAR
ACTUAL_EFFORT_THIS_PERIOD
PERCENT_COMP_OVERRIDES
PROJFUNC_CURRENCY_CODE
PROGRESS_ROLLUP_METHOD
LINKED_TASK_FLAG
LINKED_TASK_FLAG_SHARED
SELF_ACTUAL_COST
SELF_ACTUAL_EFFORT
SELF_ETC_COST
SELF_ETC_EFFORT