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.

VIEW: APPS.PA_TASK_PROGRESS_V

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)