View: PA_TASK_PROGRESS_V

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

View Text

SELECT /*+ LEADING(PPE) */ PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, PPE.PROJ_ELEMENT_ID
, PPE.PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID
, PPEV.OBJECT_TYPE
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPEV.WBS_NUMBER
, PPEV.WBS_LEVEL
, PPE.MANAGER_PERSON_ID
, NULL
, PPE.CARRYING_OUT_ORGANIZATION_ID
, PPEV.DISPLAY_SEQUENCE
, PPVSCH.MILESTONE_FLAG
, PPVSCH.CRITICAL_FLAG
, NULL
, PPE.PRIORITY_CODE
, FLV6.MEANING
, FLV6.PREDEFINED_FLAG
, NVL(PPC.STATUS_CODE
, NVL(PPE.STATUS_CODE
, '124'))
, PPS1.PROJECT_STATUS_NAME
, PPS1.PROJECT_SYSTEM_STATUS_CODE
, PPVSCH.PLANNED_EFFORT
, PPVSCH.WQ_PLANNED_QUANTITY
, PPE.WQ_ITEM_CODE
, FLV3.MEANING
, PPE.WQ_UOM_CODE
, FLV4.MEANING
, PPC.DATE_COMPUTED AS_OF_DATE
, PPC.PERCENT_COMPLETE_ID
, PPC.COMPLETED_PERCENTAGE
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPS.PROJECT_STATUS_WEIGHT
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.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
, PPC.PUBLISHED_BY_PARTY_ID
, NULL
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, DECODE(PPC.PUBLISHED_FLAG
, 'Y'
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PROGRESS_REPORT_SYSTEM_STATUS'
, 'PROGRESS_REPORT_PUBLISHED')
, NULL) PROCESS_STATUS_NAME
, DECODE(PPC.PUBLISHED_FLAG
, 'Y'
, 'PROGRESS_REPORT_PUBLISHED'
, NULL) PROCESS_STATUS_CODE
, PPC.RECORD_VERSION_NUMBER
, PPR.ESTIMATED_START_DATE - PPVSCH.SCHEDULED_START_DATE EST_SCH_START_VAR
, PPR.ESTIMATED_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE EST_SCH_FINISH_VAR
, PPR.ACTUAL_START_DATE - PPVSCH.SCHEDULED_START_DATE ACT_SCH_START_VAR
, PPR.ACTUAL_FINISH_DATE - PPVSCH.SCHEDULED_FINISH_DATE ACT_SCH_FINISH_VAR
, PPVSCH.SCHEDULED_START_DATE - PPE.BASELINE_START_DATE SCH_BASE_START_VAR
, PPVSCH.SCHEDULED_FINISH_DATE - PPE.BASELINE_FINISH_DATE SCH_BASE_FINISH_VAR
, PPR.BASE_PROGRESS_STATUS_CODE
, PPR.EFF_ROLLUP_PROG_STAT_CODE
, PTT.PROG_ENTRY_ENABLE_FLAG
, PTT.PROG_ENTRY_REQ_FLAG
, PPE.ROWID
, PA_PROGRESS_UTILS.GET_NEXT_PROGRESS_CYCLE(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID)
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'ISSUE')
, TO_NUMBER(NULL)
, TRUNC(PPVSCH.SCHEDULED_FINISH_DATE) - TRUNC(SYSDATE)
, PTT.TASK_TYPE
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'CHANGE_REQUEST')
, PA_CONTROL_ITEMS_UTILS.GET_OPEN_CONTROL_ITEMS(PPE.PROJECT_ID
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, 'CHANGE_ORDER')
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ('STATUS_TYPE'
, PPE.PHASE_CODE ) PHASE
, 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) ACTUAL_COST
, NVL(PPR.PPL_ACT_EFFORT_TO_DATE
, 0) + NVL(PPR.EQPMT_ACT_EFFORT_TO_DATE
, 0) ACTUAL_EFFORT
, PPR.EQPMT_ACT_EFFORT_TO_DATE ACTUAL_EQUIP_EFFORT
, PPR.PPL_ACT_EFFORT_TO_DATE ACTUAL_PEOPLE_EFFORT
, NVL(PPR.OTH_ETC_COST_PC
, 0) + NVL(PPR.PPL_ETC_COST_PC
, 0) + NVL(PPR.EQPMT_ETC_COST_PC
, 0) ETC_COST
, NVL(PPR.ESTIMATED_REMAINING_EFFORT
, 0) + NVL(PPR.EQPMT_ETC_EFFORT
, 0) ETC_EFFORT
, PPR.EQPMT_ETC_EFFORT
, PPR.ESTIMATED_REMAINING_EFFORT
, PPVSCH.CONSTRAINT_DATE CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ('PA_SCHEDULE_CONSTRAINT_TYPE'
, PPVSCH.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PPEV.PARENT_STRUCTURE_VERSION_ID STRUCTURE_VERSION_ID
, PPA.PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PPA.PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS1
, PA_TASK_TYPES PTT
, PA_LOOKUPS FLV3
, PA_LOOKUPS FLV4
, PA_LOOKUPS FLV6
WHERE PPE.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPST.PROJ_ELEMENT_ID = PPVS.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = 1
AND PPE.LINK_TASK_FLAG = 'N'
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPVS.ELEMENT_VERSION_ID
AND PPA.PROJECT_ID = PPVS.PROJECT_ID
AND PPE.PROJECT_ID = PPVSCH.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 PPEV.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPEV.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND PPEV.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND (NVL(PPC.PUBLISHED_FLAG
, 'N') = 'N' OR (PPC.CURRENT_FLAG = 'Y'
AND NOT EXISTS (SELECT 1
FROM PA_PERCENT_COMPLETES
WHERE PUBLISHED_FLAG = 'N'
AND PROJECT_ID = PPEV.PROJECT_ID
AND OBJECT_ID = PPEV.PROJ_ELEMENT_ID
AND OBJECT_TYPE = PPEV.OBJECT_TYPE
AND STRUCTURE_TYPE = 'WORKPLAN')))
AND PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPC.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND NVL(PPC.STATUS_CODE
, NVL(PPE.STATUS_CODE
, '124')) = PPS1.PROJECT_STATUS_CODE
AND PPC.PROJECT_ID = PPR.PROJECT_ID(+)
AND PPC.OBJECT_ID = PPR.OBJECT_ID(+)
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE(+)
AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPR.STRUCTURE_VERSION_ID IS NULL
AND TRUNC(NVL(PPC.DATE_COMPUTED
, SYSDATE)) = TRUNC(PPR.AS_OF_DATE(+))
AND FLV6.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PPE.PRIORITY_CODE = FLV6.LOOKUP_CODE(+)
AND FLV3.LOOKUP_TYPE(+) = 'PA_WQ_WORK_ITEMS'
AND PPE.WQ_ITEM_CODE = FLV3.LOOKUP_CODE(+)
AND FLV4.LOOKUP_TYPE(+) = 'UNIT'
AND PPE.WQ_UOM_CODE = FLV4.LOOKUP_CODE(+)

Columns