728:
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730:
731: /*4275236 : Some Perf Enhancements*/
732: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
733: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
734:
735: -- Bug Fix 5609629
736: -- Caching the versioning_enabled_flag attribute value locally.
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730:
731: /*4275236 : Some Perf Enhancements*/
732: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
733: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
734:
735: -- Bug Fix 5609629
736: -- Caching the versioning_enabled_flag attribute value locally.
737: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
749: OPEN c1;
750: FETCH c1 INTO c1_rec;
751: IF c1%FOUND THEN
752:
753: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
754: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
755: CLOSE c1;
756: end if;
757: if l_d_lines_exist_flag is null then
750: FETCH c1 INTO c1_rec;
751: IF c1%FOUND THEN
752:
753: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
754: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
755: CLOSE c1;
756: end if;
757: if l_d_lines_exist_flag is null then
758: OPEN C2;
1054: ,ppa.project_id
1055: ,ppv.display_sequence + p_sequence_offset --bug 4448499 adjust the display sequnece of sub-project tasks with the offset.
1056: ,ppvsch.milestone_flag
1057: /* 4275236 : Perf Enhancement - Replaced with Local variable
1058: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
1059: */
1060: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
1061: ,ppvsch.critical_flag
1062: /* 4275236 : Perf Enhancement - Replaced with Local variable
1059: */
1060: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
1061: ,ppvsch.critical_flag
1062: /* 4275236 : Perf Enhancement - Replaced with Local variable
1063: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
1064: */
1065: ,decode(NVL( ppvsch.critical_flag, 'N' ),'N',l_no,l_yes)
1066: ,por.object_id_from1
1067: ,por.object_type_from
1068: ,por.relationship_type
1069: ,por.relationship_subtype
1070: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1071: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1072: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1073: summary_element_flag -- Fix for Bug # 4490532.
1074: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1075: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1076: ,PPS.PROJECT_STATUS_NAME
1092: ,pps.status_icon_ind
1093: ,ppe.status_code
1094: ,pps2.project_status_name
1095: ,ppe.priority_code
1096: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
1097: ,ppe.carrying_out_organization_id
1098: ,hou.name
1099: ,ppe.inc_proj_progress_flag
1100: ,ppvsch.estimated_start_date
1122: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
1123: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
1124: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
1125: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
1126: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
1127: ,ppe.pm_source_code
1128: ,ppe.pm_source_reference
1129: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1130: /*4275236 : Replaced the function call with Local variable
1125: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
1126: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
1127: ,ppe.pm_source_code
1128: ,ppe.pm_source_reference
1129: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1130: /*4275236 : Replaced the function call with Local variable
1131: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1132: */
1133: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1127: ,ppe.pm_source_code
1128: ,ppe.pm_source_reference
1129: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1130: /*4275236 : Replaced the function call with Local variable
1131: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1132: */
1133: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1134: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1135: -- Fix for Bug # 4447949.
1129: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1130: /*4275236 : Replaced the function call with Local variable
1131: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1132: */
1133: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1134: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1135: -- Fix for Bug # 4447949.
1136: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1137: -- Fix for Bug # 4447949.
1130: /*4275236 : Replaced the function call with Local variable
1131: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1132: */
1133: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1134: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1135: -- Fix for Bug # 4447949.
1136: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1137: -- Fix for Bug # 4447949.
1138: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
1134: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1135: -- Fix for Bug # 4447949.
1136: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1137: -- Fix for Bug # 4447949.
1138: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
1139: -- Fix for Bug # 4447949.
1140: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
1141: -- Fix for Bug # 4447949.
1142: ,papf.work_telephone
1139: -- Fix for Bug # 4447949.
1140: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
1141: -- Fix for Bug # 4447949.
1142: ,papf.work_telephone
1143: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
1144: ,pt.service_type_code
1145: ,pwt.name
1146: ,pt.work_type_id
1147: /*4275236 : Replaced the function call with Local variable
1144: ,pt.service_type_code
1145: ,pwt.name
1146: ,pt.work_type_id
1147: /*4275236 : Replaced the function call with Local variable
1148: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
1149: */
1150: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
1151: ,pt.chargeable_flag
1152: /*4275236 : Replaced the function call with Local variable
1149: */
1150: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
1151: ,pt.chargeable_flag
1152: /*4275236 : Replaced the function call with Local variable
1153: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
1154: */
1155: ,decode(pt.billable_flag,'Y',l_yes,l_no)
1156: ,pt.billable_flag
1157: /*4275236 : Replaced the function call with Local variable
1154: */
1155: ,decode(pt.billable_flag,'Y',l_yes,l_no)
1156: ,pt.billable_flag
1157: /*4275236 : Replaced the function call with Local variable
1158: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
1159: */
1160: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
1161: ,pt.receive_project_invoice_flag
1162: ,pt.start_date
1167: ,to_date(NULL)
1168: ,ppa.BASELINE_AS_OF_DATE
1169: ,ppru.LAST_UPDATE_DATE
1170: ,ppru.LAST_UPDATE_DATE
1171: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
1172: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
1173: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
1174: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
1175: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
1175: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
1176: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
1177: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
1178: /*4275236 : Replaced the function call with Local variable
1179: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
1180: */
1181: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
1182: ,ppe.CREATION_DATE
1183: /*4275236 : Replaced the function call with Local variable
1180: */
1181: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
1182: ,ppe.CREATION_DATE
1183: /*4275236 : Replaced the function call with Local variable
1184: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
1185: */
1186: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
1187: ,ppe.TYPE_ID
1188: ,tt.task_type
1182: ,ppe.CREATION_DATE
1183: /*4275236 : Replaced the function call with Local variable
1184: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
1185: */
1186: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
1187: ,ppe.TYPE_ID
1188: ,tt.task_type
1189: ,ppe.STATUS_CODE
1190: ,pps3.PROJECT_STATUS_NAME
1193: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
1194: -- Fix for Bug # 4319171.
1195: ,por.WEIGHTING_PERCENTAGE
1196: ,ppvsch.duration
1197: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
1198: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
1199: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
1200: ,pt.address_id
1201: ,addr.address1
1194: -- Fix for Bug # 4319171.
1195: ,por.WEIGHTING_PERCENTAGE
1196: ,ppvsch.duration
1197: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
1198: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
1199: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
1200: ,pt.address_id
1201: ,addr.address1
1202: ,addr.address2
1195: ,por.WEIGHTING_PERCENTAGE
1196: ,ppvsch.duration
1197: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
1198: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
1199: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
1200: ,pt.address_id
1201: ,addr.address1
1202: ,addr.address2
1203: ,addr.address3
1202: ,addr.address2
1203: ,addr.address3
1204: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
1205: ,ppe.wq_item_code
1206: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
1207: ,ppe.wq_uom_code
1208: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
1209: ,ppvsch.wq_planned_quantity
1210: ,ppe.wq_actual_entry_code
1204: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
1205: ,ppe.wq_item_code
1206: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
1207: ,ppe.wq_uom_code
1208: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
1209: ,ppvsch.wq_planned_quantity
1210: ,ppe.wq_actual_entry_code
1211: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
1212: ,tt.prog_entry_enable_flag
1207: ,ppe.wq_uom_code
1208: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
1209: ,ppvsch.wq_planned_quantity
1210: ,ppe.wq_actual_entry_code
1211: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
1212: ,tt.prog_entry_enable_flag
1213: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
1214: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
1215: ,ppe.task_progress_entry_page_id
1214: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
1215: ,ppe.task_progress_entry_page_id
1216: ,ppl.page_name
1217: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
1218: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE', NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
1219: ,tt.wq_enable_flag
1220: ,tt.prog_entry_req_flag
1221: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
1222: , ppru.estimated_remaining_effort
1259: ,DECODE(l_issue_lines_exist_flag,'Y',
1260: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE'),
1261: 0)
1262: ,to_number(null)
1263: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
1264: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
1265: ,ppeph.name
1266: -- Bug 6156686
1267: ,DECODE(l_cr_lines_exist_flag,'Y',
1294: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
1295: ) Percent_Complete_Cost
1296: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
1297: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
1298: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
1299: ,ppvsch.constraint_type_code
1300: ,ppvsch.Constraint_Date
1301: ,ppvsch.Early_Start_Date
1302: ,ppvsch.Early_Finish_Date
1304: ,ppvsch.Late_Finish_Date
1305: ,ppvsch.Free_Slack
1306: ,ppvsch.Total_Slack
1307: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1308: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
1309: Lowest_Task -- Fix for Bug # 4490532.
1310: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1311: /* Bug Fix 5466645
1312: -- ,to_number ( null ) Estimated_Baseline_Start
1472: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
1473: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
1474: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
1475: ,pt.gen_etc_source_code
1476: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
1477: ,ppe.wf_item_type
1478: ,ppe.wf_process
1479: ,ppe.wf_start_lead_days
1480: ,ppe.enable_wf_flag
1867: ,ppa.project_id
1868: ,ppv.display_sequence + p_sequence_offset --bug 4448499 adjust the display sequnece of sub-project tasks with the offset.
1869: ,ppvsch.milestone_flag
1870: /* 4275236 : Perf Enhancement - Replaced with Local variable
1871: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
1872: */
1873: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
1874: ,ppvsch.critical_flag
1875: /* 4275236 : Perf Enhancement - Replaced with Local variable
1872: */
1873: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
1874: ,ppvsch.critical_flag
1875: /* 4275236 : Perf Enhancement - Replaced with Local variable
1876: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
1877: */
1878: ,decode(NVL( ppvsch.critical_flag, 'N' ),'N',l_no,l_yes)
1879: ,por.object_id_from1
1880: ,por.object_type_from
1881: ,por.relationship_type
1882: ,por.relationship_subtype
1883: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1884: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1885: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1886: summary_element_flag -- Fix for Bug # 4490532.
1887: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1888: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1889: ,PPS.PROJECT_STATUS_NAME
1905: ,pps.status_icon_ind
1906: ,ppe.status_code
1907: ,pps2.project_status_name
1908: ,ppe.priority_code
1909: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
1910: ,ppe.carrying_out_organization_id
1911: ,hou.name
1912: ,ppe.inc_proj_progress_flag
1913: ,ppvsch.estimated_start_date
1935: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
1936: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
1937: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
1938: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
1939: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
1940: ,ppe.pm_source_code
1941: ,ppe.pm_source_reference
1942: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1943: /*4275236 : Replaced the function call with Local variable
1938: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
1939: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
1940: ,ppe.pm_source_code
1941: ,ppe.pm_source_reference
1942: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1943: /*4275236 : Replaced the function call with Local variable
1944: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1945: */
1946: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1940: ,ppe.pm_source_code
1941: ,ppe.pm_source_reference
1942: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1943: /*4275236 : Replaced the function call with Local variable
1944: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1945: */
1946: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1947: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1948: -- Fix for Bug # 4447949.
1942: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
1943: /*4275236 : Replaced the function call with Local variable
1944: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1945: */
1946: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1947: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1948: -- Fix for Bug # 4447949.
1949: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1950: -- Fix for Bug # 4447949.
1943: /*4275236 : Replaced the function call with Local variable
1944: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
1945: */
1946: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
1947: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1948: -- Fix for Bug # 4447949.
1949: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1950: -- Fix for Bug # 4447949.
1951: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
1947: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
1948: -- Fix for Bug # 4447949.
1949: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
1950: -- Fix for Bug # 4447949.
1951: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
1952: -- Fix for Bug # 4447949.
1953: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
1954: -- Fix for Bug # 4447949.
1955: ,papf.work_telephone
1952: -- Fix for Bug # 4447949.
1953: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
1954: -- Fix for Bug # 4447949.
1955: ,papf.work_telephone
1956: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
1957: ,pt.service_type_code
1958: ,pwt.name
1959: ,pt.work_type_id
1960: /*4275236 : Replaced the function call with Local variable
1957: ,pt.service_type_code
1958: ,pwt.name
1959: ,pt.work_type_id
1960: /*4275236 : Replaced the function call with Local variable
1961: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
1962: */
1963: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
1964: ,pt.chargeable_flag
1965: /*4275236 : Replaced the function call with Local variable
1962: */
1963: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
1964: ,pt.chargeable_flag
1965: /*4275236 : Replaced the function call with Local variable
1966: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
1967: */
1968: ,decode(pt.billable_flag,'Y',l_yes,l_no)
1969: ,pt.billable_flag
1970: /*4275236 : Replaced the function call with Local variable
1967: */
1968: ,decode(pt.billable_flag,'Y',l_yes,l_no)
1969: ,pt.billable_flag
1970: /*4275236 : Replaced the function call with Local variable
1971: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
1972: */
1973: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
1974: ,pt.receive_project_invoice_flag
1975: ,pt.start_date
1979: ,to_date(NULL)
1980: ,ppa.BASELINE_AS_OF_DATE
1981: ,ppru.LAST_UPDATE_DATE
1982: ,ppru.LAST_UPDATE_DATE
1983: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
1984: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
1985: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
1986: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
1987: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
1987: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
1988: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
1989: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
1990: /*4275236 : Replaced the function call with Local variable
1991: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
1992: */
1993: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
1994: ,ppe.CREATION_DATE
1995: /*4275236 : Replaced the function call with Local variable
1992: */
1993: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
1994: ,ppe.CREATION_DATE
1995: /*4275236 : Replaced the function call with Local variable
1996: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
1997: */
1998: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
1999: ,ppe.TYPE_ID
2000: ,tt.task_type
1994: ,ppe.CREATION_DATE
1995: /*4275236 : Replaced the function call with Local variable
1996: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
1997: */
1998: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
1999: ,ppe.TYPE_ID
2000: ,tt.task_type
2001: ,ppe.STATUS_CODE
2002: ,pps3.PROJECT_STATUS_NAME
2005: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
2006: -- Fix for Bug # 4319171.
2007: ,por.WEIGHTING_PERCENTAGE
2008: ,ppvsch.duration
2009: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2010: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2011: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2012: ,pt.address_id
2013: ,addr.address1
2006: -- Fix for Bug # 4319171.
2007: ,por.WEIGHTING_PERCENTAGE
2008: ,ppvsch.duration
2009: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2010: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2011: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2012: ,pt.address_id
2013: ,addr.address1
2014: ,addr.address2
2007: ,por.WEIGHTING_PERCENTAGE
2008: ,ppvsch.duration
2009: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2010: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2011: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2012: ,pt.address_id
2013: ,addr.address1
2014: ,addr.address2
2015: ,addr.address3
2014: ,addr.address2
2015: ,addr.address3
2016: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
2017: ,ppe.wq_item_code
2018: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
2019: ,ppe.wq_uom_code
2020: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2021: ,ppvsch.wq_planned_quantity
2022: ,ppe.wq_actual_entry_code
2016: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
2017: ,ppe.wq_item_code
2018: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
2019: ,ppe.wq_uom_code
2020: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2021: ,ppvsch.wq_planned_quantity
2022: ,ppe.wq_actual_entry_code
2023: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
2024: ,tt.prog_entry_enable_flag
2019: ,ppe.wq_uom_code
2020: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2021: ,ppvsch.wq_planned_quantity
2022: ,ppe.wq_actual_entry_code
2023: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
2024: ,tt.prog_entry_enable_flag
2025: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
2026: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
2027: ,ppe.task_progress_entry_page_id
2026: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
2027: ,ppe.task_progress_entry_page_id
2028: ,ppl.page_name
2029: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
2030: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE', NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
2031: ,tt.wq_enable_flag
2032: ,tt.prog_entry_req_flag
2033: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2034: , ppru.estimated_remaining_effort
2071: ,ppwa.lifecycle_version_id
2072: ,ppv.TASK_UNPUB_VER_STATUS_CODE
2073: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
2074: ,to_number(null)
2075: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2076: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2077: ,ppeph.name
2078: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2079: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2100: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
2101: ) Percent_Complete_Cost
2102: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
2103: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
2104: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
2105: ,ppvsch.constraint_type_code
2106: ,ppvsch.Constraint_Date
2107: ,ppvsch.Early_Start_Date
2108: ,ppvsch.Early_Finish_Date
2110: ,ppvsch.Late_Finish_Date
2111: ,ppvsch.Free_Slack
2112: ,ppvsch.Total_Slack
2113: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
2114: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
2115: Lowest_Task -- Fix for Bug # 4490532.
2116: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
2117: /* Bug Fix 5466645
2118: -- ,to_number ( null ) Estimated_Baseline_Start
2287: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2288: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
2289: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2290: ,pt.gen_etc_source_code
2291: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
2292: ,ppe.wf_item_type
2293: ,ppe.wf_process
2294: ,ppe.wf_start_lead_days
2295: ,ppe.enable_wf_flag
2730: ,ppa.project_id
2731: ,ppv.display_sequence + p_sequence_offset --bug 4448499 adjust the display sequnece of sub-project tasks with the offset.
2732: ,ppvsch.milestone_flag
2733: /* 4275236 : Perf Enhancement - Replaced with Local variable
2734: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
2735: */
2736: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
2737: ,ppvsch.critical_flag
2738: /* 4275236 : Perf Enhancement - Replaced with Local variable
2735: */
2736: ,decode(NVL( ppvsch.milestone_flag, 'N' ),'N',l_no,l_yes)
2737: ,ppvsch.critical_flag
2738: /* 4275236 : Perf Enhancement - Replaced with Local variable
2739: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
2740: */
2741: ,decode(NVL( ppvsch.critical_flag, 'N' ),'N',l_no,l_yes)
2742: ,por.object_id_from1
2743: ,por.object_type_from
2744: ,por.relationship_type
2745: ,por.relationship_subtype
2746: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
2747: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
2748: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
2749: summary_element_flag -- Fix for Bug # 4490532.
2750: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
2751: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
2752: ,PPS.PROJECT_STATUS_NAME
2768: ,pps.status_icon_ind
2769: ,ppe.status_code
2770: ,pps2.project_status_name
2771: ,ppe.priority_code
2772: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
2773: ,ppe.carrying_out_organization_id
2774: ,hou.name
2775: ,ppe.inc_proj_progress_flag
2776: ,ppvsch.estimated_start_date
2798: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
2799: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
2800: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
2801: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
2802: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
2803: ,ppe.pm_source_code
2804: ,ppe.pm_source_reference
2805: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
2806: /*4275236 : Replaced the function call with Local variable
2801: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
2802: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
2803: ,ppe.pm_source_code
2804: ,ppe.pm_source_reference
2805: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
2806: /*4275236 : Replaced the function call with Local variable
2807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
2808: */
2809: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
2803: ,ppe.pm_source_code
2804: ,ppe.pm_source_reference
2805: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
2806: /*4275236 : Replaced the function call with Local variable
2807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
2808: */
2809: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
2810: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
2811: -- Fix for Bug # 4447949.
2805: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
2806: /*4275236 : Replaced the function call with Local variable
2807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
2808: */
2809: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
2810: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
2811: -- Fix for Bug # 4447949.
2812: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
2813: -- Fix for Bug # 4447949.
2806: /*4275236 : Replaced the function call with Local variable
2807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
2808: */
2809: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
2810: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
2811: -- Fix for Bug # 4447949.
2812: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
2813: -- Fix for Bug # 4447949.
2814: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
2810: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
2811: -- Fix for Bug # 4447949.
2812: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
2813: -- Fix for Bug # 4447949.
2814: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
2815: -- Fix for Bug # 4447949.
2816: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
2817: -- Fix for Bug # 4447949.
2818: ,papf.work_telephone
2815: -- Fix for Bug # 4447949.
2816: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
2817: -- Fix for Bug # 4447949.
2818: ,papf.work_telephone
2819: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
2820: ,pt.service_type_code
2821: ,pwt.name
2822: ,pt.work_type_id
2823: /*4275236 : Replaced the function call with Local variable
2820: ,pt.service_type_code
2821: ,pwt.name
2822: ,pt.work_type_id
2823: /*4275236 : Replaced the function call with Local variable
2824: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
2825: */
2826: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
2827: ,pt.chargeable_flag
2828: /*4275236 : Replaced the function call with Local variable
2825: */
2826: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
2827: ,pt.chargeable_flag
2828: /*4275236 : Replaced the function call with Local variable
2829: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
2830: */
2831: ,decode(pt.billable_flag,'Y',l_yes,l_no)
2832: ,pt.billable_flag
2833: /*4275236 : Replaced the function call with Local variable
2830: */
2831: ,decode(pt.billable_flag,'Y',l_yes,l_no)
2832: ,pt.billable_flag
2833: /*4275236 : Replaced the function call with Local variable
2834: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
2835: */
2836: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
2837: ,pt.receive_project_invoice_flag
2838: ,pt.start_date
2842: ,to_date(NULL)
2843: ,ppa.BASELINE_AS_OF_DATE
2844: ,ppru.LAST_UPDATE_DATE
2845: ,ppru.LAST_UPDATE_DATE
2846: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
2847: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
2848: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
2849: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
2850: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
2850: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
2851: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
2852: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
2853: /*4275236 : Replaced the function call with Local variable
2854: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
2855: */
2856: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
2857: ,ppe.CREATION_DATE
2858: /*4275236 : Replaced the function call with Local variable
2855: */
2856: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
2857: ,ppe.CREATION_DATE
2858: /*4275236 : Replaced the function call with Local variable
2859: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
2860: */
2861: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
2862: ,ppe.TYPE_ID
2863: ,tt.task_type
2857: ,ppe.CREATION_DATE
2858: /*4275236 : Replaced the function call with Local variable
2859: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
2860: */
2861: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
2862: ,ppe.TYPE_ID
2863: ,tt.task_type
2864: ,ppe.STATUS_CODE
2865: ,pps3.PROJECT_STATUS_NAME
2868: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
2869: -- Fix for Bug # 4319171.
2870: ,por.WEIGHTING_PERCENTAGE
2871: ,ppvsch.duration
2872: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2873: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2874: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2875: ,pt.address_id
2876: ,addr.address1
2869: -- Fix for Bug # 4319171.
2870: ,por.WEIGHTING_PERCENTAGE
2871: ,ppvsch.duration
2872: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2873: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2874: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2875: ,pt.address_id
2876: ,addr.address1
2877: ,addr.address2
2870: ,por.WEIGHTING_PERCENTAGE
2871: ,ppvsch.duration
2872: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
2873: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
2874: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
2875: ,pt.address_id
2876: ,addr.address1
2877: ,addr.address2
2878: ,addr.address3
2877: ,addr.address2
2878: ,addr.address3
2879: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
2880: ,ppe.wq_item_code
2881: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
2882: ,ppe.wq_uom_code
2883: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2884: ,ppvsch.wq_planned_quantity
2885: ,ppe.wq_actual_entry_code
2879: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
2880: ,ppe.wq_item_code
2881: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
2882: ,ppe.wq_uom_code
2883: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2884: ,ppvsch.wq_planned_quantity
2885: ,ppe.wq_actual_entry_code
2886: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
2887: ,tt.prog_entry_enable_flag
2882: ,ppe.wq_uom_code
2883: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
2884: ,ppvsch.wq_planned_quantity
2885: ,ppe.wq_actual_entry_code
2886: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
2887: ,tt.prog_entry_enable_flag
2888: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
2889: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
2890: ,ppe.task_progress_entry_page_id
2889: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
2890: ,ppe.task_progress_entry_page_id
2891: ,ppl.page_name
2892: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
2893: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE', NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
2894: ,tt.wq_enable_flag
2895: ,tt.prog_entry_req_flag
2896: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2897: , ppru.estimated_remaining_effort
2934: ,ppwa.lifecycle_version_id
2935: ,ppv.TASK_UNPUB_VER_STATUS_CODE
2936: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
2937: ,to_number(null)
2938: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2939: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2940: ,ppeph.name
2941: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2942: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2963: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
2964: ) Percent_Complete_Cost
2965: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
2966: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
2967: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
2968: ,ppvsch.constraint_type_code
2969: ,ppvsch.Constraint_Date
2970: ,ppvsch.Early_Start_Date
2971: ,ppvsch.Early_Finish_Date
2973: ,ppvsch.Late_Finish_Date
2974: ,ppvsch.Free_Slack
2975: ,ppvsch.Total_Slack
2976: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
2977: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
2978: Lowest_Task -- Fix for Bug # 4490532.
2979: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
2980: /* Bug Fix 5466645
2981: -- ,to_number ( null ) Estimated_Baseline_Start
3145: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
3146: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
3147: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
3148: ,pt.gen_etc_source_code
3149: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
3150: ,ppe.wf_item_type
3151: ,ppe.wf_process
3152: ,ppe.wf_start_lead_days
3153: ,ppe.enable_wf_flag
3407:
3408: x_return_status := FND_API.G_RET_STS_SUCCESS;
3409:
3410: /*4275236: Perf Enhancements*/
3411: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
3412: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
3413:
3414: -- Bug # 4875311.
3415:
3408: x_return_status := FND_API.G_RET_STS_SUCCESS;
3409:
3410: /*4275236: Perf Enhancements*/
3411: l_yes := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','Y');
3412: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
3413:
3414: -- Bug # 4875311.
3415:
3416: -- Bug Fix 5609629
3669: ,ppa.project_id
3670: ,ppv.display_sequence + p_sequence_offset --bug 4448499
3671: ,ppvsch.milestone_flag
3672: /*4275236: Replaced the Function Call with local variable
3673: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
3674: */
3675: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
3676: ,ppvsch.critical_flag
3677: /*4275236: Replaced the Function Call with local variable
3674: */
3675: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
3676: ,ppvsch.critical_flag
3677: /*4275236: Replaced the Function Call with local variable
3678: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
3679: */
3680: ,decode(ppvsch.critical_flag,'Y',l_yes,l_no)
3681: ,por.object_id_from1
3682: ,por.object_type_from
3683: ,por.relationship_type
3684: ,por.relationship_subtype
3685: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
3686: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
3687: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
3688: summary_element_flag -- Fix for Bug # 4490532.
3689: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
3690: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
3691: ,PPS.PROJECT_STATUS_NAME
3707: ,pps.status_icon_ind
3708: ,ppe.status_code
3709: ,pps2.project_status_name
3710: ,ppe.priority_code
3711: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
3712: ,ppe.carrying_out_organization_id
3713: ,hou.name
3714: ,ppe.inc_proj_progress_flag
3715: ,ppvsch.estimated_start_date
3737: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
3738: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
3739: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
3740: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
3741: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
3742: ,ppe.pm_source_code
3743: ,ppe.pm_source_reference
3744: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
3745: /*4275236: Replaced the Function Call with local variable
3740: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
3741: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
3742: ,ppe.pm_source_code
3743: ,ppe.pm_source_reference
3744: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
3745: /*4275236: Replaced the Function Call with local variable
3746: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
3747: */
3748: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
3742: ,ppe.pm_source_code
3743: ,ppe.pm_source_reference
3744: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
3745: /*4275236: Replaced the Function Call with local variable
3746: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
3747: */
3748: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
3749: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
3750: -- Fix for Bug # 4447949.
3744: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
3745: /*4275236: Replaced the Function Call with local variable
3746: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
3747: */
3748: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
3749: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
3750: -- Fix for Bug # 4447949.
3751: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
3752: -- Fix for Bug # 4447949.
3745: /*4275236: Replaced the Function Call with local variable
3746: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
3747: */
3748: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
3749: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
3750: -- Fix for Bug # 4447949.
3751: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
3752: -- Fix for Bug # 4447949.
3753: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
3749: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
3750: -- Fix for Bug # 4447949.
3751: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
3752: -- Fix for Bug # 4447949.
3753: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
3754: -- Fix for Bug # 4447949.
3755: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
3756: -- Fix for Bug # 4447949.
3757: ,papf.work_telephone
3754: -- Fix for Bug # 4447949.
3755: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
3756: -- Fix for Bug # 4447949.
3757: ,papf.work_telephone
3758: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
3759: ,pt.service_type_code
3760: ,pwt.name
3761: ,pt.work_type_id
3762: /*4275236: Replaced the Function Call with local variable
3759: ,pt.service_type_code
3760: ,pwt.name
3761: ,pt.work_type_id
3762: /*4275236: Replaced the Function Call with local variable
3763: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
3764: */
3765: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
3766: ,pt.chargeable_flag
3767: /*4275236: Replaced the Function Call with local variable
3764: */
3765: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
3766: ,pt.chargeable_flag
3767: /*4275236: Replaced the Function Call with local variable
3768: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
3769: */
3770: ,decode(pt.billable_flag,'Y',l_yes,l_no)
3771: ,pt.billable_flag
3772: /*4275236: Replaced the Function Call with local variable
3769: */
3770: ,decode(pt.billable_flag,'Y',l_yes,l_no)
3771: ,pt.billable_flag
3772: /*4275236: Replaced the Function Call with local variable
3773: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
3774: */
3775: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
3776: ,pt.receive_project_invoice_flag
3777: ,pt.start_date
3781: ,to_date(NULL)
3782: ,ppa.BASELINE_AS_OF_DATE
3783: ,ppru.LAST_UPDATE_DATE
3784: ,ppru.LAST_UPDATE_DATE
3785: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
3786: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
3787: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
3788: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
3789: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
3789: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
3790: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
3791: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
3792: /*4275236: Replaced the Function Call with local variable
3793: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
3794: */
3795: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
3796: ,ppe.CREATION_DATE
3797: /*4275236: Replaced the Function Call with local variable
3794: */
3795: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
3796: ,ppe.CREATION_DATE
3797: /*4275236: Replaced the Function Call with local variable
3798: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
3799: */
3800: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
3801: ,ppe.TYPE_ID
3802: ,tt.task_type
3796: ,ppe.CREATION_DATE
3797: /*4275236: Replaced the Function Call with local variable
3798: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
3799: */
3800: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
3801: ,ppe.TYPE_ID
3802: ,tt.task_type
3803: ,ppe.STATUS_CODE
3804: ,pps3.PROJECT_STATUS_NAME
3807: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
3808: -- Fix for Bug # 4319171.
3809: ,por.WEIGHTING_PERCENTAGE
3810: ,ppvsch.duration
3811: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
3812: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
3813: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
3814: ,pt.address_id
3815: ,addr.address1
3808: -- Fix for Bug # 4319171.
3809: ,por.WEIGHTING_PERCENTAGE
3810: ,ppvsch.duration
3811: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
3812: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
3813: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
3814: ,pt.address_id
3815: ,addr.address1
3816: ,addr.address2
3809: ,por.WEIGHTING_PERCENTAGE
3810: ,ppvsch.duration
3811: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
3812: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
3813: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
3814: ,pt.address_id
3815: ,addr.address1
3816: ,addr.address2
3817: ,addr.address3
3816: ,addr.address2
3817: ,addr.address3
3818: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
3819: ,ppe.wq_item_code
3820: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
3821: ,ppe.wq_uom_code
3822: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
3823: ,ppvsch.wq_planned_quantity
3824: ,ppe.wq_actual_entry_code
3818: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
3819: ,ppe.wq_item_code
3820: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
3821: ,ppe.wq_uom_code
3822: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
3823: ,ppvsch.wq_planned_quantity
3824: ,ppe.wq_actual_entry_code
3825: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
3826: ,tt.prog_entry_enable_flag
3821: ,ppe.wq_uom_code
3822: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
3823: ,ppvsch.wq_planned_quantity
3824: ,ppe.wq_actual_entry_code
3825: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
3826: ,tt.prog_entry_enable_flag
3827: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
3828: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
3829: ,ppe.task_progress_entry_page_id
3828: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
3829: ,ppe.task_progress_entry_page_id
3830: ,ppl.page_name
3831: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
3832: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
3833: ,tt.wq_enable_flag
3834: ,tt.prog_entry_req_flag
3835: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
3836: , ppru.ppl_act_effort_to_date
3866: ,ppwa.lifecycle_version_id
3867: ,ppv.TASK_UNPUB_VER_STATUS_CODE
3868: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
3869: ,to_number(null)
3870: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3871: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3872: ,ppeph.name
3873: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
3874: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
3934: , null))) Percent_Complete_Cost
3935: -- End Bug # 4546322.
3936: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
3937: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
3938: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
3939: ,ppvsch.constraint_type_code
3940: ,ppvsch.Constraint_Date
3941: ,ppvsch.Early_Start_Date
3942: ,ppvsch.Early_Finish_Date
3944: ,ppvsch.Late_Finish_Date
3945: ,ppvsch.Free_Slack
3946: ,ppvsch.Total_Slack
3947: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
3948: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
3949: Lowest_Task -- Fix for Bug # 4490532.
3950: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
3951: /* Bug Fix 5466645
3952: -- ,to_number ( null ) Estimated_Baseline_Start
4116: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4117: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4118: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4119: ,pt.gen_etc_source_code
4120: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4121: ,ppe.wf_item_type
4122: ,ppe.wf_process
4123: ,ppe.wf_start_lead_days
4124: ,ppe.enable_wf_flag
4494: ,ppa.project_id
4495: ,ppv.display_sequence + p_sequence_offset --bug 4448499
4496: ,ppvsch.milestone_flag
4497: /*4275236: Replaced the Function Call with local variable
4498: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
4499: */
4500: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
4501: ,ppvsch.critical_flag
4502: /*4275236: Replaced the Function Call with local variable
4499: */
4500: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
4501: ,ppvsch.critical_flag
4502: /*4275236: Replaced the Function Call with local variable
4503: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
4504: */
4505: ,decode(ppvsch.critical_flag,'Y',l_yes,l_no)
4506: ,por.object_id_from1
4507: ,por.object_type_from
4508: ,por.relationship_type
4509: ,por.relationship_subtype
4510: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
4511: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
4512: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
4513: summary_element_flag -- Fix for Bug # 4490532.
4514: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
4515: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
4516: ,PPS.PROJECT_STATUS_NAME
4532: ,pps.status_icon_ind
4533: ,ppe.status_code
4534: ,pps2.project_status_name
4535: ,ppe.priority_code
4536: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
4537: ,ppe.carrying_out_organization_id
4538: ,hou.name
4539: ,ppe.inc_proj_progress_flag
4540: ,ppvsch.estimated_start_date
4562: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
4563: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
4564: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
4565: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
4566: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
4567: ,ppe.pm_source_code
4568: ,ppe.pm_source_reference
4569: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
4570: /*4275236: Replaced the Function Call with local variable
4565: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
4566: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
4567: ,ppe.pm_source_code
4568: ,ppe.pm_source_reference
4569: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
4570: /*4275236: Replaced the Function Call with local variable
4571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
4572: */
4573: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
4567: ,ppe.pm_source_code
4568: ,ppe.pm_source_reference
4569: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
4570: /*4275236: Replaced the Function Call with local variable
4571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
4572: */
4573: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
4574: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
4575: -- Fix for Bug # 4447949.
4569: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
4570: /*4275236: Replaced the Function Call with local variable
4571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
4572: */
4573: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
4574: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
4575: -- Fix for Bug # 4447949.
4576: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
4577: -- Fix for Bug # 4447949.
4570: /*4275236: Replaced the Function Call with local variable
4571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
4572: */
4573: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
4574: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
4575: -- Fix for Bug # 4447949.
4576: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
4577: -- Fix for Bug # 4447949.
4578: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
4574: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
4575: -- Fix for Bug # 4447949.
4576: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
4577: -- Fix for Bug # 4447949.
4578: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
4579: -- Fix for Bug # 4447949.
4580: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
4581: -- Fix for Bug # 4447949.
4582: ,papf.work_telephone
4579: -- Fix for Bug # 4447949.
4580: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
4581: -- Fix for Bug # 4447949.
4582: ,papf.work_telephone
4583: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
4584: ,pt.service_type_code
4585: ,pwt.name
4586: ,pt.work_type_id
4587: /*4275236: Replaced the Function Call with local variable
4584: ,pt.service_type_code
4585: ,pwt.name
4586: ,pt.work_type_id
4587: /*4275236: Replaced the Function Call with local variable
4588: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
4589: */
4590: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
4591: ,pt.chargeable_flag
4592: /*4275236: Replaced the Function Call with local variable
4589: */
4590: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
4591: ,pt.chargeable_flag
4592: /*4275236: Replaced the Function Call with local variable
4593: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
4594: */
4595: ,decode(pt.billable_flag,'Y',l_yes,l_no)
4596: ,pt.billable_flag
4597: /*4275236: Replaced the Function Call with local variable
4594: */
4595: ,decode(pt.billable_flag,'Y',l_yes,l_no)
4596: ,pt.billable_flag
4597: /*4275236: Replaced the Function Call with local variable
4598: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
4599: */
4600: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
4601: ,pt.receive_project_invoice_flag
4602: ,pt.start_date
4606: ,to_date(NULL)
4607: ,ppa.BASELINE_AS_OF_DATE
4608: ,ppru.LAST_UPDATE_DATE
4609: ,ppru.LAST_UPDATE_DATE
4610: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
4611: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
4612: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
4613: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
4614: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
4614: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
4615: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
4616: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
4617: /*4275236: Replaced the Function Call with local variable
4618: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
4619: */
4620: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
4621: ,ppe.CREATION_DATE
4622: /*4275236: Replaced the Function Call with local variable
4619: */
4620: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
4621: ,ppe.CREATION_DATE
4622: /*4275236: Replaced the Function Call with local variable
4623: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
4624: */
4625: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
4626: ,ppe.TYPE_ID
4627: ,tt.task_type
4621: ,ppe.CREATION_DATE
4622: /*4275236: Replaced the Function Call with local variable
4623: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
4624: */
4625: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
4626: ,ppe.TYPE_ID
4627: ,tt.task_type
4628: ,ppe.STATUS_CODE
4629: ,pps3.PROJECT_STATUS_NAME
4632: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
4633: -- Fix for Bug # 4319171.
4634: ,por.WEIGHTING_PERCENTAGE
4635: ,ppvsch.duration
4636: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
4637: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
4638: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
4639: ,pt.address_id
4640: ,addr.address1
4633: -- Fix for Bug # 4319171.
4634: ,por.WEIGHTING_PERCENTAGE
4635: ,ppvsch.duration
4636: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
4637: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
4638: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
4639: ,pt.address_id
4640: ,addr.address1
4641: ,addr.address2
4634: ,por.WEIGHTING_PERCENTAGE
4635: ,ppvsch.duration
4636: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
4637: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
4638: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
4639: ,pt.address_id
4640: ,addr.address1
4641: ,addr.address2
4642: ,addr.address3
4641: ,addr.address2
4642: ,addr.address3
4643: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
4644: ,ppe.wq_item_code
4645: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
4646: ,ppe.wq_uom_code
4647: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
4648: ,ppvsch.wq_planned_quantity
4649: ,ppe.wq_actual_entry_code
4643: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
4644: ,ppe.wq_item_code
4645: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
4646: ,ppe.wq_uom_code
4647: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
4648: ,ppvsch.wq_planned_quantity
4649: ,ppe.wq_actual_entry_code
4650: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
4651: ,tt.prog_entry_enable_flag
4646: ,ppe.wq_uom_code
4647: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
4648: ,ppvsch.wq_planned_quantity
4649: ,ppe.wq_actual_entry_code
4650: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
4651: ,tt.prog_entry_enable_flag
4652: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
4653: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
4654: ,ppe.task_progress_entry_page_id
4653: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
4654: ,ppe.task_progress_entry_page_id
4655: ,ppl.page_name
4656: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
4657: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
4658: ,tt.wq_enable_flag
4659: ,tt.prog_entry_req_flag
4660: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
4661: , ppru.ppl_act_effort_to_date
4691: ,ppwa.lifecycle_version_id
4692: ,ppv.TASK_UNPUB_VER_STATUS_CODE
4693: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
4694: ,to_number(null)
4695: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4696: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4697: ,ppeph.name
4698: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
4699: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
4759: , null))) Percent_Complete_Cost
4760: -- End Bug # 4546322.
4761: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
4762: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
4763: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
4764: ,ppvsch.constraint_type_code
4765: ,ppvsch.Constraint_Date
4766: ,ppvsch.Early_Start_Date
4767: ,ppvsch.Early_Finish_Date
4769: ,ppvsch.Late_Finish_Date
4770: ,ppvsch.Free_Slack
4771: ,ppvsch.Total_Slack
4772: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
4773: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
4774: Lowest_Task -- Fix for Bug # 4490532.
4775: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
4776: /* Bug Fix 5466645
4777: -- ,to_number ( null ) Estimated_Baseline_Start
4941: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4942: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4943: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4944: ,pt.gen_etc_source_code
4945: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4946: ,ppe.wf_item_type
4947: ,ppe.wf_process
4948: ,ppe.wf_start_lead_days
4949: ,ppe.enable_wf_flag
5320: ,ppa.project_id
5321: ,ppv.display_sequence + p_sequence_offset --bug 4448499
5322: ,ppvsch.milestone_flag
5323: /*4275236: Replaced the Function Call with local variable
5324: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
5325: */
5326: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
5327: ,ppvsch.critical_flag
5328: /*4275236: Replaced the Function Call with local variable
5325: */
5326: ,decode(ppvsch.milestone_flag,'Y',l_yes,l_no)
5327: ,ppvsch.critical_flag
5328: /*4275236: Replaced the Function Call with local variable
5329: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
5330: */
5331: ,decode(ppvsch.critical_flag,'Y',l_yes,l_no)
5332: ,por.object_id_from1
5333: ,por.object_type_from
5334: ,por.relationship_type
5335: ,por.relationship_subtype
5336: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
5337: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
5338: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
5339: summary_element_flag -- Fix for Bug # 4490532.
5340: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
5341: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
5342: ,PPS.PROJECT_STATUS_NAME
5358: ,pps.status_icon_ind
5359: ,ppe.status_code
5360: ,pps2.project_status_name
5361: ,ppe.priority_code
5362: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
5363: ,ppe.carrying_out_organization_id
5364: ,hou.name
5365: ,ppe.inc_proj_progress_flag
5366: ,ppvsch.estimated_start_date
5388: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
5389: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
5390: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
5391: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
5392: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
5393: ,ppe.pm_source_code
5394: ,ppe.pm_source_reference
5395: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
5396: /*4275236: Replaced the Function Call with local variable
5391: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
5392: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
5393: ,ppe.pm_source_code
5394: ,ppe.pm_source_reference
5395: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
5396: /*4275236: Replaced the Function Call with local variable
5397: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
5398: */
5399: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
5393: ,ppe.pm_source_code
5394: ,ppe.pm_source_reference
5395: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
5396: /*4275236: Replaced the Function Call with local variable
5397: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
5398: */
5399: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
5400: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
5401: -- Fix for Bug # 4447949.
5395: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
5396: /*4275236: Replaced the Function Call with local variable
5397: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
5398: */
5399: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
5400: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
5401: -- Fix for Bug # 4447949.
5402: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
5403: -- Fix for Bug # 4447949.
5396: /*4275236: Replaced the Function Call with local variable
5397: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
5398: */
5399: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type),'Y',l_yes,l_no)
5400: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
5401: -- Fix for Bug # 4447949.
5402: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
5403: -- Fix for Bug # 4447949.
5404: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
5400: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
5401: -- Fix for Bug # 4447949.
5402: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
5403: -- Fix for Bug # 4447949.
5404: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
5405: -- Fix for Bug # 4447949.
5406: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
5407: -- Fix for Bug # 4447949.
5408: ,papf.work_telephone
5405: -- Fix for Bug # 4447949.
5406: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
5407: -- Fix for Bug # 4447949.
5408: ,papf.work_telephone
5409: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
5410: ,pt.service_type_code
5411: ,pwt.name
5412: ,pt.work_type_id
5413: /*4275236: Replaced the Function Call with local variable
5410: ,pt.service_type_code
5411: ,pwt.name
5412: ,pt.work_type_id
5413: /*4275236: Replaced the Function Call with local variable
5414: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
5415: */
5416: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
5417: ,pt.chargeable_flag
5418: /*4275236: Replaced the Function Call with local variable
5415: */
5416: ,decode(pt.chargeable_flag,'Y',l_yes,l_no)
5417: ,pt.chargeable_flag
5418: /*4275236: Replaced the Function Call with local variable
5419: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
5420: */
5421: ,decode(pt.billable_flag,'Y',l_yes,l_no)
5422: ,pt.billable_flag
5423: /*4275236: Replaced the Function Call with local variable
5420: */
5421: ,decode(pt.billable_flag,'Y',l_yes,l_no)
5422: ,pt.billable_flag
5423: /*4275236: Replaced the Function Call with local variable
5424: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
5425: */
5426: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
5427: ,pt.receive_project_invoice_flag
5428: ,pt.start_date
5432: ,to_date(NULL)
5433: ,ppa.BASELINE_AS_OF_DATE
5434: ,ppru.LAST_UPDATE_DATE
5435: ,ppru.LAST_UPDATE_DATE
5436: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
5437: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
5438: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
5439: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
5440: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
5440: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
5441: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
5442: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
5443: /*4275236: Replaced the Function Call with local variable
5444: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
5445: */
5446: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
5447: ,ppe.CREATION_DATE
5448: /*4275236: Replaced the Function Call with local variable
5445: */
5446: ,decode(ppvsch.actual_finish_date,NULL,l_no,l_yes)
5447: ,ppe.CREATION_DATE
5448: /*4275236: Replaced the Function Call with local variable
5449: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
5450: */
5451: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
5452: ,ppe.TYPE_ID
5453: ,tt.task_type
5447: ,ppe.CREATION_DATE
5448: /*4275236: Replaced the Function Call with local variable
5449: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
5450: */
5451: ,decode(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id),'Y',l_yes,l_no)
5452: ,ppe.TYPE_ID
5453: ,tt.task_type
5454: ,ppe.STATUS_CODE
5455: ,pps3.PROJECT_STATUS_NAME
5458: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
5459: -- Fix for Bug # 4319171.
5460: ,por.WEIGHTING_PERCENTAGE
5461: ,ppvsch.duration
5462: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
5463: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
5464: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
5465: ,pt.address_id
5466: ,addr.address1
5459: -- Fix for Bug # 4319171.
5460: ,por.WEIGHTING_PERCENTAGE
5461: ,ppvsch.duration
5462: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
5463: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
5464: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
5465: ,pt.address_id
5466: ,addr.address1
5467: ,addr.address2
5460: ,por.WEIGHTING_PERCENTAGE
5461: ,ppvsch.duration
5462: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
5463: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
5464: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
5465: ,pt.address_id
5466: ,addr.address1
5467: ,addr.address2
5468: ,addr.address3
5467: ,addr.address2
5468: ,addr.address3
5469: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
5470: ,ppe.wq_item_code
5471: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
5472: ,ppe.wq_uom_code
5473: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
5474: ,ppvsch.wq_planned_quantity
5475: ,ppe.wq_actual_entry_code
5469: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
5470: ,ppe.wq_item_code
5471: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
5472: ,ppe.wq_uom_code
5473: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
5474: ,ppvsch.wq_planned_quantity
5475: ,ppe.wq_actual_entry_code
5476: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
5477: ,tt.prog_entry_enable_flag
5472: ,ppe.wq_uom_code
5473: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
5474: ,ppvsch.wq_planned_quantity
5475: ,ppe.wq_actual_entry_code
5476: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
5477: ,tt.prog_entry_enable_flag
5478: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
5479: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
5480: ,ppe.task_progress_entry_page_id
5479: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
5480: ,ppe.task_progress_entry_page_id
5481: ,ppl.page_name
5482: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
5483: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
5484: ,tt.wq_enable_flag
5485: ,tt.prog_entry_req_flag
5486: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
5487: , ppru.ppl_act_effort_to_date
5517: ,ppwa.lifecycle_version_id
5518: ,ppv.TASK_UNPUB_VER_STATUS_CODE
5519: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
5520: ,to_number(null)
5521: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5522: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5523: ,ppeph.name
5524: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
5525: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
5585: , null))) Percent_Complete_Cost
5586: -- End Bug # 4546322.
5587: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
5588: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
5589: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
5590: ,ppvsch.constraint_type_code
5591: ,ppvsch.Constraint_Date
5592: ,ppvsch.Early_Start_Date
5593: ,ppvsch.Early_Finish_Date
5595: ,ppvsch.Late_Finish_Date
5596: ,ppvsch.Free_Slack
5597: ,ppvsch.Total_Slack
5598: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
5599: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
5600: Lowest_Task -- Fix for Bug # 4490532.
5601: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
5602: /* Bug Fix 5466645
5603: -- ,to_number ( null ) Estimated_Baseline_Start
5767: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
5768: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
5769: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
5770: ,pt.gen_etc_source_code
5771: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
5772: ,ppe.wf_item_type
5773: ,ppe.wf_process
5774: ,ppe.wf_start_lead_days
5775: ,ppe.enable_wf_flag
6338: ,ppe.proj_element_id
6339: ,ppv1.project_id
6340: ,ppv3.display_sequence
6341: ,'N' milestone_flag
6342: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6343: ,'N' critical_flag
6344: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6345: ,por2.object_id_from1
6346: ,por2.object_type_from
6340: ,ppv3.display_sequence
6341: ,'N' milestone_flag
6342: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6343: ,'N' critical_flag
6344: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6345: ,por2.object_id_from1
6346: ,por2.object_type_from
6347: ,por2.relationship_type
6348: ,por2.relationship_subtype
6399: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
6400: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
6401: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
6402: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
6403: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6404: ,ppe.pm_source_code
6405: ,ppe.pm_source_reference
6406: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6407: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6402: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
6403: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6404: ,ppe.pm_source_code
6405: ,ppe.pm_source_reference
6406: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6407: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6408: ,to_number(null)
6409: ,to_number(null)
6410: ,papf.work_telephone
6403: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6404: ,ppe.pm_source_code
6405: ,ppe.pm_source_reference
6406: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6407: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6408: ,to_number(null)
6409: ,to_number(null)
6410: ,papf.work_telephone
6411: ,to_char(null)
6431: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
6432: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
6433: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
6434: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
6435: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
6436: ,ppe.CREATION_DATE
6437: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N')
6438: ,ppe.TYPE_ID
6439: ,to_char(null)
6433: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
6434: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
6435: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
6436: ,ppe.CREATION_DATE
6437: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N')
6438: ,ppe.TYPE_ID
6439: ,to_char(null)
6440: ,ppe.STATUS_CODE
6441: ,to_char(null)
6444: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
6445: -- Fix for Bug # 4319171.
6446: ,to_number(null)
6447: ,ppvsch.duration
6448: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6449: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6450: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6451: ,to_number(null)
6452: ,to_char(null)
6445: -- Fix for Bug # 4319171.
6446: ,to_number(null)
6447: ,ppvsch.duration
6448: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6449: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6450: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6451: ,to_number(null)
6452: ,to_char(null)
6453: ,to_char(null)
6446: ,to_number(null)
6447: ,ppvsch.duration
6448: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6449: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6450: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6451: ,to_number(null)
6452: ,to_char(null)
6453: ,to_char(null)
6454: ,to_char(null)
6453: ,to_char(null)
6454: ,to_char(null)
6455: ,to_char(null)
6456: ,ppe.wq_item_code
6457: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
6458: ,ppe.wq_uom_code
6459: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6460: ,ppvsch.wq_planned_quantity
6461: ,ppe.wq_actual_entry_code
6455: ,to_char(null)
6456: ,ppe.wq_item_code
6457: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
6458: ,ppe.wq_uom_code
6459: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6460: ,ppvsch.wq_planned_quantity
6461: ,ppe.wq_actual_entry_code
6462: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
6463: ,to_char(null)
6458: ,ppe.wq_uom_code
6459: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6460: ,ppvsch.wq_planned_quantity
6461: ,ppe.wq_actual_entry_code
6462: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
6463: ,to_char(null)
6464: ,to_char(null)
6465: ,to_char(null)
6466: ,ppe.task_progress_entry_page_id
6502: ,to_number(null)
6503: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
6504: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
6505: ,to_number(null)
6506: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6507: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6508: ,to_char(null)
6509: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6510: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
6531: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
6532: ) Percent_Complete_Cost
6533: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
6534: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
6535: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
6536: ,ppvsch.constraint_type_code
6537: ,ppvsch.Constraint_Date
6538: ,ppvsch.Early_Start_Date
6539: ,ppvsch.Early_Finish_Date
6541: ,ppvsch.Late_Finish_Date
6542: ,ppvsch.Free_Slack
6543: ,ppvsch.Total_Slack
6544: -- ,decode(ppv1.prg_group, null -- Fix for Bug # 4490532.
6545: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv1.element_version_id),'Y','N','N','Y')
6546: Lowest_Task -- Fix for Bug # 4490532.
6547: -- , ' ') Lowest_Task -- Fix for Bug # 4279419.--4284056 changed from 'Y' to ' ' -- Fix for Bug # 4490532.
6548: /* Bug Fix 5466645
6549: -- ,to_number ( null ) Estimated_Baseline_Start
6815: ,ppe.proj_element_id
6816: ,ppv1.project_id
6817: ,ppv3.display_sequence
6818: ,'N' milestone_flag
6819: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6820: ,'N' critical_flag
6821: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6822: ,por2.object_id_from1
6823: ,por2.object_type_from
6817: ,ppv3.display_sequence
6818: ,'N' milestone_flag
6819: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6820: ,'N' critical_flag
6821: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', 'N')
6822: ,por2.object_id_from1
6823: ,por2.object_type_from
6824: ,por2.relationship_type
6825: ,por2.relationship_subtype
6876: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
6877: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
6878: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
6879: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
6880: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6881: ,ppe.pm_source_code
6882: ,ppe.pm_source_reference
6883: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6884: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6879: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
6880: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6881: ,ppe.pm_source_code
6882: ,ppe.pm_source_reference
6883: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6884: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6885: ,to_number(null)
6886: ,to_number(null)
6887: ,papf.work_telephone
6880: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
6881: ,ppe.pm_source_code
6882: ,ppe.pm_source_reference
6883: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type)
6884: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv1.element_version_id, ppv1.object_type))
6885: ,to_number(null)
6886: ,to_number(null)
6887: ,papf.work_telephone
6888: ,to_char(null)
6908: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
6909: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
6910: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
6911: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
6912: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
6913: ,ppe.CREATION_DATE
6914: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N')
6915: ,ppe.TYPE_ID
6916: ,to_char(null)
6910: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
6911: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
6912: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
6913: ,ppe.CREATION_DATE
6914: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N')
6915: ,ppe.TYPE_ID
6916: ,to_char(null)
6917: ,ppe.STATUS_CODE
6918: ,to_char(null)
6921: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
6922: -- Fix for Bug # 4319171.
6923: ,to_number(null)
6924: ,ppvsch.duration
6925: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6926: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6927: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6928: ,to_number(null)
6929: ,to_char(null)
6922: -- Fix for Bug # 4319171.
6923: ,to_number(null)
6924: ,ppvsch.duration
6925: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6926: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6927: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6928: ,to_number(null)
6929: ,to_char(null)
6930: ,to_char(null)
6923: ,to_number(null)
6924: ,ppvsch.duration
6925: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
6926: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
6927: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
6928: ,to_number(null)
6929: ,to_char(null)
6930: ,to_char(null)
6931: ,to_char(null)
6930: ,to_char(null)
6931: ,to_char(null)
6932: ,to_char(null)
6933: ,ppe.wq_item_code
6934: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
6935: ,ppe.wq_uom_code
6936: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6937: ,ppvsch.wq_planned_quantity
6938: ,ppe.wq_actual_entry_code
6932: ,to_char(null)
6933: ,ppe.wq_item_code
6934: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
6935: ,ppe.wq_uom_code
6936: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6937: ,ppvsch.wq_planned_quantity
6938: ,ppe.wq_actual_entry_code
6939: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
6940: ,to_char(null)
6935: ,ppe.wq_uom_code
6936: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
6937: ,ppvsch.wq_planned_quantity
6938: ,ppe.wq_actual_entry_code
6939: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
6940: ,to_char(null)
6941: ,to_char(null)
6942: ,to_char(null)
6943: ,ppe.task_progress_entry_page_id
6986: ,to_number(null)
6987: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
6988: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
6989: ,to_number(null)
6990: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6991: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6992: ,to_char(null)
6993: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6994: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7015: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
7016: ) Percent_Complete_Cost
7017: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
7018: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
7019: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
7020: ,ppvsch.constraint_type_code
7021: ,ppvsch.Constraint_Date
7022: ,ppvsch.Early_Start_Date
7023: ,ppvsch.Early_Finish_Date
7025: ,ppvsch.Late_Finish_Date
7026: ,ppvsch.Free_Slack
7027: ,ppvsch.Total_Slack
7028: -- ,decode(ppv1.prg_group, null -- Fix for Bug # 4490532.
7029: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv1.element_version_id),'Y','N','N','Y')
7030: Lowest_Task -- Fix for Bug # 4490532.
7031: -- , ' ') Lowest_Task -- Fix for Bug # 4279419.--4284056 changed from 'Y' to ' ' -- Fix for Bug # 4490532.
7032: /* Bug Fix 5466645
7033: -- ,to_number ( null ) Estimated_Baseline_Start
7722: ,ppe.proj_element_id
7723: ,ppa.project_id
7724: ,ppv.display_sequence
7725: ,ppvsch.milestone_flag
7726: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
7727: ,ppvsch.critical_flag
7728: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
7729: ,por.object_id_from1
7730: ,por.object_type_from
7724: ,ppv.display_sequence
7725: ,ppvsch.milestone_flag
7726: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
7727: ,ppvsch.critical_flag
7728: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
7729: ,por.object_id_from1
7730: ,por.object_type_from
7731: ,por.relationship_type
7732: ,por.relationship_subtype
7731: ,por.relationship_type
7732: ,por.relationship_subtype
7733: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
7734: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
7735: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
7736: summary_element_flag -- Fix for Bug # 4490532.
7737: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
7738: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
7739: ,PPS.PROJECT_STATUS_NAME
7755: ,pps.status_icon_ind
7756: ,ppe.status_code
7757: ,pps2.project_status_name
7758: ,ppe.priority_code
7759: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
7760: ,ppe.carrying_out_organization_id
7761: ,hou.name
7762: ,ppe.inc_proj_progress_flag
7763: ,ppvsch.estimated_start_date
7785: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
7786: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
7787: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
7788: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
7789: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
7790: ,ppe.pm_source_code
7791: ,ppe.pm_source_reference
7792: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
7793: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
7788: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
7789: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
7790: ,ppe.pm_source_code
7791: ,ppe.pm_source_reference
7792: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
7793: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
7794: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
7795: -- Fix for Bug # 4447949.
7796: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
7789: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
7790: ,ppe.pm_source_code
7791: ,ppe.pm_source_reference
7792: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
7793: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
7794: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
7795: -- Fix for Bug # 4447949.
7796: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
7797: -- Fix for Bug # 4447949.
7790: ,ppe.pm_source_code
7791: ,ppe.pm_source_reference
7792: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
7793: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
7794: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
7795: -- Fix for Bug # 4447949.
7796: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
7797: -- Fix for Bug # 4447949.
7798: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
7794: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
7795: -- Fix for Bug # 4447949.
7796: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
7797: -- Fix for Bug # 4447949.
7798: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
7799: -- Fix for Bug # 4447949.
7800: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
7801: -- Fix for Bug # 4447949.
7802: ,papf.work_telephone
7799: -- Fix for Bug # 4447949.
7800: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
7801: -- Fix for Bug # 4447949.
7802: ,papf.work_telephone
7803: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
7804: ,pt.service_type_code
7805: ,pwt.name
7806: ,pt.work_type_id
7807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
7803: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
7804: ,pt.service_type_code
7805: ,pwt.name
7806: ,pt.work_type_id
7807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
7808: ,pt.chargeable_flag
7809: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
7810: ,pt.billable_flag
7811: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
7805: ,pwt.name
7806: ,pt.work_type_id
7807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
7808: ,pt.chargeable_flag
7809: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
7810: ,pt.billable_flag
7811: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
7812: ,pt.receive_project_invoice_flag
7813: ,pt.start_date
7807: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
7808: ,pt.chargeable_flag
7809: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
7810: ,pt.billable_flag
7811: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
7812: ,pt.receive_project_invoice_flag
7813: ,pt.start_date
7814: ,pt.completion_date
7815: ,null --PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
7817: ,to_date(NULL)
7818: ,ppa.BASELINE_AS_OF_DATE
7819: ,ppru.LAST_UPDATE_DATE
7820: ,ppru.LAST_UPDATE_DATE
7821: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
7822: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
7823: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
7824: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
7825: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
7824: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
7825: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
7826: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
7827: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
7828: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
7829: ,ppe.CREATION_DATE
7830: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
7831: ,ppe.TYPE_ID
7832: ,tt.task_type
7826: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
7827: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
7828: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
7829: ,ppe.CREATION_DATE
7830: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
7831: ,ppe.TYPE_ID
7832: ,tt.task_type
7833: ,ppe.STATUS_CODE
7834: ,pps3.PROJECT_STATUS_NAME
7836: ,pps5.project_status_name
7837: ,null --NVL(pfxat.labor_hours,0) + NVL(pfxat.equipment_hours,0)
7838: ,por.WEIGHTING_PERCENTAGE
7839: ,ppvsch.duration
7840: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
7841: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
7842: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
7843: ,pt.address_id
7844: ,addr.address1
7837: ,null --NVL(pfxat.labor_hours,0) + NVL(pfxat.equipment_hours,0)
7838: ,por.WEIGHTING_PERCENTAGE
7839: ,ppvsch.duration
7840: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
7841: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
7842: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
7843: ,pt.address_id
7844: ,addr.address1
7845: ,addr.address2
7838: ,por.WEIGHTING_PERCENTAGE
7839: ,ppvsch.duration
7840: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
7841: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
7842: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
7843: ,pt.address_id
7844: ,addr.address1
7845: ,addr.address2
7846: ,addr.address3
7845: ,addr.address2
7846: ,addr.address3
7847: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
7848: ,ppe.wq_item_code
7849: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
7850: ,ppe.wq_uom_code
7851: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
7852: ,ppvsch.wq_planned_quantity
7853: ,ppe.wq_actual_entry_code
7847: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
7848: ,ppe.wq_item_code
7849: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
7850: ,ppe.wq_uom_code
7851: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
7852: ,ppvsch.wq_planned_quantity
7853: ,ppe.wq_actual_entry_code
7854: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
7855: ,tt.prog_entry_enable_flag
7850: ,ppe.wq_uom_code
7851: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
7852: ,ppvsch.wq_planned_quantity
7853: ,ppe.wq_actual_entry_code
7854: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
7855: ,tt.prog_entry_enable_flag
7856: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
7857: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
7858: ,ppe.task_progress_entry_page_id
7857: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
7858: ,ppe.task_progress_entry_page_id
7859: ,ppl.page_name
7860: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
7861: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE', NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
7862: ,tt.wq_enable_flag
7863: ,tt.prog_entry_req_flag
7864: ,null --pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7865: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
7892: ,ppwa.lifecycle_version_id
7893: ,ppv.TASK_UNPUB_VER_STATUS_CODE
7894: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
7895: ,to_number(null)
7896: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7897: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7898: ,ppeph.name
7899: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
7900: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7920: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
7921: ) Percent_Complete_Cost
7922: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
7923: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
7924: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
7925: ,ppvsch.constraint_type_code
7926: ,ppvsch.Constraint_Date
7927: ,ppvsch.Early_Start_Date
7928: ,ppvsch.Early_Finish_Date
7930: ,ppvsch.Late_Finish_Date
7931: ,ppvsch.Free_Slack
7932: ,ppvsch.Total_Slack
7933: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
7934: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
7935: Lowest_Task -- Fix for Bug # 4490532.
7936: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
7937: /* Bug Fix 5466645
7938: -- ,to_number ( null ) Estimated_Baseline_Start
8031: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8032: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8033: ,null --PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8034: ,pt.gen_etc_source_code
8035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
8036: ,ppe.wf_item_type
8037: ,ppe.wf_process
8038: ,ppe.wf_start_lead_days
8039: ,ppe.enable_wf_flag
8482: ,ppe.proj_element_id
8483: ,ppa.project_id
8484: ,ppv.display_sequence
8485: ,ppvsch.milestone_flag
8486: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
8487: ,ppvsch.critical_flag
8488: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
8489: ,por.object_id_from1
8490: ,por.object_type_from
8484: ,ppv.display_sequence
8485: ,ppvsch.milestone_flag
8486: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.milestone_flag, 'N' ))
8487: ,ppvsch.critical_flag
8488: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', NVL( ppvsch.critical_flag, 'N' ))
8489: ,por.object_id_from1
8490: ,por.object_type_from
8491: ,por.relationship_type
8492: ,por.relationship_subtype
8491: ,por.relationship_type
8492: ,por.relationship_subtype
8493: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
8494: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
8495: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
8496: summary_element_flag -- Fix for Bug # 4490532.
8497: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
8498: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
8499: ,PPS.PROJECT_STATUS_NAME
8515: ,pps.status_icon_ind
8516: ,ppe.status_code
8517: ,pps2.project_status_name
8518: ,ppe.priority_code
8519: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_PRIORITY_CODE' ,ppe.priority_code)
8520: ,ppe.carrying_out_organization_id
8521: ,hou.name
8522: ,ppe.inc_proj_progress_flag
8523: ,ppvsch.estimated_start_date
8545: ,ppvsch.estimated_start_date - ppvsch.scheduled_start_date
8546: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
8547: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
8548: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
8549: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
8550: ,ppe.pm_source_code
8551: ,ppe.pm_source_reference
8552: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
8553: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
8548: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
8549: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
8550: ,ppe.pm_source_code
8551: ,ppe.pm_source_reference
8552: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
8553: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
8554: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
8555: -- Fix for Bug # 4447949.
8556: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
8549: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
8550: ,ppe.pm_source_code
8551: ,ppe.pm_source_reference
8552: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
8553: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
8554: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
8555: -- Fix for Bug # 4447949.
8556: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
8557: -- Fix for Bug # 4447949.
8550: ,ppe.pm_source_code
8551: ,ppe.pm_source_reference
8552: ,PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
8553: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO', PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
8554: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
8555: -- Fix for Bug # 4447949.
8556: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
8557: -- Fix for Bug # 4447949.
8558: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
8554: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
8555: -- Fix for Bug # 4447949.
8556: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_start_date) - trunc(sysdate)))
8557: -- Fix for Bug # 4447949.
8558: -- ,PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
8559: -- Fix for Bug # 4447949.
8560: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
8561: -- Fix for Bug # 4447949.
8562: ,papf.work_telephone
8559: -- Fix for Bug # 4447949.
8560: , decode(ppv.object_type, 'PA_STRUCTURES', null, (trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)))
8561: -- Fix for Bug # 4447949.
8562: ,papf.work_telephone
8563: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
8564: ,pt.service_type_code
8565: ,pwt.name
8566: ,pt.work_type_id
8567: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
8563: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
8564: ,pt.service_type_code
8565: ,pwt.name
8566: ,pt.work_type_id
8567: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
8568: ,pt.chargeable_flag
8569: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
8570: ,pt.billable_flag
8571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
8565: ,pwt.name
8566: ,pt.work_type_id
8567: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
8568: ,pt.chargeable_flag
8569: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
8570: ,pt.billable_flag
8571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
8572: ,pt.receive_project_invoice_flag
8573: ,pt.start_date
8567: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
8568: ,pt.chargeable_flag
8569: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
8570: ,pt.billable_flag
8571: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
8572: ,pt.receive_project_invoice_flag
8573: ,pt.start_date
8574: ,pt.completion_date
8575: ,null --PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
8577: ,to_date(NULL)
8578: ,ppa.BASELINE_AS_OF_DATE
8579: ,ppru.LAST_UPDATE_DATE
8580: ,ppru.LAST_UPDATE_DATE
8581: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
8582: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
8583: ,trunc(ppvsch.estimated_start_date) - trunc(sysdate)
8584: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
8585: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
8584: ,trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
8585: ,trunc(sysdate) - trunc(ppvsch.actual_start_date)
8586: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
8587: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
8588: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
8589: ,ppe.CREATION_DATE
8590: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
8591: ,ppe.TYPE_ID
8592: ,tt.task_type
8586: ,trunc(sysdate) - trunc(ppvsch.actual_finish_date)
8587: ,decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
8588: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
8589: ,ppe.CREATION_DATE
8590: ,PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
8591: ,ppe.TYPE_ID
8592: ,tt.task_type
8593: ,ppe.STATUS_CODE
8594: ,pps3.PROJECT_STATUS_NAME
8596: ,pps5.project_status_name
8597: ,null --NVL(pfxat.labor_hours,0) + NVL(pfxat.equipment_hours,0)
8598: ,por.WEIGHTING_PERCENTAGE
8599: ,ppvsch.duration
8600: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
8601: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
8602: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
8603: ,pt.address_id
8604: ,addr.address1
8597: ,null --NVL(pfxat.labor_hours,0) + NVL(pfxat.equipment_hours,0)
8598: ,por.WEIGHTING_PERCENTAGE
8599: ,ppvsch.duration
8600: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
8601: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
8602: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
8603: ,pt.address_id
8604: ,addr.address1
8605: ,addr.address2
8598: ,por.WEIGHTING_PERCENTAGE
8599: ,ppvsch.duration
8600: ,pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
8601: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
8602: ,pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
8603: ,pt.address_id
8604: ,addr.address1
8605: ,addr.address2
8606: ,addr.address3
8605: ,addr.address2
8606: ,addr.address3
8607: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
8608: ,ppe.wq_item_code
8609: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
8610: ,ppe.wq_uom_code
8611: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
8612: ,ppvsch.wq_planned_quantity
8613: ,ppe.wq_actual_entry_code
8607: ,addr.address4|| decode(addr.address4,null,null,', ')|| addr.city||', '||nvl(addr.state,addr.province)||', ' ||addr.county
8608: ,ppe.wq_item_code
8609: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
8610: ,ppe.wq_uom_code
8611: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
8612: ,ppvsch.wq_planned_quantity
8613: ,ppe.wq_actual_entry_code
8614: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
8615: ,tt.prog_entry_enable_flag
8610: ,ppe.wq_uom_code
8611: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
8612: ,ppvsch.wq_planned_quantity
8613: ,ppe.wq_actual_entry_code
8614: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
8615: ,tt.prog_entry_enable_flag
8616: ,decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', tt.PERCENT_COMP_ENABLE_FLAG, 'N')
8617: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
8618: ,ppe.task_progress_entry_page_id
8617: ,decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', tt.REMAIN_EFFORT_ENABLE_FLAG, 'N')
8618: ,ppe.task_progress_entry_page_id
8619: ,ppl.page_name
8620: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
8621: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
8622: ,tt.wq_enable_flag
8623: ,tt.prog_entry_req_flag
8624: ,null --PA_PROGRESS_UTILS.derive_etc_values((NVL(pfxat.labor_hours,0)+NVL(pfxat.equipment_hours,0))
8625: -- ,ppru.ppl_act_effort_to_date
8651: ,ppwa.lifecycle_version_id
8652: ,ppv.TASK_UNPUB_VER_STATUS_CODE
8653: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
8654: ,to_number(null)
8655: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
8656: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8657: ,ppeph.name
8658: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8659: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8679: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
8680: ) Percent_Complete_Cost
8681: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
8682: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
8683: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
8684: ,ppvsch.constraint_type_code
8685: ,ppvsch.Constraint_Date
8686: ,ppvsch.Early_Start_Date
8687: ,ppvsch.Early_Finish_Date
8689: ,ppvsch.Late_Finish_Date
8690: ,ppvsch.Free_Slack
8691: ,ppvsch.Total_Slack
8692: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
8693: ,DECODE(PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id),'Y','N','N','Y')
8694: Lowest_Task -- Fix for Bug # 4490532.
8695: -- , 'N') Lowest_Task -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
8696: /* Bug Fix 5466645
8697: -- ,to_number ( null ) Estimated_Baseline_Start
8791: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8792: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8793: ,to_char(null)--PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8794: ,pt.gen_etc_source_code
8795: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
8796: ,ppe.wf_item_type
8797: ,ppe.wf_process
8798: ,ppe.wf_start_lead_days
8799: ,ppe.enable_wf_flag
9024:
9025: -- End of Fix 5611760.
9026:
9027: -- Bug Fix 5611634
9028: l_check_edit_task_ok := PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(p_project_id, p_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId);
9029: -- End of Fix for bug 5611634.
9030:
9031:
9032: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
9294: ,por.relationship_type
9295: ,por.relationship_subtype
9296: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
9297: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
9298: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
9299: summary_element_flag -- Fix for Bug # 4490532.
9300: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
9301: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
9302: ,PPS.PROJECT_STATUS_NAME
9350: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
9351: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
9352: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
9353: ---------------------------------------------
9354: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
9355: ,null -- not populating as not needed in VO ppe.pm_source_code
9356: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
9357: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
9358: ,null
9353: ---------------------------------------------
9354: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
9355: ,null -- not populating as not needed in VO ppe.pm_source_code
9356: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
9357: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
9358: ,null
9359: /* not populating as not needed in VO
9360: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
9361: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
9356: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
9357: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
9358: ,null
9359: /* not populating as not needed in VO
9360: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
9361: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
9362: */
9363: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
9364: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
9357: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
9358: ,null
9359: /* not populating as not needed in VO
9360: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
9361: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
9362: */
9363: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
9364: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
9365: ,papf.work_telephone
9359: /* not populating as not needed in VO
9360: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
9361: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
9362: */
9363: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
9364: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
9365: ,papf.work_telephone
9366: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
9367: ,pt.service_type_code
9360: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
9361: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
9362: */
9363: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
9364: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
9365: ,papf.work_telephone
9366: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
9367: ,pt.service_type_code
9368: ,pwt.name
9362: */
9363: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
9364: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
9365: ,papf.work_telephone
9366: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
9367: ,pt.service_type_code
9368: ,pwt.name
9369: ,pt.work_type_id
9370: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
9366: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
9367: ,pt.service_type_code
9368: ,pwt.name
9369: ,pt.work_type_id
9370: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
9371: ,pt.chargeable_flag
9372: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
9373: ,pt.billable_flag
9374: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
9368: ,pwt.name
9369: ,pt.work_type_id
9370: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
9371: ,pt.chargeable_flag
9372: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
9373: ,pt.billable_flag
9374: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
9375: ,pt.receive_project_invoice_flag
9376: ,pt.start_date
9370: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
9371: ,pt.chargeable_flag
9372: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
9373: ,pt.billable_flag
9374: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
9375: ,pt.receive_project_invoice_flag
9376: ,pt.start_date
9377: ,pt.completion_date
9378: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
9380: ,to_date(NULL) -- not needed in VO
9381: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
9382: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
9383: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
9384: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
9385: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
9386: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
9387: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
9388: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
9388: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
9389: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
9390: ----------------------------------------------------------
9391: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
9392: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
9393: ,null -- not needed in VO ppe.CREATION_DATE
9394: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
9395: ,ppe.TYPE_ID
9396: ,tt.task_type
9390: ----------------------------------------------------------
9391: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
9392: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
9393: ,null -- not needed in VO ppe.CREATION_DATE
9394: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
9395: ,ppe.TYPE_ID
9396: ,tt.task_type
9397: ,ppe.STATUS_CODE
9398: ,null -- Populating Task Status Name as NULL
9401: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
9402: -- Fix for Bug # 4319171.
9403: ,por.WEIGHTING_PERCENTAGE
9404: ,null -- not needed in VO ppvsch.duration
9405: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
9406: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
9407: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
9408: --------------------------------------------------------------------------------
9409: ,pt.address_id
9402: -- Fix for Bug # 4319171.
9403: ,por.WEIGHTING_PERCENTAGE
9404: ,null -- not needed in VO ppvsch.duration
9405: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
9406: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
9407: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
9408: --------------------------------------------------------------------------------
9409: ,pt.address_id
9410: ,null--addr.address1
9403: ,por.WEIGHTING_PERCENTAGE
9404: ,null -- not needed in VO ppvsch.duration
9405: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
9406: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
9407: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
9408: --------------------------------------------------------------------------------
9409: ,pt.address_id
9410: ,null--addr.address1
9411: ,null--addr.address2
9411: ,null--addr.address2
9412: ,null--addr.address3
9413: ,null
9414: ,ppe.wq_item_code
9415: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
9416: ,ppe.wq_uom_code
9417: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
9418: ,ppvsch.wq_planned_quantity
9419: ,ppe.wq_actual_entry_code
9413: ,null
9414: ,ppe.wq_item_code
9415: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
9416: ,ppe.wq_uom_code
9417: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
9418: ,ppvsch.wq_planned_quantity
9419: ,ppe.wq_actual_entry_code
9420: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
9421: ,tt.prog_entry_enable_flag
9416: ,ppe.wq_uom_code
9417: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
9418: ,ppvsch.wq_planned_quantity
9419: ,ppe.wq_actual_entry_code
9420: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
9421: ,tt.prog_entry_enable_flag
9422: , tt.PERCENT_COMP_ENABLE_FLAG
9423: , tt.REMAIN_EFFORT_ENABLE_FLAG
9424: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
9424: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
9425: ,null -- not needed in VO page_name
9426: --------------------------------------------------------------
9427: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
9428: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
9429: ,tt.wq_enable_flag
9430: ,tt.prog_entry_req_flag
9431: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
9432: , ppru.estimated_remaining_effort
9464: ,to_number(null) -- lifecycle version id
9465: ,ppv.TASK_UNPUB_VER_STATUS_CODE
9466: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
9467: ,to_number(null)
9468: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
9469: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9470: ,null --current phase name
9471: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
9472: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
9534: -- End Bug # 4546322.
9535: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
9536: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
9537: -----------------------------------------------------------------------------------
9538: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
9539: ,ppvsch.constraint_type_code
9540: ,ppvsch.Constraint_Date
9541: ,ppvsch.Early_Start_Date
9542: ,ppvsch.Early_Finish_Date
9730: ---------------------------------------------------------------------
9731: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
9732: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
9733: ,null -- not used in VO pt.gen_etc_source_code
9734: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
9735: ,ppe.wf_item_type
9736: ,ppe.wf_process
9737: ,ppe.wf_start_lead_days
9738: ,ppe.enable_wf_flag
9753: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
9754: -- Fix for Bug # 4319171.
9755: ,ppru.PROGRESS_ROLLUP_ID
9756: -- Bug Fix 5611634.
9757: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
9758: ,l_check_edit_task_ok
9759: -- End of Bug Fix 5611634.
9760: ,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 -- Added for bug 5090355
9761: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
10121: ,por.relationship_type
10122: ,por.relationship_subtype
10123: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10124: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
10125: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10126: summary_element_flag -- Fix for Bug # 4490532.
10127: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10128: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
10129: ,PPS.PROJECT_STATUS_NAME
10177: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
10178: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
10179: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
10180: ---------------------------------------------
10181: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
10182: ,null -- not populating as not needed in VO ppe.pm_source_code
10183: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
10184: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
10185: ,null
10180: ---------------------------------------------
10181: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
10182: ,null -- not populating as not needed in VO ppe.pm_source_code
10183: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
10184: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
10185: ,null
10186: /* not populating as not needed in VO
10187: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
10188: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
10183: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
10184: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
10185: ,null
10186: /* not populating as not needed in VO
10187: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
10188: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
10189: */
10190: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
10191: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
10184: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
10185: ,null
10186: /* not populating as not needed in VO
10187: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
10188: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
10189: */
10190: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
10191: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
10192: ,papf.work_telephone
10186: /* not populating as not needed in VO
10187: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
10188: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
10189: */
10190: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
10191: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
10192: ,papf.work_telephone
10193: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
10194: ,pt.service_type_code
10187: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
10188: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
10189: */
10190: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
10191: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
10192: ,papf.work_telephone
10193: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
10194: ,pt.service_type_code
10195: ,pwt.name
10189: */
10190: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
10191: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
10192: ,papf.work_telephone
10193: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
10194: ,pt.service_type_code
10195: ,pwt.name
10196: ,pt.work_type_id
10197: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
10193: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
10194: ,pt.service_type_code
10195: ,pwt.name
10196: ,pt.work_type_id
10197: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
10198: ,pt.chargeable_flag
10199: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
10200: ,pt.billable_flag
10201: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
10195: ,pwt.name
10196: ,pt.work_type_id
10197: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
10198: ,pt.chargeable_flag
10199: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
10200: ,pt.billable_flag
10201: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
10202: ,pt.receive_project_invoice_flag
10203: ,pt.start_date
10197: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
10198: ,pt.chargeable_flag
10199: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
10200: ,pt.billable_flag
10201: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
10202: ,pt.receive_project_invoice_flag
10203: ,pt.start_date
10204: ,pt.completion_date
10205: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
10207: ,to_date(NULL) -- not needed in VO
10208: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
10209: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
10210: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
10211: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
10212: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
10213: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
10214: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
10215: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
10215: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
10216: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
10217: ----------------------------------------------------------
10218: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
10219: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
10220: ,null -- not needed in VO ppe.CREATION_DATE
10221: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
10222: ,ppe.TYPE_ID
10223: ,tt.task_type
10217: ----------------------------------------------------------
10218: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
10219: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
10220: ,null -- not needed in VO ppe.CREATION_DATE
10221: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
10222: ,ppe.TYPE_ID
10223: ,tt.task_type
10224: ,ppe.STATUS_CODE
10225: ,null -- Populating Task Status Name as NULL
10228: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
10229: -- Fix for Bug # 4319171.
10230: ,por.WEIGHTING_PERCENTAGE
10231: ,null -- not needed in VO ppvsch.duration
10232: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
10233: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
10234: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
10235: --------------------------------------------------------------------------------
10236: ,pt.address_id
10229: -- Fix for Bug # 4319171.
10230: ,por.WEIGHTING_PERCENTAGE
10231: ,null -- not needed in VO ppvsch.duration
10232: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
10233: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
10234: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
10235: --------------------------------------------------------------------------------
10236: ,pt.address_id
10237: ,null--addr.address1
10230: ,por.WEIGHTING_PERCENTAGE
10231: ,null -- not needed in VO ppvsch.duration
10232: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
10233: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
10234: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
10235: --------------------------------------------------------------------------------
10236: ,pt.address_id
10237: ,null--addr.address1
10238: ,null--addr.address2
10238: ,null--addr.address2
10239: ,null--addr.address3
10240: ,null
10241: ,ppe.wq_item_code
10242: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
10243: ,ppe.wq_uom_code
10244: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
10245: ,ppvsch.wq_planned_quantity
10246: ,ppe.wq_actual_entry_code
10240: ,null
10241: ,ppe.wq_item_code
10242: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
10243: ,ppe.wq_uom_code
10244: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
10245: ,ppvsch.wq_planned_quantity
10246: ,ppe.wq_actual_entry_code
10247: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
10248: ,tt.prog_entry_enable_flag
10243: ,ppe.wq_uom_code
10244: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
10245: ,ppvsch.wq_planned_quantity
10246: ,ppe.wq_actual_entry_code
10247: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
10248: ,tt.prog_entry_enable_flag
10249: , tt.PERCENT_COMP_ENABLE_FLAG
10250: , tt.REMAIN_EFFORT_ENABLE_FLAG
10251: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
10251: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
10252: ,null -- not needed in VO page_name
10253: --------------------------------------------------------------
10254: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
10255: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
10256: ,tt.wq_enable_flag
10257: ,tt.prog_entry_req_flag
10258: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
10259: , ppru.estimated_remaining_effort
10291: ,to_number(null) -- lifecycle version id
10292: ,ppv.TASK_UNPUB_VER_STATUS_CODE
10293: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
10294: ,to_number(null)
10295: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10296: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10297: ,null --current phase name
10298: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10299: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10361: -- End Bug # 4546322.
10362: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
10363: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
10364: -----------------------------------------------------------------------------------
10365: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
10366: ,ppvsch.constraint_type_code
10367: ,ppvsch.Constraint_Date
10368: ,ppvsch.Early_Start_Date
10369: ,ppvsch.Early_Finish_Date
10557: ---------------------------------------------------------------------
10558: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
10559: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
10560: ,null -- not used in VO pt.gen_etc_source_code
10561: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
10562: ,ppe.wf_item_type
10563: ,ppe.wf_process
10564: ,ppe.wf_start_lead_days
10565: ,ppe.enable_wf_flag
10580: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
10581: -- Fix for Bug # 4319171.
10582: ,ppru.PROGRESS_ROLLUP_ID
10583: -- Bug Fix 5611634.
10584: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
10585: ,l_check_edit_task_ok
10586: -- End of Bug Fix 5611634.
10587: ,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 -- Added for bug 5090355
10588: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
10949: ,por.relationship_type
10950: ,por.relationship_subtype
10951: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10952: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
10953: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10954: summary_element_flag -- Fix for Bug # 4490532.
10955: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10956: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
10957: ,PPS.PROJECT_STATUS_NAME
11005: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
11006: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
11007: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
11008: ---------------------------------------------
11009: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
11010: ,null -- not populating as not needed in VO ppe.pm_source_code
11011: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11012: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11013: ,null
11008: ---------------------------------------------
11009: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
11010: ,null -- not populating as not needed in VO ppe.pm_source_code
11011: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11012: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11013: ,null
11014: /* not populating as not needed in VO
11015: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11016: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11011: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11012: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11013: ,null
11014: /* not populating as not needed in VO
11015: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11016: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11017: */
11018: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11019: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11012: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11013: ,null
11014: /* not populating as not needed in VO
11015: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11016: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11017: */
11018: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11019: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11020: ,papf.work_telephone
11014: /* not populating as not needed in VO
11015: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11016: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11017: */
11018: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11019: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11020: ,papf.work_telephone
11021: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11022: ,pt.service_type_code
11015: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11016: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11017: */
11018: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11019: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11020: ,papf.work_telephone
11021: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11022: ,pt.service_type_code
11023: ,pwt.name
11017: */
11018: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11019: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11020: ,papf.work_telephone
11021: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11022: ,pt.service_type_code
11023: ,pwt.name
11024: ,pt.work_type_id
11025: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11021: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11022: ,pt.service_type_code
11023: ,pwt.name
11024: ,pt.work_type_id
11025: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11026: ,pt.chargeable_flag
11027: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11028: ,pt.billable_flag
11029: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11023: ,pwt.name
11024: ,pt.work_type_id
11025: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11026: ,pt.chargeable_flag
11027: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11028: ,pt.billable_flag
11029: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11030: ,pt.receive_project_invoice_flag
11031: ,pt.start_date
11025: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11026: ,pt.chargeable_flag
11027: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11028: ,pt.billable_flag
11029: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11030: ,pt.receive_project_invoice_flag
11031: ,pt.start_date
11032: ,pt.completion_date
11033: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
11035: ,to_date(NULL) -- not needed in VO
11036: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
11037: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
11038: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
11039: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
11040: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
11041: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
11042: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
11043: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
11043: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
11044: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
11045: ----------------------------------------------------------
11046: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
11047: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
11048: ,null -- not needed in VO ppe.CREATION_DATE
11049: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
11050: ,ppe.TYPE_ID
11051: ,tt.task_type
11045: ----------------------------------------------------------
11046: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
11047: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
11048: ,null -- not needed in VO ppe.CREATION_DATE
11049: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
11050: ,ppe.TYPE_ID
11051: ,tt.task_type
11052: ,ppe.STATUS_CODE
11053: ,null -- Populating Task Status Name as NULL
11056: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
11057: -- Fix for Bug # 4319171.
11058: ,por.WEIGHTING_PERCENTAGE
11059: ,null -- not needed in VO ppvsch.duration
11060: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
11061: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
11062: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
11063: --------------------------------------------------------------------------------
11064: ,pt.address_id
11057: -- Fix for Bug # 4319171.
11058: ,por.WEIGHTING_PERCENTAGE
11059: ,null -- not needed in VO ppvsch.duration
11060: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
11061: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
11062: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
11063: --------------------------------------------------------------------------------
11064: ,pt.address_id
11065: ,null--addr.address1
11058: ,por.WEIGHTING_PERCENTAGE
11059: ,null -- not needed in VO ppvsch.duration
11060: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
11061: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
11062: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
11063: --------------------------------------------------------------------------------
11064: ,pt.address_id
11065: ,null--addr.address1
11066: ,null--addr.address2
11066: ,null--addr.address2
11067: ,null--addr.address3
11068: ,null
11069: ,ppe.wq_item_code
11070: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
11071: ,ppe.wq_uom_code
11072: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
11073: ,ppvsch.wq_planned_quantity
11074: ,ppe.wq_actual_entry_code
11068: ,null
11069: ,ppe.wq_item_code
11070: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
11071: ,ppe.wq_uom_code
11072: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
11073: ,ppvsch.wq_planned_quantity
11074: ,ppe.wq_actual_entry_code
11075: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
11076: ,tt.prog_entry_enable_flag
11071: ,ppe.wq_uom_code
11072: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
11073: ,ppvsch.wq_planned_quantity
11074: ,ppe.wq_actual_entry_code
11075: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
11076: ,tt.prog_entry_enable_flag
11077: , tt.PERCENT_COMP_ENABLE_FLAG
11078: , tt.REMAIN_EFFORT_ENABLE_FLAG
11079: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
11079: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
11080: ,null -- not needed in VO page_name
11081: --------------------------------------------------------------
11082: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
11083: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
11084: ,tt.wq_enable_flag
11085: ,tt.prog_entry_req_flag
11086: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
11087: , ppru.estimated_remaining_effort
11119: ,to_number(null) -- lifecycle version id
11120: ,ppv.TASK_UNPUB_VER_STATUS_CODE
11121: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
11122: ,to_number(null)
11123: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11124: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11125: ,null --current phase name
11126: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
11127: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
11189: -- End Bug # 4546322.
11190: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
11191: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
11192: -----------------------------------------------------------------------------------
11193: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
11194: ,ppvsch.constraint_type_code
11195: ,ppvsch.Constraint_Date
11196: ,ppvsch.Early_Start_Date
11197: ,ppvsch.Early_Finish_Date
11385: ---------------------------------------------------------------------
11386: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
11387: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
11388: ,null -- not used in VO pt.gen_etc_source_code
11389: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
11390: ,ppe.wf_item_type
11391: ,ppe.wf_process
11392: ,ppe.wf_start_lead_days
11393: ,ppe.enable_wf_flag
11408: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
11409: -- Fix for Bug # 4319171.
11410: ,ppru.PROGRESS_ROLLUP_ID
11411: -- Bug Fix 5611634.
11412: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
11413: ,l_check_edit_task_ok
11414: -- End of Bug Fix 5611634.
11415: ,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 -- Added for bug 5090355
11416: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
11638:
11639: -- End of Fix 5611760.
11640:
11641: -- Bug Fix 5611634
11642: l_check_edit_task_ok := PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(p_project_id, p_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId);
11643: -- End of Fix for bug 5611634.
11644:
11645:
11646: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
11912: ,por.relationship_type
11913: ,por.relationship_subtype
11914: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
11915: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
11916: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
11917: summary_element_flag -- Fix for Bug # 4490532.
11918: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
11919: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
11920: ,PPS.PROJECT_STATUS_NAME
11968: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
11969: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
11970: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
11971: --------------------------------------------- 2
11972: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
11973: ,null -- not populating as not needed in VO ppe.pm_source_code
11974: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11975: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11976: ,null
11971: --------------------------------------------- 2
11972: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
11973: ,null -- not populating as not needed in VO ppe.pm_source_code
11974: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11975: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11976: ,null
11977: /* not populating as not needed in VO
11978: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11979: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11974: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
11975: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11976: ,null
11977: /* not populating as not needed in VO
11978: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11979: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11980: */
11981: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11982: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11975: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
11976: ,null
11977: /* not populating as not needed in VO
11978: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11979: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11980: */
11981: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11982: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11983: ,papf.work_telephone
11977: /* not populating as not needed in VO
11978: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11979: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11980: */
11981: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11982: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11983: ,papf.work_telephone
11984: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11985: ,pt.service_type_code
11978: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
11979: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
11980: */
11981: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11982: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11983: ,papf.work_telephone
11984: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11985: ,pt.service_type_code
11986: ,pwt.name
11980: */
11981: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
11982: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
11983: ,papf.work_telephone
11984: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11985: ,pt.service_type_code
11986: ,pwt.name
11987: ,pt.work_type_id
11988: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11984: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
11985: ,pt.service_type_code
11986: ,pwt.name
11987: ,pt.work_type_id
11988: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11989: ,pt.chargeable_flag
11990: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11991: ,pt.billable_flag
11992: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11986: ,pwt.name
11987: ,pt.work_type_id
11988: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11989: ,pt.chargeable_flag
11990: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11991: ,pt.billable_flag
11992: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11993: ,pt.receive_project_invoice_flag
11994: ,pt.start_date
11988: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
11989: ,pt.chargeable_flag
11990: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
11991: ,pt.billable_flag
11992: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
11993: ,pt.receive_project_invoice_flag
11994: ,pt.start_date
11995: ,pt.completion_date
11996: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
11998: ,to_date(NULL) -- not needed in VO
11999: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
12000: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
12001: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
12002: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
12003: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
12004: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
12005: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
12006: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
12006: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
12007: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
12008: ---------------------------------------------- 3
12009: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
12010: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
12011: ,null -- not needed in VO ppe.CREATION_DATE
12012: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
12013: ,ppe.TYPE_ID
12014: ,tt.task_type
12008: ---------------------------------------------- 3
12009: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
12010: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
12011: ,null -- not needed in VO ppe.CREATION_DATE
12012: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
12013: ,ppe.TYPE_ID
12014: ,tt.task_type
12015: ,ppe.STATUS_CODE
12016: ,null -- Populating Task Status Name as NULL
12019: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
12020: -- Fix for Bug # 4319171.
12021: ,por.WEIGHTING_PERCENTAGE
12022: ,null -- not needed in VO ppvsch.duration
12023: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12024: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12025: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12026: --------------------------------------------------------------------------------
12027: ,pt.address_id
12020: -- Fix for Bug # 4319171.
12021: ,por.WEIGHTING_PERCENTAGE
12022: ,null -- not needed in VO ppvsch.duration
12023: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12024: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12025: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12026: --------------------------------------------------------------------------------
12027: ,pt.address_id
12028: ,null--addr.address1
12021: ,por.WEIGHTING_PERCENTAGE
12022: ,null -- not needed in VO ppvsch.duration
12023: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12024: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12025: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12026: --------------------------------------------------------------------------------
12027: ,pt.address_id
12028: ,null--addr.address1
12029: ,null--addr.address2
12029: ,null--addr.address2
12030: ,null--addr.address3
12031: ,null
12032: ,ppe.wq_item_code
12033: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
12034: ,ppe.wq_uom_code
12035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12036: ,ppvsch.wq_planned_quantity
12037: ,ppe.wq_actual_entry_code
12031: ,null
12032: ,ppe.wq_item_code
12033: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
12034: ,ppe.wq_uom_code
12035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12036: ,ppvsch.wq_planned_quantity
12037: ,ppe.wq_actual_entry_code
12038: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
12039: ,tt.prog_entry_enable_flag
12034: ,ppe.wq_uom_code
12035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12036: ,ppvsch.wq_planned_quantity
12037: ,ppe.wq_actual_entry_code
12038: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
12039: ,tt.prog_entry_enable_flag
12040: , tt.PERCENT_COMP_ENABLE_FLAG
12041: , tt.REMAIN_EFFORT_ENABLE_FLAG
12042: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
12042: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
12043: ,null -- not needed in VO page_name
12044: ------------------------------------------------ 5
12045: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
12046: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
12047: ,tt.wq_enable_flag
12048: ,tt.prog_entry_req_flag
12049: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12050: , ppru.estimated_remaining_effort
12082: ,to_number(null) -- lifecycle version id
12083: ,ppv.TASK_UNPUB_VER_STATUS_CODE
12084: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
12085: ,to_number(null)
12086: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12087: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12088: ,null --current phase name
12089: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12090: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12113: ) Percent_Complete_Cost
12114: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
12115: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
12116: ----------------------------------------------------------------- 7
12117: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
12118: ,ppvsch.constraint_type_code
12119: ,ppvsch.Constraint_Date
12120: ,ppvsch.Early_Start_Date
12121: ,ppvsch.Early_Finish_Date
12309: ---------------------------------------------------------------------
12310: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
12311: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
12312: ,null -- not used in VO pt.gen_etc_source_code
12313: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
12314: ,ppe.wf_item_type
12315: ,ppe.wf_process
12316: ,ppe.wf_start_lead_days
12317: ,ppe.enable_wf_flag
12332: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
12333: -- Fix for Bug # 4319171.
12334: ,ppru.PROGRESS_ROLLUP_ID
12335: -- Bug Fix 5611634.
12336: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
12337: ,l_check_edit_task_ok
12338: -- End of Bug Fix 5611634.
12339: ,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 -- Added for bug 5090355
12340: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12708: ,por.relationship_type
12709: ,por.relationship_subtype
12710: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
12711: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
12712: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
12713: summary_element_flag -- Fix for Bug # 4490532.
12714: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
12715: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
12716: ,PPS.PROJECT_STATUS_NAME
12764: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
12765: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
12766: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
12767: --------------------------------------------- 2
12768: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
12769: ,null -- not populating as not needed in VO ppe.pm_source_code
12770: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
12771: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
12772: ,null
12767: --------------------------------------------- 2
12768: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
12769: ,null -- not populating as not needed in VO ppe.pm_source_code
12770: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
12771: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
12772: ,null
12773: /* not populating as not needed in VO
12774: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
12775: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
12770: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
12771: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
12772: ,null
12773: /* not populating as not needed in VO
12774: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
12775: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
12776: */
12777: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
12778: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
12771: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
12772: ,null
12773: /* not populating as not needed in VO
12774: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
12775: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
12776: */
12777: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
12778: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
12779: ,papf.work_telephone
12773: /* not populating as not needed in VO
12774: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
12775: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
12776: */
12777: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
12778: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
12779: ,papf.work_telephone
12780: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
12781: ,pt.service_type_code
12774: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
12775: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
12776: */
12777: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
12778: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
12779: ,papf.work_telephone
12780: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
12781: ,pt.service_type_code
12782: ,pwt.name
12776: */
12777: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
12778: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
12779: ,papf.work_telephone
12780: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
12781: ,pt.service_type_code
12782: ,pwt.name
12783: ,pt.work_type_id
12784: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
12780: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
12781: ,pt.service_type_code
12782: ,pwt.name
12783: ,pt.work_type_id
12784: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
12785: ,pt.chargeable_flag
12786: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
12787: ,pt.billable_flag
12788: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
12782: ,pwt.name
12783: ,pt.work_type_id
12784: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
12785: ,pt.chargeable_flag
12786: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
12787: ,pt.billable_flag
12788: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
12789: ,pt.receive_project_invoice_flag
12790: ,pt.start_date
12784: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
12785: ,pt.chargeable_flag
12786: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
12787: ,pt.billable_flag
12788: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
12789: ,pt.receive_project_invoice_flag
12790: ,pt.start_date
12791: ,pt.completion_date
12792: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
12794: ,to_date(NULL) -- not needed in VO
12795: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
12796: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
12797: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
12798: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
12799: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
12800: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
12801: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
12802: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
12802: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
12803: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
12804: ---------------------------------------------- 3
12805: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
12806: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
12807: ,null -- not needed in VO ppe.CREATION_DATE
12808: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
12809: ,ppe.TYPE_ID
12810: ,tt.task_type
12804: ---------------------------------------------- 3
12805: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
12806: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
12807: ,null -- not needed in VO ppe.CREATION_DATE
12808: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
12809: ,ppe.TYPE_ID
12810: ,tt.task_type
12811: ,ppe.STATUS_CODE
12812: ,null -- Populating Task Status Name as NULL
12815: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
12816: -- Fix for Bug # 4319171.
12817: ,por.WEIGHTING_PERCENTAGE
12818: ,null -- not needed in VO ppvsch.duration
12819: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12820: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12821: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12822: --------------------------------------------------------------------------------
12823: ,pt.address_id
12816: -- Fix for Bug # 4319171.
12817: ,por.WEIGHTING_PERCENTAGE
12818: ,null -- not needed in VO ppvsch.duration
12819: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12820: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12821: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12822: --------------------------------------------------------------------------------
12823: ,pt.address_id
12824: ,null--addr.address1
12817: ,por.WEIGHTING_PERCENTAGE
12818: ,null -- not needed in VO ppvsch.duration
12819: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
12820: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
12821: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
12822: --------------------------------------------------------------------------------
12823: ,pt.address_id
12824: ,null--addr.address1
12825: ,null--addr.address2
12825: ,null--addr.address2
12826: ,null--addr.address3
12827: ,null
12828: ,ppe.wq_item_code
12829: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
12830: ,ppe.wq_uom_code
12831: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12832: ,ppvsch.wq_planned_quantity
12833: ,ppe.wq_actual_entry_code
12827: ,null
12828: ,ppe.wq_item_code
12829: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
12830: ,ppe.wq_uom_code
12831: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12832: ,ppvsch.wq_planned_quantity
12833: ,ppe.wq_actual_entry_code
12834: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
12835: ,tt.prog_entry_enable_flag
12830: ,ppe.wq_uom_code
12831: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
12832: ,ppvsch.wq_planned_quantity
12833: ,ppe.wq_actual_entry_code
12834: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
12835: ,tt.prog_entry_enable_flag
12836: , tt.PERCENT_COMP_ENABLE_FLAG
12837: , tt.REMAIN_EFFORT_ENABLE_FLAG
12838: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
12838: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
12839: ,null -- not needed in VO page_name
12840: ------------------------------------------------ 5
12841: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
12842: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
12843: ,tt.wq_enable_flag
12844: ,tt.prog_entry_req_flag
12845: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12846: , ppru.estimated_remaining_effort
12878: ,to_number(null) -- lifecycle version id
12879: ,ppv.TASK_UNPUB_VER_STATUS_CODE
12880: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
12881: ,to_number(null)
12882: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12883: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12884: ,null --current phase name
12885: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12886: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12909: ) Percent_Complete_Cost
12910: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
12911: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
12912: ----------------------------------------------------------------- 7
12913: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
12914: ,ppvsch.constraint_type_code
12915: ,ppvsch.Constraint_Date
12916: ,ppvsch.Early_Start_Date
12917: ,ppvsch.Early_Finish_Date
13105: ---------------------------------------------------------------------
13106: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
13107: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
13108: ,null -- not used in VO pt.gen_etc_source_code
13109: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
13110: ,ppe.wf_item_type
13111: ,ppe.wf_process
13112: ,ppe.wf_start_lead_days
13113: ,ppe.enable_wf_flag
13128: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
13129: -- Fix for Bug # 4319171.
13130: ,ppru.PROGRESS_ROLLUP_ID
13131: -- Bug Fix 5611634.
13132: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
13133: ,l_check_edit_task_ok
13134: -- End of Bug Fix 5611634.
13135: ,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 -- Added for bug 5090355
13136: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13505: ,por.relationship_type
13506: ,por.relationship_subtype
13507: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
13508: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
13509: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
13510: summary_element_flag -- Fix for Bug # 4490532.
13511: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
13512: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
13513: ,PPS.PROJECT_STATUS_NAME
13561: ,ppvsch.estimated_finish_date - ppvsch.scheduled_finish_date
13562: ,ppvsch.actual_start_date - ppvsch.scheduled_start_date
13563: ,ppvsch.actual_finish_date - ppvsch.scheduled_finish_date
13564: --------------------------------------------- 2
13565: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
13566: ,null -- not populating as not needed in VO ppe.pm_source_code
13567: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
13568: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
13569: ,null
13564: --------------------------------------------- 2
13565: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PM_PRODUCT_CODE', ppe.pm_source_code)
13566: ,null -- not populating as not needed in VO ppe.pm_source_code
13567: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
13568: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
13569: ,null
13570: /* not populating as not needed in VO
13571: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
13572: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
13567: ,null -- -- not populating as not needed in VO ppe.pm_source_reference
13568: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
13569: ,null
13570: /* not populating as not needed in VO
13571: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
13572: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
13573: */
13574: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
13575: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
13568: ,null -- not populating as not needed in VO PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type)
13569: ,null
13570: /* not populating as not needed in VO
13571: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
13572: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
13573: */
13574: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
13575: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
13576: ,papf.work_telephone
13570: /* not populating as not needed in VO
13571: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
13572: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
13573: */
13574: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
13575: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
13576: ,papf.work_telephone
13577: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
13578: ,pt.service_type_code
13571: PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',
13572: PA_PROJ_ELEMENTS_UTILS.IS_ACTIVE_TASK(ppv.element_version_id, ppv.object_type))
13573: */
13574: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
13575: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
13576: ,papf.work_telephone
13577: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
13578: ,pt.service_type_code
13579: ,pwt.name
13573: */
13574: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_START(ppv.element_version_id, ppv.object_type)
13575: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.Get_DAYS_TO_FINISH(ppv.element_version_id, ppv.object_type)
13576: ,papf.work_telephone
13577: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
13578: ,pt.service_type_code
13579: ,pwt.name
13580: ,pt.work_type_id
13581: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
13577: ,lu1.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('SERVICE TYPE',pt.service_type_code)
13578: ,pt.service_type_code
13579: ,pwt.name
13580: ,pt.work_type_id
13581: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
13582: ,pt.chargeable_flag
13583: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
13584: ,pt.billable_flag
13585: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
13579: ,pwt.name
13580: ,pt.work_type_id
13581: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
13582: ,pt.chargeable_flag
13583: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
13584: ,pt.billable_flag
13585: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
13586: ,pt.receive_project_invoice_flag
13587: ,pt.start_date
13581: ,fl4.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.chargeable_flag)
13582: ,pt.chargeable_flag
13583: ,fl5.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.billable_flag)
13584: ,pt.billable_flag
13585: ,fl6.meaning -- PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',pt.receive_project_invoice_flag)
13586: ,pt.receive_project_invoice_flag
13587: ,pt.start_date
13588: ,pt.completion_date
13589: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
13591: ,to_date(NULL) -- not needed in VO
13592: ,to_date(NULL) -- not needed in VO ppa.BASELINE_AS_OF_DATE
13593: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
13594: ,to_date(null) -- not needed in VO ppru.LAST_UPDATE_DATE
13595: -- ,PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(ppe.proj_element_id) -- Fix for Bug # 4447949.
13596: , decode(ppe.proj_element_id, pt.task_id, 'Y', 'N') -- Fix for Bug # 4447949.
13597: ,null -- not needed in VO trunc(ppvsch.estimated_start_date) - trunc(sysdate)
13598: ,null-- not needed in VO trunc(ppvsch.estimated_finish_date) - trunc(sysdate)
13599: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
13599: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_start_date)
13600: ,null -- not needed in VO trunc(sysdate) - trunc(ppvsch.actual_finish_date)
13601: ---------------------------------------------- 3
13602: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
13603: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
13604: ,null -- not needed in VO ppe.CREATION_DATE
13605: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
13606: ,ppe.TYPE_ID
13607: ,tt.task_type
13601: ---------------------------------------------- 3
13602: ,null -- not needed in VO decode(ppvsch.actual_finish_date, NULL, 'N', 'Y')
13603: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',decode(ppvsch.actual_finish_date, NULL, 'N', 'Y'))
13604: ,null -- not needed in VO ppe.CREATION_DATE
13605: ,null -- not needed in VO PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO',PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ppv.element_version_id))
13606: ,ppe.TYPE_ID
13607: ,tt.task_type
13608: ,ppe.STATUS_CODE
13609: ,null -- Populating Task Status Name as NULL
13612: ,pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours) planned_effort
13613: -- Fix for Bug # 4319171.
13614: ,por.WEIGHTING_PERCENTAGE
13615: ,null -- not needed in VO ppvsch.duration
13616: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
13617: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
13618: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
13619: --------------------------------------------------------------------------------
13620: ,pt.address_id
13613: -- Fix for Bug # 4319171.
13614: ,por.WEIGHTING_PERCENTAGE
13615: ,null -- not needed in VO ppvsch.duration
13616: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
13617: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
13618: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
13619: --------------------------------------------------------------------------------
13620: ,pt.address_id
13621: ,null--addr.address1
13614: ,por.WEIGHTING_PERCENTAGE
13615: ,null -- not needed in VO ppvsch.duration
13616: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppe.baseline_duration)
13617: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.estimated_duration)
13618: ,null -- not needed in VO pa_proj_elements_utils.convert_hr_to_days(ppvsch.actual_duration)
13619: --------------------------------------------------------------------------------
13620: ,pt.address_id
13621: ,null--addr.address1
13622: ,null--addr.address2
13622: ,null--addr.address2
13623: ,null--addr.address3
13624: ,null
13625: ,ppe.wq_item_code
13626: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
13627: ,ppe.wq_uom_code
13628: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
13629: ,ppvsch.wq_planned_quantity
13630: ,ppe.wq_actual_entry_code
13624: ,null
13625: ,ppe.wq_item_code
13626: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_WQ_WORK_ITEMS',ppe.wq_item_code)
13627: ,ppe.wq_uom_code
13628: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
13629: ,ppvsch.wq_planned_quantity
13630: ,ppe.wq_actual_entry_code
13631: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
13632: ,tt.prog_entry_enable_flag
13627: ,ppe.wq_uom_code
13628: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('UNIT',ppe.wq_uom_code)
13629: ,ppvsch.wq_planned_quantity
13630: ,ppe.wq_actual_entry_code
13631: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_ACTUAL_WQ_ENTRY_CODE',ppe.wq_actual_entry_code)
13632: ,tt.prog_entry_enable_flag
13633: , tt.PERCENT_COMP_ENABLE_FLAG
13634: , tt.REMAIN_EFFORT_ENABLE_FLAG
13635: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
13635: ,to_number(null) -- not needed in VO TASK_PROGRESS_ENTRY_PAGE_ID
13636: ,null -- not needed in VO page_name
13637: ------------------------------------------------ 5
13638: ,NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code)
13639: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_PERCENT_COMP_DERIV_CODE',NVL(ppe.base_percent_comp_deriv_code,tt.base_percent_comp_deriv_code))
13640: ,tt.wq_enable_flag
13641: ,tt.prog_entry_req_flag
13642: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
13643: , ppru.estimated_remaining_effort
13675: ,to_number(null) -- lifecycle version id
13676: ,ppv.TASK_UNPUB_VER_STATUS_CODE
13677: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
13678: ,to_number(null)
13679: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13680: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13681: ,null --current phase name
13682: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
13683: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
13706: ) Percent_Complete_Cost
13707: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
13708: ,trunc(ppvsch.SCHEDULED_FINISH_DATE) - trunc(sysdate) Remaining_Duration
13709: ----------------------------------------------------------------- 7
13710: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',ppvsch.constraint_type_code ) Constraint_Type
13711: ,ppvsch.constraint_type_code
13712: ,ppvsch.Constraint_Date
13713: ,ppvsch.Early_Start_Date
13714: ,ppvsch.Early_Finish_Date
13902: ---------------------------------------------------------------------
13903: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
13904: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
13905: ,null -- not used in VO pt.gen_etc_source_code
13906: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
13907: ,ppe.wf_item_type
13908: ,ppe.wf_process
13909: ,ppe.wf_start_lead_days
13910: ,ppe.enable_wf_flag
13925: , ppru.subprj_oth_act_cost_to_date_pc)) etc_cost
13926: -- Fix for Bug # 4319171.
13927: ,ppru.PROGRESS_ROLLUP_ID
13928: -- Bug Fix 5611634.
13929: --,PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(ppe.project_id, ppv.parent_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId)
13930: ,l_check_edit_task_ok
13931: -- End of Bug Fix 5611634.
13932: ,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 -- Added for bug 5090355
13933: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355