[Home] [Help]
1161: ,pt.receive_project_invoice_flag
1162: ,pt.start_date
1163: ,pt.completion_date
1164: -- Bug 6156686
1165: ,DECODE(l_pc_lines_exist_flag,'Y',PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date),0)
1166: ,ppvsch.last_update_date
1167: ,to_date(NULL)
1168: ,ppa.BASELINE_AS_OF_DATE
1169: ,ppru.LAST_UPDATE_DATE
1189: ,ppe.STATUS_CODE
1190: ,pps3.PROJECT_STATUS_NAME
1191: ,ppe5.phase_code
1192: ,pps5.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)
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
1223: , ppru.eqpmt_etc_effort
1224: , null
1225: , ppru.subprj_ppl_etc_effort
1225: , ppru.subprj_ppl_etc_effort
1226: , ppru.subprj_eqpmt_etc_effort
1227: , null
1228: , null
1229: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
1230: , ppru.eqpmt_act_effort_to_date
1231: , null
1232: , ppru.subprj_ppl_act_effort
1233: , ppru.subprj_eqpmt_act_effort
1273: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
1274: ,pfxat.prj_raw_cost raw_cost
1275: ,pfxat.prj_brdn_cost burdened_cost
1276: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
1277: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
1278: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
1279: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
1280: -- Bug 6156686
1281: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1278: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
1279: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
1280: -- Bug 6156686
1281: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1282: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1283: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1284: ) percent_Spent_Effort
1285: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
1286: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
1281: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1282: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1283: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1284: ) percent_Spent_Effort
1285: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
1286: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
1287: nvl(pfxat.prj_brdn_cost,0)
1288: ) percent_Spent_Cost
1289: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1285: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
1286: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
1287: nvl(pfxat.prj_brdn_cost,0)
1288: ) percent_Spent_Cost
1289: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1290: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
1291: ) Percent_Complete_Effort
1292: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
1293: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
1288: ) percent_Spent_Cost
1289: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1290: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
1291: ) Percent_Complete_Effort
1292: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
1293: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
1315: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
1316: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
1317: ,to_number ( null ) Planned_Baseline_Start
1318: ,to_number ( null ) Planned_Baseline_Finish
1319: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
1320: -- Fix for Bug # 4319171.
1321: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
1322: , ppru.estimated_remaining_effort
1323: , ppru.eqpmt_etc_effort
1317: ,to_number ( null ) Planned_Baseline_Start
1318: ,to_number ( null ) Planned_Baseline_Finish
1319: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
1320: -- Fix for Bug # 4319171.
1321: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
1322: , ppru.estimated_remaining_effort
1323: , ppru.eqpmt_etc_effort
1324: , null
1325: , ppru.subprj_ppl_etc_effort
1325: , ppru.subprj_ppl_etc_effort
1326: , ppru.subprj_eqpmt_etc_effort
1327: , null
1328: , null
1329: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
1330: , ppru.eqpmt_act_effort_to_date
1331: , null
1332: , ppru.subprj_ppl_act_effort
1333: , ppru.subprj_eqpmt_act_effort
1333: , ppru.subprj_eqpmt_act_effort
1334: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
1335: ,nvl(ppru.ppl_act_effort_to_date,0)
1336: +nvl(ppru.eqpmt_act_effort_to_date,0)
1337: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1338: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
1339: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
1340: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
1341: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
1341: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
1342: ,nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)
1343: -(nvl(ppru.ppl_act_effort_to_date,0)
1344: +nvl(ppru.eqpmt_act_effort_to_date,0)
1345: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1346: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
1347: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
1348: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
1349: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING'))) Variance_At_Completion_Effort
1350: ,ppru.earned_value -(nvl(ppru.ppl_act_effort_to_date,0)+
1351: nvl(ppru.eqpmt_act_effort_to_date,0))
1352: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
1353: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1354: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
1355: , ppru.eqpmt_act_cost_to_date_pc
1356: , ppru.oth_act_cost_to_date_pc
1357: , null
1358: , null
1360: ,pfxat.prj_base_brdn_cost baseline_cost
1361: ,nvl(ppru.oth_act_cost_to_date_pc,0)
1362: +nvl(ppru.ppl_act_cost_to_date_pc,0)
1363: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
1364: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
1365: ,ppru.ppl_etc_cost_pc
1366: ,ppru.eqpmt_etc_cost_pc
1367: ,ppru.oth_etc_cost_pc
1368: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
1383: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
1384: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
1385: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
1386: ,ppru.earned_value Earned_Value
1387: ,nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
1388: ppru.object_id,
1389: ppv.proj_element_id,
1390: ppru.as_of_date,
1391: ppv.parent_structure_version_id,
1394: ppe.baseline_finish_date,ppa.project_currency_code),0) Schedule_Variance
1395: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1396: NVL(ppru.ppl_act_cost_to_date_pc,0)+
1397: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
1398: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
1399: ppru.object_id,
1400: ppe.proj_element_id,
1401: ppru.as_of_date,
1402: ppv.parent_structure_version_id,
1406: ,((nvl(pfxat.prj_base_brdn_cost,0))
1407: -(nvl(ppru.oth_act_cost_to_date_pc,0)
1408: +nvl(ppru.ppl_act_cost_to_date_pc,0)
1409: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
1410: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
1411: ,ppru.ppl_etc_cost_pc
1412: ,ppru.eqpmt_etc_cost_pc
1413: ,ppru.oth_etc_cost_pc
1414: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
1438: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))),0,1,(nvl(pfxat.prj_base_brdn_cost,0)-(nvl(ppru.oth_act_cost_to_date_pc,0)
1439: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)
1440: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)
1441: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index */
1442: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
1443: ppru.object_id,
1444: ppe.proj_element_id,
1445: ppru.as_of_date,
1446: ppv.parent_structure_version_id,
1446: ppv.parent_structure_version_id,
1447: pppa.task_weight_basis_code,
1448: ppe.baseline_start_date,
1449: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
1450: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
1451: ppru.object_id,
1452: ppe.proj_element_id,
1453: ppru.as_of_date,
1454: ppv.parent_structure_version_id,
1453: ppru.as_of_date,
1454: ppv.parent_structure_version_id,
1455: pppa.task_weight_basis_code,
1456: ppe.baseline_start_date,
1457: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
1458: ppru.object_id,
1459: ppe.proj_element_id,
1460: ppru.as_of_date,
1461: ppv.parent_structure_version_id,
1478: ,ppe.wf_process
1479: ,ppe.wf_start_lead_days
1480: ,ppe.enable_wf_flag
1481: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
1482: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
1483: , ppru.ppl_etc_cost_pc
1484: , ppru.eqpmt_etc_cost_pc
1485: , ppru.oth_etc_cost_pc
1486: , ppru.subprj_ppl_etc_cost_pc
1486: , ppru.subprj_ppl_etc_cost_pc
1487: , ppru.subprj_eqpmt_etc_cost_pc
1488: , ppru.subprj_oth_etc_cost_pc
1489: , null
1490: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
1491: , ppru.eqpmt_act_cost_to_date_pc
1492: , ppru.oth_act_cost_to_date_pc
1493: , ppru.subprj_ppl_act_cost_pc
1494: , ppru.subprj_eqpmt_act_cost_pc
1973: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
1974: ,pt.receive_project_invoice_flag
1975: ,pt.start_date
1976: ,pt.completion_date
1977: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
1978: ,ppvsch.last_update_date
1979: ,to_date(NULL)
1980: ,ppa.BASELINE_AS_OF_DATE
1981: ,ppru.LAST_UPDATE_DATE
2001: ,ppe.STATUS_CODE
2002: ,pps3.PROJECT_STATUS_NAME
2003: ,ppe5.phase_code
2004: ,pps5.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)
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
2035: , ppru.eqpmt_etc_effort
2036: , null
2037: , ppru.subprj_ppl_etc_effort
2037: , ppru.subprj_ppl_etc_effort
2038: , ppru.subprj_eqpmt_etc_effort
2039: , null
2040: , null
2041: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
2042: , ppru.eqpmt_act_effort_to_date
2043: , null
2044: , ppru.subprj_ppl_act_effort
2045: , ppru.subprj_eqpmt_act_effort
2080: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2081: ,pfxat.prj_raw_cost raw_cost
2082: ,pfxat.prj_brdn_cost burdened_cost
2083: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
2084: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2085: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2086: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2087: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2088: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2084: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2085: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2086: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2087: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2088: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2089: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2090: ) percent_Spent_Effort
2091: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2092: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2087: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2088: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2089: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2090: ) percent_Spent_Effort
2091: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2092: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2093: nvl(pfxat.prj_brdn_cost,0)
2094: ) percent_Spent_Cost
2095: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2091: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2092: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2093: nvl(pfxat.prj_brdn_cost,0)
2094: ) percent_Spent_Cost
2095: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2096: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
2097: ) Percent_Complete_Effort
2098: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2099: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2094: ) percent_Spent_Cost
2095: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2096: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
2097: ) Percent_Complete_Effort
2098: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2099: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
2121: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
2122: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
2123: ,to_number ( null ) Planned_Baseline_Start
2124: ,to_number ( null ) Planned_Baseline_Finish
2125: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
2126: -- Fix for Bug # 4319171.
2127: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2128: , ppru.estimated_remaining_effort
2129: , ppru.eqpmt_etc_effort
2123: ,to_number ( null ) Planned_Baseline_Start
2124: ,to_number ( null ) Planned_Baseline_Finish
2125: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
2126: -- Fix for Bug # 4319171.
2127: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2128: , ppru.estimated_remaining_effort
2129: , ppru.eqpmt_etc_effort
2130: , null
2131: , ppru.subprj_ppl_etc_effort
2131: , ppru.subprj_ppl_etc_effort
2132: , ppru.subprj_eqpmt_etc_effort
2133: , null
2134: , null
2135: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
2136: , ppru.eqpmt_act_effort_to_date
2137: , null
2138: , ppru.subprj_ppl_act_effort
2139: , ppru.subprj_eqpmt_act_effort
2139: , ppru.subprj_eqpmt_act_effort
2140: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
2141: ,nvl(ppru.ppl_act_effort_to_date,0)
2142: +nvl(ppru.eqpmt_act_effort_to_date,0)
2143: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2144: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
2145: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
2146: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
2147: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
2147: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
2148: ,nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)
2149: -(nvl(ppru.ppl_act_effort_to_date,0)
2150: +nvl(ppru.eqpmt_act_effort_to_date,0)
2151: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2152: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
2153: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
2154: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
2155: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING'))) Variance_At_Completion_Effort
2156: ,ppru.earned_value -(nvl(ppru.ppl_act_effort_to_date,0)+
2157: nvl(ppru.eqpmt_act_effort_to_date,0))
2158: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
2159: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
2160: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
2161: , ppru.eqpmt_act_cost_to_date_pc
2162: , ppru.oth_act_cost_to_date_pc
2163: , null
2164: , null
2166: ,pfxat.prj_base_brdn_cost baseline_cost
2167: ,nvl(ppru.oth_act_cost_to_date_pc,0)
2168: +nvl(ppru.ppl_act_cost_to_date_pc,0)
2169: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
2170: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
2171: ,ppru.ppl_etc_cost_pc
2172: ,ppru.eqpmt_etc_cost_pc
2173: ,ppru.oth_etc_cost_pc
2174: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
2189: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
2190: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
2191: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
2192: ,ppru.earned_value Earned_Value
2193: ,nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
2194: ppru.object_id,
2195: ppv.proj_element_id,
2196: ppru.as_of_date,
2197: ppv.parent_structure_version_id,
2200: ppe.baseline_finish_date,ppa.project_currency_code),0) Schedule_Variance
2201: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
2202: NVL(ppru.ppl_act_cost_to_date_pc,0)+
2203: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
2204: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
2205: ppru.object_id,
2206: ppe.proj_element_id,
2207: ppru.as_of_date,
2208: ppv.parent_structure_version_id,
2212: ,((nvl(pfxat.prj_base_brdn_cost,0))
2213: -(nvl(ppru.oth_act_cost_to_date_pc,0)
2214: +nvl(ppru.ppl_act_cost_to_date_pc,0)
2215: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
2216: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
2217: ,ppru.ppl_etc_cost_pc
2218: ,ppru.eqpmt_etc_cost_pc
2219: ,ppru.oth_etc_cost_pc
2220: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
2253: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))),0,1,(nvl(pfxat.prj_base_brdn_cost,0)-(nvl(ppru.oth_act_cost_to_date_pc,0)
2254: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)
2255: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)
2256: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index */
2257: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
2258: ppru.object_id,
2259: ppe.proj_element_id,
2260: ppru.as_of_date,
2261: ppv.parent_structure_version_id,
2261: ppv.parent_structure_version_id,
2262: pppa.task_weight_basis_code,
2263: ppe.baseline_start_date,
2264: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
2265: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
2266: ppru.object_id,
2267: ppe.proj_element_id,
2268: ppru.as_of_date,
2269: ppv.parent_structure_version_id,
2268: ppru.as_of_date,
2269: ppv.parent_structure_version_id,
2270: pppa.task_weight_basis_code,
2271: ppe.baseline_start_date,
2272: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
2273: ppru.object_id,
2274: ppe.proj_element_id,
2275: ppru.as_of_date,
2276: ppv.parent_structure_version_id,
2293: ,ppe.wf_process
2294: ,ppe.wf_start_lead_days
2295: ,ppe.enable_wf_flag
2296: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
2297: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
2298: , ppru.ppl_etc_cost_pc
2299: , ppru.eqpmt_etc_cost_pc
2300: , ppru.oth_etc_cost_pc
2301: , ppru.subprj_ppl_etc_cost_pc
2301: , ppru.subprj_ppl_etc_cost_pc
2302: , ppru.subprj_eqpmt_etc_cost_pc
2303: , ppru.subprj_oth_etc_cost_pc
2304: , null
2305: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
2306: , ppru.eqpmt_act_cost_to_date_pc
2307: , ppru.oth_act_cost_to_date_pc
2308: , ppru.subprj_ppl_act_cost_pc
2309: , ppru.subprj_eqpmt_act_cost_pc
2836: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
2837: ,pt.receive_project_invoice_flag
2838: ,pt.start_date
2839: ,pt.completion_date
2840: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
2841: ,ppvsch.last_update_date
2842: ,to_date(NULL)
2843: ,ppa.BASELINE_AS_OF_DATE
2844: ,ppru.LAST_UPDATE_DATE
2864: ,ppe.STATUS_CODE
2865: ,pps3.PROJECT_STATUS_NAME
2866: ,ppe5.phase_code
2867: ,pps5.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)
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
2898: , ppru.eqpmt_etc_effort
2899: , null
2900: , ppru.subprj_ppl_etc_effort
2900: , ppru.subprj_ppl_etc_effort
2901: , ppru.subprj_eqpmt_etc_effort
2902: , null
2903: , null
2904: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
2905: , ppru.eqpmt_act_effort_to_date
2906: , null
2907: , ppru.subprj_ppl_act_effort
2908: , ppru.subprj_eqpmt_act_effort
2943: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2944: ,pfxat.prj_raw_cost raw_cost
2945: ,pfxat.prj_brdn_cost burdened_cost
2946: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
2947: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2948: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2949: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2950: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2951: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2947: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2948: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2949: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2950: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2951: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2952: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2953: ) percent_Spent_Effort
2954: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2955: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2950: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2951: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2952: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2953: ) percent_Spent_Effort
2954: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2955: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2956: nvl(pfxat.prj_brdn_cost,0)
2957: ) percent_Spent_Cost
2958: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2954: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2955: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2956: nvl(pfxat.prj_brdn_cost,0)
2957: ) percent_Spent_Cost
2958: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2959: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
2960: ) Percent_Complete_Effort
2961: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2962: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
2957: ) percent_Spent_Cost
2958: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2959: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
2960: ) Percent_Complete_Effort
2961: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
2962: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
2984: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
2985: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
2986: ,to_number ( null ) Planned_Baseline_Start
2987: ,to_number ( null ) Planned_Baseline_Finish
2988: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
2989: -- Fix for Bug # 4319171.
2990: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2991: , ppru.estimated_remaining_effort
2992: , ppru.eqpmt_etc_effort
2986: ,to_number ( null ) Planned_Baseline_Start
2987: ,to_number ( null ) Planned_Baseline_Finish
2988: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
2989: -- Fix for Bug # 4319171.
2990: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
2991: , ppru.estimated_remaining_effort
2992: , ppru.eqpmt_etc_effort
2993: , null
2994: , ppru.subprj_ppl_etc_effort
2994: , ppru.subprj_ppl_etc_effort
2995: , ppru.subprj_eqpmt_etc_effort
2996: , null
2997: , null
2998: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
2999: , ppru.eqpmt_act_effort_to_date
3000: , null
3001: , ppru.subprj_ppl_act_effort
3002: , ppru.subprj_eqpmt_act_effort
3002: , ppru.subprj_eqpmt_act_effort
3003: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
3004: ,nvl(ppru.ppl_act_effort_to_date,0)
3005: +nvl(ppru.eqpmt_act_effort_to_date,0)
3006: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3007: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
3008: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
3009: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
3010: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
3010: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
3011: ,nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)
3012: -(nvl(ppru.ppl_act_effort_to_date,0)
3013: +nvl(ppru.eqpmt_act_effort_to_date,0)
3014: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3015: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
3016: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
3017: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
3018: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING'))) Variance_At_Completion_Effort
3019: ,ppru.earned_value -(nvl(ppru.ppl_act_effort_to_date,0)+
3020: nvl(ppru.eqpmt_act_effort_to_date,0))
3021: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
3022: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3023: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
3024: , ppru.eqpmt_act_cost_to_date_pc
3025: , ppru.oth_act_cost_to_date_pc
3026: , null
3027: , null
3029: ,pfxat.prj_base_brdn_cost baseline_cost
3030: ,nvl(ppru.oth_act_cost_to_date_pc,0)
3031: +nvl(ppru.ppl_act_cost_to_date_pc,0)
3032: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
3033: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
3034: ,ppru.ppl_etc_cost_pc
3035: ,ppru.eqpmt_etc_cost_pc
3036: ,ppru.oth_etc_cost_pc
3037: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
3052: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
3053: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
3054: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
3055: ,ppru.earned_value Earned_Value
3056: ,nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
3057: ppru.object_id,
3058: ppv.proj_element_id,
3059: ppru.as_of_date,
3060: ppv.parent_structure_version_id,
3063: ppe.baseline_finish_date,ppa.project_currency_code),0) Schedule_Variance
3064: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
3065: NVL(ppru.ppl_act_cost_to_date_pc,0)+
3066: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
3067: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
3068: ppru.object_id,
3069: ppe.proj_element_id,
3070: ppru.as_of_date,
3071: ppv.parent_structure_version_id,
3075: ,((nvl(pfxat.prj_base_brdn_cost,0))
3076: -(nvl(ppru.oth_act_cost_to_date_pc,0)
3077: +nvl(ppru.ppl_act_cost_to_date_pc,0)
3078: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
3079: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
3080: ,ppru.ppl_etc_cost_pc
3081: ,ppru.eqpmt_etc_cost_pc
3082: ,ppru.oth_etc_cost_pc
3083: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
3111: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))),0,1,(nvl(pfxat.prj_base_brdn_cost,0)-(nvl(ppru.oth_act_cost_to_date_pc,0)
3112: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)
3113: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)
3114: +nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index */
3115: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
3116: ppru.object_id,
3117: ppe.proj_element_id,
3118: ppru.as_of_date,
3119: ppv.parent_structure_version_id,
3119: ppv.parent_structure_version_id,
3120: pppa.task_weight_basis_code,
3121: ppe.baseline_start_date,
3122: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
3123: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
3124: ppru.object_id,
3125: ppe.proj_element_id,
3126: ppru.as_of_date,
3127: ppv.parent_structure_version_id,
3126: ppru.as_of_date,
3127: ppv.parent_structure_version_id,
3128: pppa.task_weight_basis_code,
3129: ppe.baseline_start_date,
3130: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
3131: ppru.object_id,
3132: ppe.proj_element_id,
3133: ppru.as_of_date,
3134: ppv.parent_structure_version_id,
3151: ,ppe.wf_process
3152: ,ppe.wf_start_lead_days
3153: ,ppe.enable_wf_flag
3154: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
3155: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
3156: , ppru.ppl_etc_cost_pc
3157: , ppru.eqpmt_etc_cost_pc
3158: , ppru.oth_etc_cost_pc
3159: , ppru.subprj_ppl_etc_cost_pc
3159: , ppru.subprj_ppl_etc_cost_pc
3160: , ppru.subprj_eqpmt_etc_cost_pc
3161: , ppru.subprj_oth_etc_cost_pc
3162: , null
3163: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
3164: , ppru.eqpmt_act_cost_to_date_pc
3165: , ppru.oth_act_cost_to_date_pc
3166: , ppru.subprj_ppl_act_cost_pc
3167: , ppru.subprj_eqpmt_act_cost_pc
3775: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
3776: ,pt.receive_project_invoice_flag
3777: ,pt.start_date
3778: ,pt.completion_date
3779: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
3780: ,ppvsch.last_update_date
3781: ,to_date(NULL)
3782: ,ppa.BASELINE_AS_OF_DATE
3783: ,ppru.LAST_UPDATE_DATE
3803: ,ppe.STATUS_CODE
3804: ,pps3.PROJECT_STATUS_NAME
3805: ,ppe5.phase_code
3806: ,pps5.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)
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
3837: , ppru.eqpmt_act_effort_to_date
3838: , null
3839: , null
3875: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
3876: ,pfxat.prj_raw_cost raw_cost
3877: ,pfxat.prj_brdn_cost burdened_cost
3878: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
3879: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
3880: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
3881: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
3882: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
3883: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
3879: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
3880: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
3881: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
3882: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
3883: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
3884: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3885: ) percent_Spent_Effort
3886: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
3887: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
3882: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
3883: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
3884: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3885: ) percent_Spent_Effort
3886: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
3887: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
3888: nvl(pfxat.prj_brdn_cost,0)
3889: ) percent_Spent_Cost
3890: -- Begin Bug # 4546322
3887: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
3888: nvl(pfxat.prj_brdn_cost,0)
3889: ) percent_Spent_Cost
3890: -- Begin Bug # 4546322
3891: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
3892: , ppru.eqpmt_act_effort_to_date
3893: , null
3894: , null
3895: , null
3893: , null
3894: , null
3895: , null
3896: , null)
3897: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
3898: , pfxat.equipment_hours
3899: , null)
3900: , ppru.estimated_remaining_effort
3901: , ppru.eqpmt_etc_effort
3903: , null
3904: , null
3905: , null
3906: , null
3907: , pa_progress_utils.calc_act
3908: (ppru.ppl_act_effort_to_date
3909: , ppru.eqpmt_act_effort_to_date
3910: , null
3911: , null
3910: , null
3911: , null
3912: , null
3913: , null))) Percent_Complete_Effort
3914: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
3915: , ppru.eqpmt_act_cost_to_date_pc
3916: , ppru.oth_act_cost_to_date_pc
3917: , null
3918: , null
3916: , ppru.oth_act_cost_to_date_pc
3917: , null
3918: , null
3919: , null)
3920: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
3921: , ppru.ppl_etc_cost_pc
3922: , ppru.eqpmt_etc_cost_pc
3923: , ppru.oth_etc_cost_pc
3924: , null
3924: , null
3925: , null
3926: , null
3927: , null
3928: , pa_progress_utils.calc_act
3929: (ppru.ppl_act_cost_to_date_pc
3930: , ppru.eqpmt_act_cost_to_date_pc
3931: , ppru.oth_act_cost_to_date_pc
3932: , null
3955: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
3956: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
3957: ,to_number ( null ) Planned_Baseline_Start
3958: ,to_number ( null ) Planned_Baseline_Finish
3959: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
3960: -- Fix for Bug # 4319171.
3961: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
3962: , ppru.estimated_remaining_effort
3963: , ppru.eqpmt_etc_effort
3957: ,to_number ( null ) Planned_Baseline_Start
3958: ,to_number ( null ) Planned_Baseline_Finish
3959: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
3960: -- Fix for Bug # 4319171.
3961: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
3962: , ppru.estimated_remaining_effort
3963: , ppru.eqpmt_etc_effort
3964: , null
3965: , ppru.subprj_ppl_etc_effort
3965: , ppru.subprj_ppl_etc_effort
3966: , ppru.subprj_eqpmt_etc_effort
3967: , null
3968: , null
3969: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
3970: , ppru.eqpmt_act_effort_to_date
3971: , null
3972: , ppru.subprj_ppl_act_effort
3973: , ppru.subprj_eqpmt_act_effort
3973: , ppru.subprj_eqpmt_act_effort
3974: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
3975: ,(nvl(ppru.ppl_act_effort_to_date,0)
3976: +nvl(ppru.eqpmt_act_effort_to_date,0)
3977: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3978: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
3979: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
3980: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
3981: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
3981: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
3982: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
3983: -(nvl(ppru.ppl_act_effort_to_date,0)
3984: +nvl(ppru.eqpmt_act_effort_to_date,0)
3985: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3986: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
3987: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
3988: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
3989: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
3990: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
3991: nvl(ppru.eqpmt_act_effort_to_date,0)))
3992: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
3993: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3994: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
3995: , ppru.eqpmt_act_cost_to_date_pc
3996: , ppru.oth_act_cost_to_date_pc
3997: , null
3998: , null
4000: ,pfxat.prj_base_brdn_cost baseline_cost
4001: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
4002: +nvl(ppru.ppl_act_cost_to_date_pc,0)
4003: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
4004: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
4005: ,ppru.ppl_etc_cost_pc
4006: ,ppru.eqpmt_etc_cost_pc
4007: ,ppru.oth_etc_cost_pc
4008: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
4023: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
4024: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
4025: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
4026: ,ppru.earned_value Earned_Value
4027: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
4028: ppru.object_id,
4029: ppv.proj_element_id,
4030: ppru.as_of_date,
4031: ppv.parent_structure_version_id,
4034: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
4035: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4036: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4037: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
4038: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
4039: ppru.object_id,
4040: ppe.proj_element_id,
4041: ppru.as_of_date,
4042: ppv.parent_structure_version_id,
4046: ,((nvl(pfxat.prj_base_brdn_cost,0))
4047: -(nvl(ppru.oth_act_cost_to_date_pc,0)
4048: +nvl(ppru.ppl_act_cost_to_date_pc,0)
4049: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
4050: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
4051: ,ppru.ppl_etc_cost_pc
4052: ,ppru.eqpmt_etc_cost_pc
4053: ,ppru.oth_etc_cost_pc
4054: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
4083: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
4084: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
4085: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
4086: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index*/
4087: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
4088: ppru.object_id,
4089: ppe.proj_element_id,
4090: ppru.as_of_date,
4091: ppv.parent_structure_version_id,
4091: ppv.parent_structure_version_id,
4092: pppa.task_weight_basis_code,
4093: ppe.baseline_start_date,
4094: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
4095: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
4096: ppru.object_id,
4097: ppe.proj_element_id,
4098: ppru.as_of_date,
4099: ppv.parent_structure_version_id,
4098: ppru.as_of_date,
4099: ppv.parent_structure_version_id,
4100: pppa.task_weight_basis_code,
4101: ppe.baseline_start_date,
4102: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
4103: ppru.object_id,
4104: ppe.proj_element_id,
4105: ppru.as_of_date,
4106: ppv.parent_structure_version_id,
4122: ,ppe.wf_process
4123: ,ppe.wf_start_lead_days
4124: ,ppe.enable_wf_flag
4125: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4126: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4127: , ppru.ppl_etc_cost_pc
4128: , ppru.eqpmt_etc_cost_pc
4129: , ppru.oth_etc_cost_pc
4130: , ppru.subprj_ppl_etc_cost_pc
4130: , ppru.subprj_ppl_etc_cost_pc
4131: , ppru.subprj_eqpmt_etc_cost_pc
4132: , ppru.subprj_oth_etc_cost_pc
4133: , null
4134: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
4135: , ppru.eqpmt_act_cost_to_date_pc
4136: , ppru.oth_act_cost_to_date_pc
4137: , ppru.subprj_ppl_act_cost_pc
4138: , ppru.subprj_eqpmt_act_cost_pc
4600: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
4601: ,pt.receive_project_invoice_flag
4602: ,pt.start_date
4603: ,pt.completion_date
4604: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
4605: ,ppvsch.last_update_date
4606: ,to_date(NULL)
4607: ,ppa.BASELINE_AS_OF_DATE
4608: ,ppru.LAST_UPDATE_DATE
4628: ,ppe.STATUS_CODE
4629: ,pps3.PROJECT_STATUS_NAME
4630: ,ppe5.phase_code
4631: ,pps5.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)
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
4662: , ppru.eqpmt_act_effort_to_date
4663: , null
4664: , null
4700: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
4701: ,pfxat.prj_raw_cost raw_cost
4702: ,pfxat.prj_brdn_cost burdened_cost
4703: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
4704: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
4705: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
4706: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
4707: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4708: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4704: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
4705: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
4706: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
4707: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4708: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4709: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4710: ) percent_Spent_Effort
4711: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
4712: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4707: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4708: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4709: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4710: ) percent_Spent_Effort
4711: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
4712: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4713: nvl(pfxat.prj_brdn_cost,0)
4714: ) percent_Spent_Cost
4715: -- Begin Bug # 4546322
4712: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4713: nvl(pfxat.prj_brdn_cost,0)
4714: ) percent_Spent_Cost
4715: -- Begin Bug # 4546322
4716: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
4717: , ppru.eqpmt_act_effort_to_date
4718: , null
4719: , null
4720: , null
4718: , null
4719: , null
4720: , null
4721: , null)
4722: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
4723: , pfxat.equipment_hours
4724: , null)
4725: , ppru.estimated_remaining_effort
4726: , ppru.eqpmt_etc_effort
4728: , null
4729: , null
4730: , null
4731: , null
4732: , pa_progress_utils.calc_act
4733: (ppru.ppl_act_effort_to_date
4734: , ppru.eqpmt_act_effort_to_date
4735: , null
4736: , null
4735: , null
4736: , null
4737: , null
4738: , null))) Percent_Complete_Effort
4739: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
4740: , ppru.eqpmt_act_cost_to_date_pc
4741: , ppru.oth_act_cost_to_date_pc
4742: , null
4743: , null
4741: , ppru.oth_act_cost_to_date_pc
4742: , null
4743: , null
4744: , null)
4745: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4746: , ppru.ppl_etc_cost_pc
4747: , ppru.eqpmt_etc_cost_pc
4748: , ppru.oth_etc_cost_pc
4749: , null
4749: , null
4750: , null
4751: , null
4752: , null
4753: , pa_progress_utils.calc_act
4754: (ppru.ppl_act_cost_to_date_pc
4755: , ppru.eqpmt_act_cost_to_date_pc
4756: , ppru.oth_act_cost_to_date_pc
4757: , null
4780: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
4781: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
4782: ,to_number ( null ) Planned_Baseline_Start
4783: ,to_number ( null ) Planned_Baseline_Finish
4784: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
4785: -- Fix for Bug # 4319171.
4786: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
4787: , ppru.estimated_remaining_effort
4788: , ppru.eqpmt_etc_effort
4782: ,to_number ( null ) Planned_Baseline_Start
4783: ,to_number ( null ) Planned_Baseline_Finish
4784: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
4785: -- Fix for Bug # 4319171.
4786: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
4787: , ppru.estimated_remaining_effort
4788: , ppru.eqpmt_etc_effort
4789: , null
4790: , ppru.subprj_ppl_etc_effort
4790: , ppru.subprj_ppl_etc_effort
4791: , ppru.subprj_eqpmt_etc_effort
4792: , null
4793: , null
4794: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
4795: , ppru.eqpmt_act_effort_to_date
4796: , null
4797: , ppru.subprj_ppl_act_effort
4798: , ppru.subprj_eqpmt_act_effort
4798: , ppru.subprj_eqpmt_act_effort
4799: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
4800: ,(nvl(ppru.ppl_act_effort_to_date,0)
4801: +nvl(ppru.eqpmt_act_effort_to_date,0)
4802: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4803: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
4804: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
4805: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
4806: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
4806: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
4807: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
4808: -(nvl(ppru.ppl_act_effort_to_date,0)
4809: +nvl(ppru.eqpmt_act_effort_to_date,0)
4810: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4811: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
4812: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
4813: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
4814: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
4815: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
4816: nvl(ppru.eqpmt_act_effort_to_date,0)))
4817: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
4818: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
4819: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
4820: , ppru.eqpmt_act_cost_to_date_pc
4821: , ppru.oth_act_cost_to_date_pc
4822: , null
4823: , null
4825: ,pfxat.prj_base_brdn_cost baseline_cost
4826: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
4827: +nvl(ppru.ppl_act_cost_to_date_pc,0)
4828: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
4829: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
4830: ,ppru.ppl_etc_cost_pc
4831: ,ppru.eqpmt_etc_cost_pc
4832: ,ppru.oth_etc_cost_pc
4833: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
4848: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
4849: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
4850: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
4851: ,ppru.earned_value Earned_Value
4852: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
4853: ppru.object_id,
4854: ppv.proj_element_id,
4855: ppru.as_of_date,
4856: ppv.parent_structure_version_id,
4859: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
4860: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4861: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4862: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
4863: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
4864: ppru.object_id,
4865: ppe.proj_element_id,
4866: ppru.as_of_date,
4867: ppv.parent_structure_version_id,
4871: ,((nvl(pfxat.prj_base_brdn_cost,0))
4872: -(nvl(ppru.oth_act_cost_to_date_pc,0)
4873: +nvl(ppru.ppl_act_cost_to_date_pc,0)
4874: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
4875: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
4876: ,ppru.ppl_etc_cost_pc
4877: ,ppru.eqpmt_etc_cost_pc
4878: ,ppru.oth_etc_cost_pc
4879: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
4908: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
4909: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
4910: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
4911: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index*/
4912: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
4913: ppru.object_id,
4914: ppe.proj_element_id,
4915: ppru.as_of_date,
4916: ppv.parent_structure_version_id,
4916: ppv.parent_structure_version_id,
4917: pppa.task_weight_basis_code,
4918: ppe.baseline_start_date,
4919: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
4920: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
4921: ppru.object_id,
4922: ppe.proj_element_id,
4923: ppru.as_of_date,
4924: ppv.parent_structure_version_id,
4923: ppru.as_of_date,
4924: ppv.parent_structure_version_id,
4925: pppa.task_weight_basis_code,
4926: ppe.baseline_start_date,
4927: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
4928: ppru.object_id,
4929: ppe.proj_element_id,
4930: ppru.as_of_date,
4931: ppv.parent_structure_version_id,
4947: ,ppe.wf_process
4948: ,ppe.wf_start_lead_days
4949: ,ppe.enable_wf_flag
4950: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4951: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4952: , ppru.ppl_etc_cost_pc
4953: , ppru.eqpmt_etc_cost_pc
4954: , ppru.oth_etc_cost_pc
4955: , ppru.subprj_ppl_etc_cost_pc
4955: , ppru.subprj_ppl_etc_cost_pc
4956: , ppru.subprj_eqpmt_etc_cost_pc
4957: , ppru.subprj_oth_etc_cost_pc
4958: , null
4959: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
4960: , ppru.eqpmt_act_cost_to_date_pc
4961: , ppru.oth_act_cost_to_date_pc
4962: , ppru.subprj_ppl_act_cost_pc
4963: , ppru.subprj_eqpmt_act_cost_pc
5426: ,decode(pt.receive_project_invoice_flag,'Y',l_yes,l_no)
5427: ,pt.receive_project_invoice_flag
5428: ,pt.start_date
5429: ,pt.completion_date
5430: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
5431: ,ppvsch.last_update_date
5432: ,to_date(NULL)
5433: ,ppa.BASELINE_AS_OF_DATE
5434: ,ppru.LAST_UPDATE_DATE
5454: ,ppe.STATUS_CODE
5455: ,pps3.PROJECT_STATUS_NAME
5456: ,ppe5.phase_code
5457: ,pps5.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)
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
5488: , ppru.eqpmt_act_effort_to_date
5489: , null
5490: , null
5526: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
5527: ,pfxat.prj_raw_cost raw_cost
5528: ,pfxat.prj_brdn_cost burdened_cost
5529: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
5530: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
5531: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
5532: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
5533: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
5534: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
5530: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
5531: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
5532: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
5533: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
5534: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
5535: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5536: ) percent_Spent_Effort
5537: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
5538: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
5533: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
5534: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
5535: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5536: ) percent_Spent_Effort
5537: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
5538: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
5539: nvl(pfxat.prj_brdn_cost,0)
5540: ) percent_Spent_Cost
5541: -- Begin Bug # 4546322
5538: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
5539: nvl(pfxat.prj_brdn_cost,0)
5540: ) percent_Spent_Cost
5541: -- Begin Bug # 4546322
5542: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
5543: , ppru.eqpmt_act_effort_to_date
5544: , null
5545: , null
5546: , null
5544: , null
5545: , null
5546: , null
5547: , null)
5548: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
5549: , pfxat.equipment_hours
5550: , null)
5551: , ppru.estimated_remaining_effort
5552: , ppru.eqpmt_etc_effort
5554: , null
5555: , null
5556: , null
5557: , null
5558: , pa_progress_utils.calc_act
5559: (ppru.ppl_act_effort_to_date
5560: , ppru.eqpmt_act_effort_to_date
5561: , null
5562: , null
5561: , null
5562: , null
5563: , null
5564: , null))) Percent_Complete_Effort
5565: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
5566: , ppru.eqpmt_act_cost_to_date_pc
5567: , ppru.oth_act_cost_to_date_pc
5568: , null
5569: , null
5567: , ppru.oth_act_cost_to_date_pc
5568: , null
5569: , null
5570: , null)
5571: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
5572: , ppru.ppl_etc_cost_pc
5573: , ppru.eqpmt_etc_cost_pc
5574: , ppru.oth_etc_cost_pc
5575: , null
5575: , null
5576: , null
5577: , null
5578: , null
5579: , pa_progress_utils.calc_act
5580: (ppru.ppl_act_cost_to_date_pc
5581: , ppru.eqpmt_act_cost_to_date_pc
5582: , ppru.oth_act_cost_to_date_pc
5583: , null
5606: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
5607: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
5608: ,to_number ( null ) Planned_Baseline_Start
5609: ,to_number ( null ) Planned_Baseline_Finish
5610: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
5611: -- Fix for Bug # 4319171.
5612: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
5613: , ppru.estimated_remaining_effort
5614: , ppru.eqpmt_etc_effort
5608: ,to_number ( null ) Planned_Baseline_Start
5609: ,to_number ( null ) Planned_Baseline_Finish
5610: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
5611: -- Fix for Bug # 4319171.
5612: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
5613: , ppru.estimated_remaining_effort
5614: , ppru.eqpmt_etc_effort
5615: , null
5616: , ppru.subprj_ppl_etc_effort
5616: , ppru.subprj_ppl_etc_effort
5617: , ppru.subprj_eqpmt_etc_effort
5618: , null
5619: , null
5620: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
5621: , ppru.eqpmt_act_effort_to_date
5622: , null
5623: , ppru.subprj_ppl_act_effort
5624: , ppru.subprj_eqpmt_act_effort
5624: , ppru.subprj_eqpmt_act_effort
5625: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
5626: ,(nvl(ppru.ppl_act_effort_to_date,0)
5627: +nvl(ppru.eqpmt_act_effort_to_date,0)
5628: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5629: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
5630: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
5631: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
5632: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
5632: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
5633: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
5634: -(nvl(ppru.ppl_act_effort_to_date,0)
5635: +nvl(ppru.eqpmt_act_effort_to_date,0)
5636: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5637: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
5638: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
5639: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
5640: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
5641: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
5642: nvl(ppru.eqpmt_act_effort_to_date,0)))
5643: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
5644: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
5645: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
5646: , ppru.eqpmt_act_cost_to_date_pc
5647: , ppru.oth_act_cost_to_date_pc
5648: , null
5649: , null
5651: ,pfxat.prj_base_brdn_cost baseline_cost
5652: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
5653: +nvl(ppru.ppl_act_cost_to_date_pc,0)
5654: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
5655: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
5656: ,ppru.ppl_etc_cost_pc
5657: ,ppru.eqpmt_etc_cost_pc
5658: ,ppru.oth_etc_cost_pc
5659: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
5674: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
5675: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
5676: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
5677: ,ppru.earned_value Earned_Value
5678: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
5679: ppru.object_id,
5680: ppv.proj_element_id,
5681: ppru.as_of_date,
5682: ppv.parent_structure_version_id,
5685: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
5686: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
5687: NVL(ppru.ppl_act_cost_to_date_pc,0)+
5688: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
5689: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
5690: ppru.object_id,
5691: ppe.proj_element_id,
5692: ppru.as_of_date,
5693: ppv.parent_structure_version_id,
5697: ,((nvl(pfxat.prj_base_brdn_cost,0))
5698: -(nvl(ppru.oth_act_cost_to_date_pc,0)
5699: +nvl(ppru.ppl_act_cost_to_date_pc,0)
5700: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
5701: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
5702: ,ppru.ppl_etc_cost_pc
5703: ,ppru.eqpmt_etc_cost_pc
5704: ,ppru.oth_etc_cost_pc
5705: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
5734: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
5735: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
5736: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
5737: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index*/
5738: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
5739: ppru.object_id,
5740: ppe.proj_element_id,
5741: ppru.as_of_date,
5742: ppv.parent_structure_version_id,
5742: ppv.parent_structure_version_id,
5743: pppa.task_weight_basis_code,
5744: ppe.baseline_start_date,
5745: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
5746: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
5747: ppru.object_id,
5748: ppe.proj_element_id,
5749: ppru.as_of_date,
5750: ppv.parent_structure_version_id,
5749: ppru.as_of_date,
5750: ppv.parent_structure_version_id,
5751: pppa.task_weight_basis_code,
5752: ppe.baseline_start_date,
5753: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
5754: ppru.object_id,
5755: ppe.proj_element_id,
5756: ppru.as_of_date,
5757: ppv.parent_structure_version_id,
5773: ,ppe.wf_process
5774: ,ppe.wf_start_lead_days
5775: ,ppe.enable_wf_flag
5776: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
5777: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
5778: , ppru.ppl_etc_cost_pc
5779: , ppru.eqpmt_etc_cost_pc
5780: , ppru.oth_etc_cost_pc
5781: , ppru.subprj_ppl_etc_cost_pc
5781: , ppru.subprj_ppl_etc_cost_pc
5782: , ppru.subprj_eqpmt_etc_cost_pc
5783: , ppru.subprj_oth_etc_cost_pc
5784: , null
5785: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
5786: , ppru.eqpmt_act_cost_to_date_pc
5787: , ppru.oth_act_cost_to_date_pc
5788: , ppru.subprj_ppl_act_cost_pc
5789: , ppru.subprj_eqpmt_act_cost_pc
6419: ,to_char(null)
6420: ,to_char(null)
6421: ,to_date(null)
6422: ,to_date(null)
6423: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
6424: ,ppvsch.last_update_date
6425: ,to_date(NULL)
6426: ,ppa.BASELINE_AS_OF_DATE
6427: ,ppru.LAST_UPDATE_DATE
6440: ,ppe.STATUS_CODE
6441: ,to_char(null)
6442: ,to_char(null)
6443: ,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)
6468: ,to_char(null)
6469: ,to_char(null)
6470: ,to_char(null)
6471: ,to_char(null)
6472: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
6473: , ppru.ppl_act_effort_to_date
6474: , ppru.eqpmt_act_effort_to_date
6475: , null
6476: , null
6511: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6512: ,pfxat.prj_raw_cost raw_cost
6513: ,pfxat.prj_brdn_cost burdened_cost
6514: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
6515: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
6516: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
6517: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
6518: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
6519: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6515: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
6516: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
6517: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
6518: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
6519: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6520: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
6521: ) percent_Spent_Effort
6522: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
6523: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
6518: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
6519: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6520: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
6521: ) percent_Spent_Effort
6522: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
6523: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
6524: nvl(pfxat.prj_brdn_cost,0)
6525: ) percent_Spent_Cost
6526: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6522: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
6523: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
6524: nvl(pfxat.prj_brdn_cost,0)
6525: ) percent_Spent_Cost
6526: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6527: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
6528: ) Percent_Complete_Effort
6529: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
6530: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
6525: ) percent_Spent_Cost
6526: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6527: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
6528: ) Percent_Complete_Effort
6529: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
6530: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
6552: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
6553: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
6554: ,to_number ( null ) Planned_Baseline_Start
6555: ,to_number ( null ) Planned_Baseline_Finish
6556: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
6557: -- Fix for Bug # 4319171.
6558: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
6559: , ppru.ppl_act_effort_to_date
6560: , ppru.eqpmt_act_effort_to_date
6554: ,to_number ( null ) Planned_Baseline_Start
6555: ,to_number ( null ) Planned_Baseline_Finish
6556: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
6557: -- Fix for Bug # 4319171.
6558: ,pa_progress_utils.calc_wetc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
6559: , ppru.ppl_act_effort_to_date
6560: , ppru.eqpmt_act_effort_to_date
6561: , null
6562: , null
6564: , null
6565: , null) etc_effort -- Fix for Bug # 4319171.
6566: ,(nvl(ppru.ppl_act_effort_to_date,0)
6567: +nvl(ppru.eqpmt_act_effort_to_date,0)
6568: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)
6569: +nvl(pfxat.equipment_hours,0))
6570: ,ppru.estimated_remaining_effort
6571: ,ppru.eqpmt_etc_effort,null
6572: ,ppru.subprj_ppl_etc_effort
6580: ,'WORKING')) Estimate_At_Completion_Effort -- Fix for Bug # 4485364.
6581: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
6582: -(nvl(ppru.ppl_act_effort_to_date,0)
6583: +nvl(ppru.eqpmt_act_effort_to_date,0)
6584: +PA_PROGRESS_UTILS.derive_etc_values((NVL(pfxat.labor_hours,0)+NVL(pfxat.equipment_hours,0))
6585: ,ppru.ppl_act_effort_to_date
6586: ,ppru.eqpmt_act_effort_to_date
6587: ,null,null,null,null,null))) Variance_At_Completion_Effort
6588: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)))
6587: ,null,null,null,null,null))) Variance_At_Completion_Effort
6588: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)))
6589: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
6590: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
6591: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
6592: , ppru.eqpmt_act_cost_to_date_pc
6593: , ppru.oth_act_cost_to_date_pc
6594: , null
6595: , null
6597: ,pfxat.prj_base_brdn_cost baseline_cost
6598: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
6599: +nvl(ppru.ppl_act_cost_to_date_pc,0)
6600: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
6601: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
6602: ,ppru.ppl_etc_cost_pc
6603: ,ppru.eqpmt_etc_cost_pc
6604: ,ppru.oth_etc_cost_pc
6605: ,ppru.subprj_ppl_etc_cost_pc
6624: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
6625: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
6626: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
6627: ,ppru.earned_value Earned_Value
6628: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
6629: ppru.object_id,
6630: ppv1.proj_element_id,
6631: ppru.as_of_date,
6632: ppv1.parent_structure_version_id,
6634: ppe.baseline_start_date,
6635: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
6636: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
6637: NVL(ppru.ppl_act_cost_to_date_pc,0)+NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
6638: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
6639: ppru.object_id,
6640: ppe.proj_element_id,
6641: ppru.as_of_date,
6642: ppv1.parent_structure_version_id,
6646: ,((nvl(pfxat.prj_base_brdn_cost,0))
6647: -(nvl(ppru.oth_act_cost_to_date_pc,0)
6648: +nvl(ppru.ppl_act_cost_to_date_pc,0)
6649: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
6650: +PA_PROGRESS_UTILS.derive_etc_values(pfxat.prj_brdn_cost
6651: ,ppru.ppl_act_cost_to_date_pc
6652: ,ppru.eqpmt_act_cost_to_date_pc
6653: ,ppru.oth_act_cost_to_date_pc
6654: ,null,null,null,null))) Variance_At_Completion_Cost
6680: /*Computation of Cost Value ends here*/
6681: ) -- End of Decode Before Round
6682: ,2)
6683: To_Complete_Performance_Index
6684: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
6685: ppru.object_id,
6686: ppe.proj_element_id,
6687: ppru.as_of_date,
6688: ppv1.parent_structure_version_id,
6688: ppv1.parent_structure_version_id,
6689: pppa.task_weight_basis_code,
6690: ppe.baseline_start_date,
6691: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
6692: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
6693: ppru.object_id,
6694: ppe.proj_element_id,
6695: ppru.as_of_date,
6696: ppv1.parent_structure_version_id,
6695: ppru.as_of_date,
6696: ppv1.parent_structure_version_id,
6697: pppa.task_weight_basis_code,
6698: ppe.baseline_start_date,
6699: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
6700: ppru.object_id,
6701: ppe.proj_element_id,
6702: ppru.as_of_date,
6703: ppv1.parent_structure_version_id,
6717: ,ppe.wf_process
6718: ,ppe.wf_start_lead_days
6719: ,ppe.enable_wf_flag
6720: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
6721: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
6722: , ppru.ppl_etc_cost_pc
6723: , ppru.eqpmt_etc_cost_pc
6724: , ppru.oth_etc_cost_pc
6725: , ppru.subprj_ppl_etc_cost_pc
6725: , ppru.subprj_ppl_etc_cost_pc
6726: , ppru.subprj_eqpmt_etc_cost_pc
6727: , ppru.subprj_oth_etc_cost_pc
6728: , null
6729: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
6730: , ppru.eqpmt_act_cost_to_date_pc
6731: , ppru.oth_act_cost_to_date_pc
6732: , ppru.subprj_ppl_act_cost_pc
6733: , ppru.subprj_eqpmt_act_cost_pc
6896: ,to_char(null)
6897: ,to_char(null)
6898: ,to_date(null)
6899: ,to_date(null)
6900: ,PA_PROGRESS_UTILS.GET_PRIOR_PERCENT_COMPLETE(ppa.project_id,ppe.proj_element_id,ppru.as_of_date)
6901: ,ppvsch.last_update_date
6902: ,to_date(NULL)
6903: ,ppa.BASELINE_AS_OF_DATE
6904: ,ppru.LAST_UPDATE_DATE
6917: ,ppe.STATUS_CODE
6918: ,to_char(null)
6919: ,to_char(null)
6920: ,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)
6945: ,to_char(null)
6946: ,to_char(null)
6947: ,to_char(null)
6948: ,to_char(null)
6949: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
6950: , ppru.estimated_remaining_effort
6951: , ppru.eqpmt_etc_effort
6952: , null
6953: , ppru.subprj_ppl_etc_effort
6953: , ppru.subprj_ppl_etc_effort
6954: , ppru.subprj_eqpmt_etc_effort
6955: , null
6956: , null
6957: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
6958: , ppru.eqpmt_act_effort_to_date
6959: , null
6960: , ppru.subprj_ppl_act_effort
6961: , ppru.subprj_eqpmt_act_effort
6995: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6996: ,pfxat.prj_raw_cost raw_cost
6997: ,pfxat.prj_brdn_cost burdened_cost
6998: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
6999: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
7000: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
7001: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
7002: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
7003: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6999: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
7000: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
7001: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
7002: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
7003: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7004: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7005: ) percent_Spent_Effort
7006: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7007: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7002: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
7003: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7004: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7005: ) percent_Spent_Effort
7006: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7007: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7008: nvl(pfxat.prj_brdn_cost,0)
7009: ) percent_Spent_Cost
7010: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7006: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7007: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7008: nvl(pfxat.prj_brdn_cost,0)
7009: ) percent_Spent_Cost
7010: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7011: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
7012: ) Percent_Complete_Effort
7013: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7014: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7009: ) percent_Spent_Cost
7010: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7011: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
7012: ) Percent_Complete_Effort
7013: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7014: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
7036: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
7037: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
7038: ,to_number ( null ) Planned_Baseline_Start
7039: ,to_number ( null ) Planned_Baseline_Finish
7040: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
7041: -- Fix for Bug # 4319171.
7042: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
7043: , ppru.estimated_remaining_effort
7044: , ppru.eqpmt_etc_effort
7038: ,to_number ( null ) Planned_Baseline_Start
7039: ,to_number ( null ) Planned_Baseline_Finish
7040: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
7041: -- Fix for Bug # 4319171.
7042: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
7043: , ppru.estimated_remaining_effort
7044: , ppru.eqpmt_etc_effort
7045: , null
7046: , ppru.subprj_ppl_etc_effort
7046: , ppru.subprj_ppl_etc_effort
7047: , ppru.subprj_eqpmt_etc_effort
7048: , null
7049: , null
7050: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
7051: , ppru.eqpmt_act_effort_to_date
7052: , null
7053: , ppru.subprj_ppl_act_effort
7054: , ppru.subprj_eqpmt_act_effort
7054: , ppru.subprj_eqpmt_act_effort
7055: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
7056: ,(nvl(ppru.ppl_act_effort_to_date,0)
7057: +nvl(ppru.eqpmt_act_effort_to_date,0)
7058: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)
7059: +nvl(pfxat.equipment_hours,0))
7060: ,ppru.estimated_remaining_effort
7061: ,ppru.eqpmt_etc_effort,null
7062: ,ppru.subprj_ppl_etc_effort
7070: ,'PUBLISH')) Estimate_At_Completion_Effort -- Fix for Bug # 4485364.
7071: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
7072: -(nvl(ppru.ppl_act_effort_to_date,0)
7073: +nvl(ppru.eqpmt_act_effort_to_date,0)
7074: +PA_PROGRESS_UTILS.derive_etc_values((NVL(pfxat.labor_hours,0)+NVL(pfxat.equipment_hours,0))
7075: ,ppru.ppl_act_effort_to_date
7076: ,ppru.eqpmt_act_effort_to_date
7077: ,null,null,null,null,null))) Variance_At_Completion_Effort
7078: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)))
7077: ,null,null,null,null,null))) Variance_At_Completion_Effort
7078: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)))
7079: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
7080: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
7081: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
7082: , ppru.eqpmt_act_cost_to_date_pc
7083: , ppru.oth_act_cost_to_date_pc
7084: , null
7085: , null
7087: ,pfxat.prj_base_brdn_cost baseline_cost
7088: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
7089: +nvl(ppru.ppl_act_cost_to_date_pc,0)
7090: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
7091: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
7092: ,ppru.ppl_etc_cost_pc
7093: ,ppru.eqpmt_etc_cost_pc
7094: ,ppru.oth_etc_cost_pc
7095: ,ppru.subprj_ppl_etc_cost_pc
7114: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
7115: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
7116: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
7117: ,ppru.earned_value Earned_Value
7118: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
7119: ppru.object_id,
7120: ppv1.proj_element_id,
7121: ppru.as_of_date,
7122: ppv1.parent_structure_version_id,
7124: ppe.baseline_start_date,
7125: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
7126: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7127: NVL(ppru.ppl_act_cost_to_date_pc,0)+NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
7128: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
7129: ppru.object_id,
7130: ppe.proj_element_id,
7131: ppru.as_of_date,
7132: ppv1.parent_structure_version_id,
7136: ,((nvl(pfxat.prj_base_brdn_cost,0))
7137: -(nvl(ppru.oth_act_cost_to_date_pc,0)
7138: +nvl(ppru.ppl_act_cost_to_date_pc,0)
7139: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
7140: +PA_PROGRESS_UTILS.derive_etc_values(pfxat.prj_brdn_cost
7141: ,ppru.ppl_act_cost_to_date_pc
7142: ,ppru.eqpmt_act_cost_to_date_pc
7143: ,ppru.oth_act_cost_to_date_pc
7144: ,null,null,null,null))) Variance_At_Completion_Cost
7170: /*Computation of Cost Value ends here*/
7171: ) -- End of Decode Before Round
7172: ,2)
7173: To_Complete_Performance_Index
7174: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
7175: ppru.object_id,
7176: ppe.proj_element_id,
7177: ppru.as_of_date,
7178: ppv1.parent_structure_version_id,
7178: ppv1.parent_structure_version_id,
7179: pppa.task_weight_basis_code,
7180: ppe.baseline_start_date,
7181: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
7182: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
7183: ppru.object_id,
7184: ppe.proj_element_id,
7185: ppru.as_of_date,
7186: ppv1.parent_structure_version_id,
7185: ppru.as_of_date,
7186: ppv1.parent_structure_version_id,
7187: pppa.task_weight_basis_code,
7188: ppe.baseline_start_date,
7189: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,nvl(pa_progress_utils.get_bcws(ppa.project_id,
7190: ppru.object_id,
7191: ppe.proj_element_id,
7192: ppru.as_of_date,
7193: ppv1.parent_structure_version_id,
7207: ,ppe.wf_process
7208: ,ppe.wf_start_lead_days
7209: ,ppe.enable_wf_flag
7210: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
7211: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
7212: , ppru.ppl_etc_cost_pc
7213: , ppru.eqpmt_etc_cost_pc
7214: , ppru.oth_etc_cost_pc
7215: , ppru.subprj_ppl_etc_cost_pc
7215: , ppru.subprj_ppl_etc_cost_pc
7216: , ppru.subprj_eqpmt_etc_cost_pc
7217: , ppru.subprj_oth_etc_cost_pc
7218: , null
7219: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
7220: , ppru.eqpmt_act_cost_to_date_pc
7221: , ppru.oth_act_cost_to_date_pc
7222: , ppru.subprj_ppl_act_cost_pc
7223: , ppru.subprj_eqpmt_act_cost_pc
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)
7816: ,ppvsch.last_update_date
7817: ,to_date(NULL)
7818: ,ppa.BASELINE_AS_OF_DATE
7819: ,ppru.LAST_UPDATE_DATE
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
7866: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
7867: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
7868: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) estimated_remaining_effort
7904: ,null --NVL(pfxat.prj_brdn_cost,0)
7905: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
7906: ,NVL(ppru.eqpmt_act_effort_to_date,0)
7907: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
7908: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7909: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7910: -- ) percent_Spent_Effort
7911: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7912: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7907: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
7908: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7909: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7910: -- ) percent_Spent_Effort
7911: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7912: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7913: -- nvl(pfxat.prj_brdn_cost,0)
7914: -- ) percent_Spent_Cost
7915: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7911: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7912: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7913: -- nvl(pfxat.prj_brdn_cost,0)
7914: -- ) percent_Spent_Cost
7915: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7916: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
7917: ) Percent_Complete_Effort
7918: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7919: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7914: -- ) percent_Spent_Cost
7915: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7916: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
7917: ) Percent_Complete_Effort
7918: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
7919: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
7942: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
7943: ,to_number ( null ) Planned_Baseline_Start
7944: ,to_number ( null ) Planned_Baseline_Finish
7945: ,null --NVL(pfxat.base_equip_hours,0) + NVL(pfxat.base_labor_hours,0) Baseline_effort
7946: ,null --pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7947: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
7948: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
7949: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
7950: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) ETC_EFFORT
7949: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
7950: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) ETC_EFFORT
7951: ,null --nvl(ppru.ppl_act_effort_to_date,0)
7952: --+nvl(ppru.eqpmt_act_effort_to_date,0)
7953: --+pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7954: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
7955: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
7956: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
7957: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
7957: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) Estimate_At_Completion_Effort
7958: ,null --nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)
7959: -- -(nvl(ppru.ppl_act_effort_to_date,0)
7960: --+nvl(ppru.eqpmt_act_effort_to_date,0)
7961: --+pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7962: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
7963: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
7964: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
7965: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING'))) Variance_At_Completion_Effort
7973: ,null --pfxat.prj_base_brdn_cost
7974: ,null --nvl(ppru.oth_act_cost_to_date_pc,0)
7975: --+nvl(ppru.ppl_act_cost_to_date_pc,0)
7976: --+nvl(ppru.eqpmt_act_cost_to_date_pc,0)
7977: --+pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
7978: -- ,ppru.ppl_etc_cost_pc
7979: -- ,ppru.eqpmt_etc_cost_pc
7980: -- ,ppru.oth_etc_cost_pc
7981: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
8005: ,null --((nvl(pfxat.prj_base_brdn_cost,0))
8006: -- -(nvl(ppru.oth_act_cost_to_date_pc,0)
8007: --+nvl(ppru.ppl_act_cost_to_date_pc,0)
8008: --+nvl(ppru.eqpmt_act_cost_to_date_pc,0)
8009: --+pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8010: -- ,ppru.ppl_etc_cost_pc
8011: -- ,ppru.eqpmt_etc_cost_pc
8012: -- ,ppru.oth_etc_cost_pc
8013: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
8037: ,ppe.wf_process
8038: ,ppe.wf_start_lead_days
8039: ,ppe.enable_wf_flag
8040: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
8041: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8042: -- ,ppru.ppl_etc_cost_pc
8043: -- ,ppru.eqpmt_etc_cost_pc
8044: -- ,ppru.oth_etc_cost_pc
8045: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
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)
8576: ,ppvsch.last_update_date
8577: ,to_date(NULL)
8578: ,ppa.BASELINE_AS_OF_DATE
8579: ,ppru.LAST_UPDATE_DATE
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
8626: -- ,ppru.eqpmt_act_effort_to_date
8627: -- ,null,null,null,null,null) estimated_remaining_effort
8628: -- ,PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
8663: ,null --NVL(pfxat.prj_brdn_cost,0)
8664: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
8665: ,NVL(ppru.eqpmt_act_effort_to_date,0)
8666: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
8667: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8668: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8669: -- ) percent_Spent_Effort
8670: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8671: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8666: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
8667: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8668: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8669: -- ) percent_Spent_Effort
8670: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8671: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8672: -- nvl(pfxat.prj_brdn_cost,0)
8673: -- ) percent_Spent_Cost
8674: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8670: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8671: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8672: -- nvl(pfxat.prj_brdn_cost,0)
8673: -- ) percent_Spent_Cost
8674: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8675: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
8676: ) Percent_Complete_Effort
8677: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8678: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8673: -- ) percent_Spent_Cost
8674: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8675: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
8676: ) Percent_Complete_Effort
8677: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8678: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
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
8701: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
8702: ,to_number ( null ) Planned_Baseline_Start
8703: ,to_number ( null ) Planned_Baseline_Finish
8704: ,null --NVL(pfxat.base_equip_hours,0) + NVL(pfxat.base_labor_hours,0) Baseline_effort
8705: ,null --pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8706: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
8707: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
8708: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
8709: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING') ETC_EFFORT
8708: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
8709: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING') ETC_EFFORT
8710: ,null --(nvl(ppru.ppl_act_effort_to_date,0)
8711: --+nvl(ppru.eqpmt_act_effort_to_date,0)
8712: --+pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8713: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
8714: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
8715: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
8716: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
8716: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
8717: ,null --((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
8718: -- -(nvl(ppru.ppl_act_effort_to_date,0)
8719: --+nvl(ppru.eqpmt_act_effort_to_date,0)
8720: --+pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8721: -- ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
8722: -- ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
8723: -- ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
8724: -- +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
8732: ,null --pfxat.prj_base_brdn_cost
8733: ,null --(nvl(ppru.oth_act_cost_to_date_pc,0)
8734: --+nvl(ppru.ppl_act_cost_to_date_pc,0)
8735: --+nvl(ppru.eqpmt_act_cost_to_date_pc,0)
8736: --+pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8737: -- ,ppru.ppl_etc_cost_pc
8738: -- ,ppru.eqpmt_etc_cost_pc
8739: -- ,ppru.oth_etc_cost_pc
8740: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
8764: ,null --((nvl(pfxat.prj_base_brdn_cost,0))
8765: -- -(nvl(ppru.oth_act_cost_to_date_pc,0)
8766: --+nvl(ppru.ppl_act_cost_to_date_pc,0)
8767: --+nvl(ppru.eqpmt_act_cost_to_date_pc,0)
8768: --+pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8769: -- ,ppru.ppl_etc_cost_pc
8770: -- ,ppru.eqpmt_etc_cost_pc
8771: -- ,ppru.oth_etc_cost_pc
8772: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
8797: ,ppe.wf_process
8798: ,ppe.wf_start_lead_days
8799: ,ppe.enable_wf_flag
8800: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
8801: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8802: -- ,ppru.ppl_etc_cost_pc
8803: -- ,ppru.eqpmt_etc_cost_pc
8804: -- ,ppru.oth_etc_cost_pc
8805: -- ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
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)
9379: ,to_date(null) -- not needed in VO ppvsch.last_update_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
9397: ,ppe.STATUS_CODE
9398: ,null -- Populating Task Status Name as NULL
9399: ,ppe.phase_code
9400: ,pps5.project_status_name
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)
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
9433: , ppru.eqpmt_etc_effort
9434: , null
9435: , ppru.subprj_ppl_etc_effort
9435: , ppru.subprj_ppl_etc_effort
9436: , ppru.subprj_eqpmt_etc_effort
9437: , null
9438: , null
9439: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
9440: , ppru.eqpmt_act_effort_to_date
9441: , null
9442: , ppru.subprj_ppl_act_effort
9443: , ppru.subprj_eqpmt_act_effort
9473: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
9474: ,pfxat.prj_raw_cost raw_cost
9475: ,pfxat.prj_brdn_cost burdened_cost
9476: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
9477: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
9478: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
9479: Actual_Effort -- Fix for Bug # 4319171.
9480: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
9481: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
9478: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
9479: Actual_Effort -- Fix for Bug # 4319171.
9480: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
9481: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
9482: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
9483: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9484: ) percent_Spent_Effort
9485: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
9486: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
9481: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
9482: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
9483: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9484: ) percent_Spent_Effort
9485: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
9486: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
9487: nvl(pfxat.prj_brdn_cost,0)
9488: ) percent_Spent_Cost
9489: -- Begin Bug # 4546322
9486: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
9487: nvl(pfxat.prj_brdn_cost,0)
9488: ) percent_Spent_Cost
9489: -- Begin Bug # 4546322
9490: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
9491: , ppru.eqpmt_act_effort_to_date
9492: , null
9493: , null
9494: , null
9492: , null
9493: , null
9494: , null
9495: , null)
9496: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
9497: , pfxat.equipment_hours
9498: , null)
9499: , ppru.estimated_remaining_effort
9500: , ppru.eqpmt_etc_effort
9502: , null
9503: , null
9504: , null
9505: , null
9506: , pa_progress_utils.calc_act
9507: (ppru.ppl_act_effort_to_date
9508: , ppru.eqpmt_act_effort_to_date
9509: , null
9510: , null
9509: , null
9510: , null
9511: , null
9512: , null))) Percent_Complete_Effort
9513: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
9514: , ppru.eqpmt_act_cost_to_date_pc
9515: , ppru.oth_act_cost_to_date_pc
9516: , null
9517: , null
9515: , ppru.oth_act_cost_to_date_pc
9516: , null
9517: , null
9518: , null)
9519: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
9520: , ppru.ppl_etc_cost_pc
9521: , ppru.eqpmt_etc_cost_pc
9522: , ppru.oth_etc_cost_pc
9523: , null
9523: , null
9524: , null
9525: , null
9526: , null
9527: , pa_progress_utils.calc_act
9528: (ppru.ppl_act_cost_to_date_pc
9529: , ppru.eqpmt_act_cost_to_date_pc
9530: , ppru.oth_act_cost_to_date_pc
9531: , null
9552: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
9553: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
9554: ,to_number ( null ) Planned_Baseline_Start
9555: ,to_number ( null ) Planned_Baseline_Finish
9556: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
9557: -- Fix for Bug # 4319171.
9558: ----------------------------------------------------------------------------------
9559: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
9560: , ppru.estimated_remaining_effort
9555: ,to_number ( null ) Planned_Baseline_Finish
9556: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
9557: -- Fix for Bug # 4319171.
9558: ----------------------------------------------------------------------------------
9559: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
9560: , ppru.estimated_remaining_effort
9561: , ppru.eqpmt_etc_effort
9562: , null
9563: , ppru.subprj_ppl_etc_effort
9563: , ppru.subprj_ppl_etc_effort
9564: , ppru.subprj_eqpmt_etc_effort
9565: , null
9566: , null
9567: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
9568: , ppru.eqpmt_act_effort_to_date
9569: , null
9570: , ppru.subprj_ppl_act_effort
9571: , ppru.subprj_eqpmt_act_effort
9571: , ppru.subprj_eqpmt_act_effort
9572: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
9573: ,(nvl(ppru.ppl_act_effort_to_date,0)
9574: +nvl(ppru.eqpmt_act_effort_to_date,0)
9575: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9576: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
9577: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
9578: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
9579: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
9579: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
9580: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
9581: -(nvl(ppru.ppl_act_effort_to_date,0)
9582: +nvl(ppru.eqpmt_act_effort_to_date,0)
9583: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9584: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
9585: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
9586: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
9587: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
9588: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
9589: nvl(ppru.eqpmt_act_effort_to_date,0)))
9590: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
9591: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
9592: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
9593: , ppru.eqpmt_act_cost_to_date_pc
9594: , ppru.oth_act_cost_to_date_pc
9595: , null
9596: , null
9598: ,pfxat.prj_base_brdn_cost baseline_cost
9599: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
9600: +nvl(ppru.ppl_act_cost_to_date_pc,0)
9601: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
9602: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
9603: ,ppru.ppl_etc_cost_pc
9604: ,ppru.eqpmt_etc_cost_pc
9605: ,ppru.oth_etc_cost_pc
9606: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
9622: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
9623: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
9624: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
9625: ,ppru.earned_value Earned_Value
9626: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
9627: ppru.object_id,
9628: ppv.proj_element_id,
9629: ppru.as_of_date,
9630: ppv.parent_structure_version_id,
9636: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
9637: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
9638: NVL(ppru.ppl_act_cost_to_date_pc,0)+
9639: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
9640: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
9641: ppru.object_id,
9642: ppe.proj_element_id,
9643: ppru.as_of_date,
9644: ppv.parent_structure_version_id,
9651: ,((nvl(pfxat.prj_base_brdn_cost,0))
9652: -(nvl(ppru.oth_act_cost_to_date_pc,0)
9653: +nvl(ppru.ppl_act_cost_to_date_pc,0)
9654: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
9655: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
9656: ,ppru.ppl_etc_cost_pc
9657: ,ppru.eqpmt_etc_cost_pc
9658: ,ppru.oth_etc_cost_pc
9659: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
9690: /*Computation of Cost Value ends here*/
9691: ) -- End of Decode Before Round
9692: ,2)
9693: To_Complete_Performance_Index
9694: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
9695: ppru.object_id,
9696: ppe.proj_element_id,
9697: ppru.as_of_date,
9698: ppv.parent_structure_version_id,
9701: l_task_weight_basis_code,
9702: -- End of Bug Fix 56117760
9703: ppe.baseline_start_date,
9704: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
9705: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
9706: ppru.object_id,
9707: ppe.proj_element_id,
9708: ppru.as_of_date,
9709: ppv.parent_structure_version_id,
9712: l_task_weight_basis_code,
9713: -- End of Bug Fix 56117760
9714: ppe.baseline_start_date,
9715: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
9716: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
9717: ppe.proj_element_id,ppru.as_of_date,
9718: ppv.parent_structure_version_id,
9719: -- Bug Fix 56117760
9720: -- ppru.task_wt_basis_code,
9736: ,ppe.wf_process
9737: ,ppe.wf_start_lead_days
9738: ,ppe.enable_wf_flag
9739: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
9740: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
9741: , ppru.ppl_etc_cost_pc
9742: , ppru.eqpmt_etc_cost_pc
9743: , ppru.oth_etc_cost_pc
9744: , ppru.subprj_ppl_etc_cost_pc
9744: , ppru.subprj_ppl_etc_cost_pc
9745: , ppru.subprj_eqpmt_etc_cost_pc
9746: , ppru.subprj_oth_etc_cost_pc
9747: , null
9748: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
9749: , ppru.eqpmt_act_cost_to_date_pc
9750: , ppru.oth_act_cost_to_date_pc
9751: , ppru.subprj_ppl_act_cost_pc
9752: , ppru.subprj_eqpmt_act_cost_pc
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)
10206: ,to_date(null) -- not needed in VO ppvsch.last_update_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
10224: ,ppe.STATUS_CODE
10225: ,null -- Populating Task Status Name as NULL
10226: ,ppe.phase_code
10227: ,pps5.project_status_name
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)
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
10260: , ppru.eqpmt_etc_effort
10261: , null
10262: , ppru.subprj_ppl_etc_effort
10262: , ppru.subprj_ppl_etc_effort
10263: , ppru.subprj_eqpmt_etc_effort
10264: , null
10265: , null
10266: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
10267: , ppru.eqpmt_act_effort_to_date
10268: , null
10269: , ppru.subprj_ppl_act_effort
10270: , ppru.subprj_eqpmt_act_effort
10300: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
10301: ,pfxat.prj_raw_cost raw_cost
10302: ,pfxat.prj_brdn_cost burdened_cost
10303: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
10304: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
10305: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
10306: Actual_Effort -- Fix for Bug # 4319171.
10307: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
10308: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10305: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
10306: Actual_Effort -- Fix for Bug # 4319171.
10307: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
10308: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10309: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
10310: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10311: ) percent_Spent_Effort
10312: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
10313: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
10308: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10309: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
10310: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10311: ) percent_Spent_Effort
10312: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
10313: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
10314: nvl(pfxat.prj_brdn_cost,0)
10315: ) percent_Spent_Cost
10316: -- Begin Bug # 4546322
10313: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
10314: nvl(pfxat.prj_brdn_cost,0)
10315: ) percent_Spent_Cost
10316: -- Begin Bug # 4546322
10317: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
10318: , ppru.eqpmt_act_effort_to_date
10319: , null
10320: , null
10321: , null
10319: , null
10320: , null
10321: , null
10322: , null)
10323: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
10324: , pfxat.equipment_hours
10325: , null)
10326: , ppru.estimated_remaining_effort
10327: , ppru.eqpmt_etc_effort
10329: , null
10330: , null
10331: , null
10332: , null
10333: , pa_progress_utils.calc_act
10334: (ppru.ppl_act_effort_to_date
10335: , ppru.eqpmt_act_effort_to_date
10336: , null
10337: , null
10336: , null
10337: , null
10338: , null
10339: , null))) Percent_Complete_Effort
10340: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
10341: , ppru.eqpmt_act_cost_to_date_pc
10342: , ppru.oth_act_cost_to_date_pc
10343: , null
10344: , null
10342: , ppru.oth_act_cost_to_date_pc
10343: , null
10344: , null
10345: , null)
10346: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
10347: , ppru.ppl_etc_cost_pc
10348: , ppru.eqpmt_etc_cost_pc
10349: , ppru.oth_etc_cost_pc
10350: , null
10350: , null
10351: , null
10352: , null
10353: , null
10354: , pa_progress_utils.calc_act
10355: (ppru.ppl_act_cost_to_date_pc
10356: , ppru.eqpmt_act_cost_to_date_pc
10357: , ppru.oth_act_cost_to_date_pc
10358: , null
10379: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
10380: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
10381: ,to_number ( null ) Planned_Baseline_Start
10382: ,to_number ( null ) Planned_Baseline_Finish
10383: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
10384: -- Fix for Bug # 4319171.
10385: ----------------------------------------------------------------------------------
10386: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
10387: , ppru.estimated_remaining_effort
10382: ,to_number ( null ) Planned_Baseline_Finish
10383: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
10384: -- Fix for Bug # 4319171.
10385: ----------------------------------------------------------------------------------
10386: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
10387: , ppru.estimated_remaining_effort
10388: , ppru.eqpmt_etc_effort
10389: , null
10390: , ppru.subprj_ppl_etc_effort
10390: , ppru.subprj_ppl_etc_effort
10391: , ppru.subprj_eqpmt_etc_effort
10392: , null
10393: , null
10394: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
10395: , ppru.eqpmt_act_effort_to_date
10396: , null
10397: , ppru.subprj_ppl_act_effort
10398: , ppru.subprj_eqpmt_act_effort
10398: , ppru.subprj_eqpmt_act_effort
10399: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
10400: ,(nvl(ppru.ppl_act_effort_to_date,0)
10401: +nvl(ppru.eqpmt_act_effort_to_date,0)
10402: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10403: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
10404: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
10405: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
10406: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
10406: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
10407: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
10408: -(nvl(ppru.ppl_act_effort_to_date,0)
10409: +nvl(ppru.eqpmt_act_effort_to_date,0)
10410: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10411: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
10412: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
10413: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
10414: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
10415: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
10416: nvl(ppru.eqpmt_act_effort_to_date,0)))
10417: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
10418: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
10419: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
10420: , ppru.eqpmt_act_cost_to_date_pc
10421: , ppru.oth_act_cost_to_date_pc
10422: , null
10423: , null
10425: ,pfxat.prj_base_brdn_cost baseline_cost
10426: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
10427: +nvl(ppru.ppl_act_cost_to_date_pc,0)
10428: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
10429: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
10430: ,ppru.ppl_etc_cost_pc
10431: ,ppru.eqpmt_etc_cost_pc
10432: ,ppru.oth_etc_cost_pc
10433: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
10449: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
10450: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
10451: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
10452: ,ppru.earned_value Earned_Value
10453: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
10454: ppru.object_id,
10455: ppv.proj_element_id,
10456: ppru.as_of_date,
10457: ppv.parent_structure_version_id,
10463: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
10464: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
10465: NVL(ppru.ppl_act_cost_to_date_pc,0)+
10466: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
10467: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
10468: ppru.object_id,
10469: ppe.proj_element_id,
10470: ppru.as_of_date,
10471: ppv.parent_structure_version_id,
10478: ,((nvl(pfxat.prj_base_brdn_cost,0))
10479: -(nvl(ppru.oth_act_cost_to_date_pc,0)
10480: +nvl(ppru.ppl_act_cost_to_date_pc,0)
10481: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
10482: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
10483: ,ppru.ppl_etc_cost_pc
10484: ,ppru.eqpmt_etc_cost_pc
10485: ,ppru.oth_etc_cost_pc
10486: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
10517: /*Computation of Cost Value ends here*/
10518: ) -- End of Decode Before Round
10519: ,2)
10520: To_Complete_Performance_Index
10521: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
10522: ppru.object_id,
10523: ppe.proj_element_id,
10524: ppru.as_of_date,
10525: ppv.parent_structure_version_id,
10528: l_task_weight_basis_code,
10529: -- End of Bug Fix 56117760
10530: ppe.baseline_start_date,
10531: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
10532: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
10533: ppru.object_id,
10534: ppe.proj_element_id,
10535: ppru.as_of_date,
10536: ppv.parent_structure_version_id,
10539: l_task_weight_basis_code,
10540: -- End of Bug Fix 56117760
10541: ppe.baseline_start_date,
10542: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
10543: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
10544: ppe.proj_element_id,ppru.as_of_date,
10545: ppv.parent_structure_version_id,
10546: -- Bug Fix 56117760
10547: -- ppru.task_wt_basis_code,
10563: ,ppe.wf_process
10564: ,ppe.wf_start_lead_days
10565: ,ppe.enable_wf_flag
10566: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
10567: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
10568: , ppru.ppl_etc_cost_pc
10569: , ppru.eqpmt_etc_cost_pc
10570: , ppru.oth_etc_cost_pc
10571: , ppru.subprj_ppl_etc_cost_pc
10571: , ppru.subprj_ppl_etc_cost_pc
10572: , ppru.subprj_eqpmt_etc_cost_pc
10573: , ppru.subprj_oth_etc_cost_pc
10574: , null
10575: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
10576: , ppru.eqpmt_act_cost_to_date_pc
10577: , ppru.oth_act_cost_to_date_pc
10578: , ppru.subprj_ppl_act_cost_pc
10579: , ppru.subprj_eqpmt_act_cost_pc
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)
11034: ,to_date(null) -- not needed in VO ppvsch.last_update_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
11052: ,ppe.STATUS_CODE
11053: ,null -- Populating Task Status Name as NULL
11054: ,ppe.phase_code
11055: ,pps5.project_status_name
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)
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
11088: , ppru.eqpmt_etc_effort
11089: , null
11090: , ppru.subprj_ppl_etc_effort
11090: , ppru.subprj_ppl_etc_effort
11091: , ppru.subprj_eqpmt_etc_effort
11092: , null
11093: , null
11094: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
11095: , ppru.eqpmt_act_effort_to_date
11096: , null
11097: , ppru.subprj_ppl_act_effort
11098: , ppru.subprj_eqpmt_act_effort
11128: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
11129: ,pfxat.prj_raw_cost raw_cost
11130: ,pfxat.prj_brdn_cost burdened_cost
11131: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
11132: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
11133: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
11134: Actual_Effort -- Fix for Bug # 4319171.
11135: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
11136: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
11133: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
11134: Actual_Effort -- Fix for Bug # 4319171.
11135: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
11136: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
11137: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
11138: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11139: ) percent_Spent_Effort
11140: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
11141: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
11136: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
11137: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
11138: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11139: ) percent_Spent_Effort
11140: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
11141: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
11142: nvl(pfxat.prj_brdn_cost,0)
11143: ) percent_Spent_Cost
11144: -- Begin Bug # 4546322
11141: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
11142: nvl(pfxat.prj_brdn_cost,0)
11143: ) percent_Spent_Cost
11144: -- Begin Bug # 4546322
11145: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
11146: , ppru.eqpmt_act_effort_to_date
11147: , null
11148: , null
11149: , null
11147: , null
11148: , null
11149: , null
11150: , null)
11151: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours
11152: , pfxat.equipment_hours
11153: , null)
11154: , ppru.estimated_remaining_effort
11155: , ppru.eqpmt_etc_effort
11157: , null
11158: , null
11159: , null
11160: , null
11161: , pa_progress_utils.calc_act
11162: (ppru.ppl_act_effort_to_date
11163: , ppru.eqpmt_act_effort_to_date
11164: , null
11165: , null
11164: , null
11165: , null
11166: , null
11167: , null))) Percent_Complete_Effort
11168: ,PA_PROGRESS_UTILS.Percent_Complete_Value(pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
11169: , ppru.eqpmt_act_cost_to_date_pc
11170: , ppru.oth_act_cost_to_date_pc
11171: , null
11172: , null
11170: , ppru.oth_act_cost_to_date_pc
11171: , null
11172: , null
11173: , null)
11174: , pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
11175: , ppru.ppl_etc_cost_pc
11176: , ppru.eqpmt_etc_cost_pc
11177: , ppru.oth_etc_cost_pc
11178: , null
11178: , null
11179: , null
11180: , null
11181: , null
11182: , pa_progress_utils.calc_act
11183: (ppru.ppl_act_cost_to_date_pc
11184: , ppru.eqpmt_act_cost_to_date_pc
11185: , ppru.oth_act_cost_to_date_pc
11186: , null
11207: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
11208: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
11209: ,to_number ( null ) Planned_Baseline_Start
11210: ,to_number ( null ) Planned_Baseline_Finish
11211: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
11212: -- Fix for Bug # 4319171.
11213: ----------------------------------------------------------------------------------
11214: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
11215: , ppru.estimated_remaining_effort
11210: ,to_number ( null ) Planned_Baseline_Finish
11211: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
11212: -- Fix for Bug # 4319171.
11213: ----------------------------------------------------------------------------------
11214: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
11215: , ppru.estimated_remaining_effort
11216: , ppru.eqpmt_etc_effort
11217: , null
11218: , ppru.subprj_ppl_etc_effort
11218: , ppru.subprj_ppl_etc_effort
11219: , ppru.subprj_eqpmt_etc_effort
11220: , null
11221: , null
11222: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
11223: , ppru.eqpmt_act_effort_to_date
11224: , null
11225: , ppru.subprj_ppl_act_effort
11226: , ppru.subprj_eqpmt_act_effort
11226: , ppru.subprj_eqpmt_act_effort
11227: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
11228: ,(nvl(ppru.ppl_act_effort_to_date,0)
11229: +nvl(ppru.eqpmt_act_effort_to_date,0)
11230: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11231: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
11232: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
11233: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
11234: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
11234: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING')) Estimate_At_Completion_Effort
11235: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
11236: -(nvl(ppru.ppl_act_effort_to_date,0)
11237: +nvl(ppru.eqpmt_act_effort_to_date,0)
11238: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11239: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
11240: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
11241: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
11242: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'WORKING'))) Variance_At_Completion_Effort
11243: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
11244: nvl(ppru.eqpmt_act_effort_to_date,0)))
11245: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
11246: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
11247: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
11248: , ppru.eqpmt_act_cost_to_date_pc
11249: , ppru.oth_act_cost_to_date_pc
11250: , null
11251: , null
11253: ,pfxat.prj_base_brdn_cost baseline_cost
11254: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
11255: +nvl(ppru.ppl_act_cost_to_date_pc,0)
11256: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
11257: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
11258: ,ppru.ppl_etc_cost_pc
11259: ,ppru.eqpmt_etc_cost_pc
11260: ,ppru.oth_etc_cost_pc
11261: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
11277: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
11278: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
11279: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
11280: ,ppru.earned_value Earned_Value
11281: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
11282: ppru.object_id,
11283: ppv.proj_element_id,
11284: ppru.as_of_date,
11285: ppv.parent_structure_version_id,
11291: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
11292: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11293: NVL(ppru.ppl_act_cost_to_date_pc,0)+
11294: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
11295: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
11296: ppru.object_id,
11297: ppe.proj_element_id,
11298: ppru.as_of_date,
11299: ppv.parent_structure_version_id,
11306: ,((nvl(pfxat.prj_base_brdn_cost,0))
11307: -(nvl(ppru.oth_act_cost_to_date_pc,0)
11308: +nvl(ppru.ppl_act_cost_to_date_pc,0)
11309: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
11310: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
11311: ,ppru.ppl_etc_cost_pc
11312: ,ppru.eqpmt_etc_cost_pc
11313: ,ppru.oth_etc_cost_pc
11314: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
11345: /*Computation of Cost Value ends here*/
11346: ) -- End of Decode Before Round
11347: ,2)
11348: To_Complete_Performance_Index
11349: ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
11350: ppru.object_id,
11351: ppe.proj_element_id,
11352: ppru.as_of_date,
11353: ppv.parent_structure_version_id,
11356: l_task_weight_basis_code,
11357: -- End of Bug Fix 56117760
11358: ppe.baseline_start_date,
11359: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
11360: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
11361: ppru.object_id,
11362: ppe.proj_element_id,
11363: ppru.as_of_date,
11364: ppv.parent_structure_version_id,
11367: l_task_weight_basis_code,
11368: -- End of Bug Fix 56117760
11369: ppe.baseline_start_date,
11370: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
11371: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
11372: ppe.proj_element_id,ppru.as_of_date,
11373: ppv.parent_structure_version_id,
11374: -- Bug Fix 56117760
11375: -- ppru.task_wt_basis_code,
11391: ,ppe.wf_process
11392: ,ppe.wf_start_lead_days
11393: ,ppe.enable_wf_flag
11394: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
11395: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
11396: , ppru.ppl_etc_cost_pc
11397: , ppru.eqpmt_etc_cost_pc
11398: , ppru.oth_etc_cost_pc
11399: , ppru.subprj_ppl_etc_cost_pc
11399: , ppru.subprj_ppl_etc_cost_pc
11400: , ppru.subprj_eqpmt_etc_cost_pc
11401: , ppru.subprj_oth_etc_cost_pc
11402: , null
11403: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
11404: , ppru.eqpmt_act_cost_to_date_pc
11405: , ppru.oth_act_cost_to_date_pc
11406: , ppru.subprj_ppl_act_cost_pc
11407: , ppru.subprj_eqpmt_act_cost_pc
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)
11997: ,to_date(null) -- not needed in VO ppvsch.last_update_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
12015: ,ppe.STATUS_CODE
12016: ,null -- Populating Task Status Name as NULL
12017: ,ppe.phase_code
12018: ,pps5.project_status_name
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)
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
12051: , ppru.eqpmt_etc_effort
12052: , null
12053: , ppru.subprj_ppl_etc_effort
12053: , ppru.subprj_ppl_etc_effort
12054: , ppru.subprj_eqpmt_etc_effort
12055: , null
12056: , null
12057: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
12058: , ppru.eqpmt_act_effort_to_date
12059: , null
12060: , ppru.subprj_ppl_act_effort
12061: , ppru.subprj_eqpmt_act_effort
12091: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12092: ,pfxat.prj_raw_cost raw_cost
12093: ,pfxat.prj_brdn_cost burdened_cost
12094: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
12095: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
12096: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12097: Actual_Effort -- Fix for Bug # 4319171.
12098: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12099: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12096: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12097: Actual_Effort -- Fix for Bug # 4319171.
12098: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12099: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12100: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12101: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12102: ) percent_Spent_Effort
12103: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12104: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12099: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12100: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12101: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12102: ) percent_Spent_Effort
12103: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12104: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12105: nvl(pfxat.prj_brdn_cost,0)
12106: ) percent_Spent_Cost
12107: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12103: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12104: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12105: nvl(pfxat.prj_brdn_cost,0)
12106: ) percent_Spent_Cost
12107: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12108: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
12109: ) Percent_Complete_Effort
12110: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12111: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12106: ) percent_Spent_Cost
12107: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12108: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
12109: ) Percent_Complete_Effort
12110: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12111: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12112: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
12113: ) Percent_Complete_Cost
12114: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
12131: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
12132: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
12133: ,to_number ( null ) Planned_Baseline_Start
12134: ,to_number ( null ) Planned_Baseline_Finish
12135: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
12136: -- Fix for Bug # 4319171.
12137: ----------------------------------------------------------------------------------
12138: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12139: , ppru.estimated_remaining_effort
12134: ,to_number ( null ) Planned_Baseline_Finish
12135: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
12136: -- Fix for Bug # 4319171.
12137: ----------------------------------------------------------------------------------
12138: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12139: , ppru.estimated_remaining_effort
12140: , ppru.eqpmt_etc_effort
12141: , null
12142: , ppru.subprj_ppl_etc_effort
12142: , ppru.subprj_ppl_etc_effort
12143: , ppru.subprj_eqpmt_etc_effort
12144: , null
12145: , null
12146: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
12147: , ppru.eqpmt_act_effort_to_date
12148: , null
12149: , ppru.subprj_ppl_act_effort
12150: , ppru.subprj_eqpmt_act_effort
12150: , ppru.subprj_eqpmt_act_effort
12151: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
12152: ,(nvl(ppru.ppl_act_effort_to_date,0)
12153: +nvl(ppru.eqpmt_act_effort_to_date,0)
12154: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12155: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
12156: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
12157: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
12158: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
12158: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
12159: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
12160: -(nvl(ppru.ppl_act_effort_to_date,0)
12161: +nvl(ppru.eqpmt_act_effort_to_date,0)
12162: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12163: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
12164: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
12165: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
12166: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH'))) Variance_At_Completion_Effort
12167: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
12168: nvl(ppru.eqpmt_act_effort_to_date,0)))
12169: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
12170: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
12171: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
12172: , ppru.eqpmt_act_cost_to_date_pc
12173: , ppru.oth_act_cost_to_date_pc
12174: , null
12175: , null
12177: ,pfxat.prj_base_brdn_cost baseline_cost
12178: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
12179: +nvl(ppru.ppl_act_cost_to_date_pc,0)
12180: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
12181: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
12182: ,ppru.ppl_etc_cost_pc
12183: ,ppru.eqpmt_etc_cost_pc
12184: ,ppru.oth_etc_cost_pc
12185: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
12201: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
12202: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
12203: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
12204: ,ppru.earned_value Earned_Value
12205: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
12206: ppru.object_id,
12207: ppv.proj_element_id,
12208: ppru.as_of_date,
12209: ppv.parent_structure_version_id,
12215: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
12216: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12217: NVL(ppru.ppl_act_cost_to_date_pc,0)+
12218: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
12219: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
12220: ppru.object_id,
12221: ppe.proj_element_id,
12222: ppru.as_of_date,
12223: ppv.parent_structure_version_id,
12230: ,((nvl(pfxat.prj_base_brdn_cost,0))
12231: -(nvl(ppru.oth_act_cost_to_date_pc,0)
12232: +nvl(ppru.ppl_act_cost_to_date_pc,0)
12233: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
12234: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
12235: ,ppru.ppl_etc_cost_pc
12236: ,ppru.eqpmt_etc_cost_pc
12237: ,ppru.oth_etc_cost_pc
12238: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
12269: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
12270: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
12271: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
12272: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index
12273: */ ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
12274: ppru.object_id,
12275: ppe.proj_element_id,
12276: ppru.as_of_date,
12277: ppv.parent_structure_version_id,
12280: l_task_weight_basis_code,
12281: -- End of Bug Fix 56117760
12282: ppe.baseline_start_date,
12283: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
12284: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
12285: ppru.object_id,
12286: ppe.proj_element_id,
12287: ppru.as_of_date,
12288: ppv.parent_structure_version_id,
12291: l_task_weight_basis_code,
12292: -- End of Bug Fix 56117760
12293: ppe.baseline_start_date,
12294: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
12295: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
12296: ppe.proj_element_id,ppru.as_of_date,
12297: ppv.parent_structure_version_id,
12298: -- Bug Fix 56117760
12299: -- ppru.task_wt_basis_code,
12315: ,ppe.wf_process
12316: ,ppe.wf_start_lead_days
12317: ,ppe.enable_wf_flag
12318: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
12319: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
12320: , ppru.ppl_etc_cost_pc
12321: , ppru.eqpmt_etc_cost_pc
12322: , ppru.oth_etc_cost_pc
12323: , ppru.subprj_ppl_etc_cost_pc
12323: , ppru.subprj_ppl_etc_cost_pc
12324: , ppru.subprj_eqpmt_etc_cost_pc
12325: , ppru.subprj_oth_etc_cost_pc
12326: , null
12327: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
12328: , ppru.eqpmt_act_cost_to_date_pc
12329: , ppru.oth_act_cost_to_date_pc
12330: , ppru.subprj_ppl_act_cost_pc
12331: , ppru.subprj_eqpmt_act_cost_pc
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)
12793: ,to_date(null) -- not needed in VO ppvsch.last_update_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
12811: ,ppe.STATUS_CODE
12812: ,null -- Populating Task Status Name as NULL
12813: ,ppe.phase_code
12814: ,pps5.project_status_name
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)
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
12847: , ppru.eqpmt_etc_effort
12848: , null
12849: , ppru.subprj_ppl_etc_effort
12849: , ppru.subprj_ppl_etc_effort
12850: , ppru.subprj_eqpmt_etc_effort
12851: , null
12852: , null
12853: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
12854: , ppru.eqpmt_act_effort_to_date
12855: , null
12856: , ppru.subprj_ppl_act_effort
12857: , ppru.subprj_eqpmt_act_effort
12887: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12888: ,pfxat.prj_raw_cost raw_cost
12889: ,pfxat.prj_brdn_cost burdened_cost
12890: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
12891: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
12892: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12893: Actual_Effort -- Fix for Bug # 4319171.
12894: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12895: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12892: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12893: Actual_Effort -- Fix for Bug # 4319171.
12894: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12895: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12896: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12897: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12898: ) percent_Spent_Effort
12899: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12900: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12895: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12896: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12897: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12898: ) percent_Spent_Effort
12899: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12900: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12901: nvl(pfxat.prj_brdn_cost,0)
12902: ) percent_Spent_Cost
12903: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12899: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12900: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12901: nvl(pfxat.prj_brdn_cost,0)
12902: ) percent_Spent_Cost
12903: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12904: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
12905: ) Percent_Complete_Effort
12906: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12907: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12902: ) percent_Spent_Cost
12903: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12904: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
12905: ) Percent_Complete_Effort
12906: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
12907: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12908: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
12909: ) Percent_Complete_Cost
12910: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
12927: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
12928: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
12929: ,to_number ( null ) Planned_Baseline_Start
12930: ,to_number ( null ) Planned_Baseline_Finish
12931: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
12932: -- Fix for Bug # 4319171.
12933: ----------------------------------------------------------------------------------
12934: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12935: , ppru.estimated_remaining_effort
12930: ,to_number ( null ) Planned_Baseline_Finish
12931: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
12932: -- Fix for Bug # 4319171.
12933: ----------------------------------------------------------------------------------
12934: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
12935: , ppru.estimated_remaining_effort
12936: , ppru.eqpmt_etc_effort
12937: , null
12938: , ppru.subprj_ppl_etc_effort
12938: , ppru.subprj_ppl_etc_effort
12939: , ppru.subprj_eqpmt_etc_effort
12940: , null
12941: , null
12942: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
12943: , ppru.eqpmt_act_effort_to_date
12944: , null
12945: , ppru.subprj_ppl_act_effort
12946: , ppru.subprj_eqpmt_act_effort
12946: , ppru.subprj_eqpmt_act_effort
12947: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
12948: ,(nvl(ppru.ppl_act_effort_to_date,0)
12949: +nvl(ppru.eqpmt_act_effort_to_date,0)
12950: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12951: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
12952: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
12953: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
12954: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
12954: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
12955: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
12956: -(nvl(ppru.ppl_act_effort_to_date,0)
12957: +nvl(ppru.eqpmt_act_effort_to_date,0)
12958: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12959: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
12960: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
12961: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
12962: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH'))) Variance_At_Completion_Effort
12963: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
12964: nvl(ppru.eqpmt_act_effort_to_date,0)))
12965: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
12966: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
12967: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
12968: , ppru.eqpmt_act_cost_to_date_pc
12969: , ppru.oth_act_cost_to_date_pc
12970: , null
12971: , null
12973: ,pfxat.prj_base_brdn_cost baseline_cost
12974: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
12975: +nvl(ppru.ppl_act_cost_to_date_pc,0)
12976: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
12977: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
12978: ,ppru.ppl_etc_cost_pc
12979: ,ppru.eqpmt_etc_cost_pc
12980: ,ppru.oth_etc_cost_pc
12981: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
12997: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
12998: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
12999: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
13000: ,ppru.earned_value Earned_Value
13001: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
13002: ppru.object_id,
13003: ppv.proj_element_id,
13004: ppru.as_of_date,
13005: ppv.parent_structure_version_id,
13011: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
13012: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13013: NVL(ppru.ppl_act_cost_to_date_pc,0)+
13014: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
13015: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
13016: ppru.object_id,
13017: ppe.proj_element_id,
13018: ppru.as_of_date,
13019: ppv.parent_structure_version_id,
13026: ,((nvl(pfxat.prj_base_brdn_cost,0))
13027: -(nvl(ppru.oth_act_cost_to_date_pc,0)
13028: +nvl(ppru.ppl_act_cost_to_date_pc,0)
13029: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
13030: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
13031: ,ppru.ppl_etc_cost_pc
13032: ,ppru.eqpmt_etc_cost_pc
13033: ,ppru.oth_etc_cost_pc
13034: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
13065: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
13066: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
13067: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
13068: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index
13069: */ ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
13070: ppru.object_id,
13071: ppe.proj_element_id,
13072: ppru.as_of_date,
13073: ppv.parent_structure_version_id,
13076: l_task_weight_basis_code,
13077: -- End of Bug Fix 56117760
13078: ppe.baseline_start_date,
13079: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
13080: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
13081: ppru.object_id,
13082: ppe.proj_element_id,
13083: ppru.as_of_date,
13084: ppv.parent_structure_version_id,
13087: l_task_weight_basis_code,
13088: -- End of Bug Fix 56117760
13089: ppe.baseline_start_date,
13090: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
13091: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
13092: ppe.proj_element_id,ppru.as_of_date,
13093: ppv.parent_structure_version_id,
13094: -- Bug Fix 56117760
13095: -- ppru.task_wt_basis_code,
13111: ,ppe.wf_process
13112: ,ppe.wf_start_lead_days
13113: ,ppe.enable_wf_flag
13114: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
13115: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
13116: , ppru.ppl_etc_cost_pc
13117: , ppru.eqpmt_etc_cost_pc
13118: , ppru.oth_etc_cost_pc
13119: , ppru.subprj_ppl_etc_cost_pc
13119: , ppru.subprj_ppl_etc_cost_pc
13120: , ppru.subprj_eqpmt_etc_cost_pc
13121: , ppru.subprj_oth_etc_cost_pc
13122: , null
13123: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
13124: , ppru.eqpmt_act_cost_to_date_pc
13125: , ppru.oth_act_cost_to_date_pc
13126: , ppru.subprj_ppl_act_cost_pc
13127: , ppru.subprj_eqpmt_act_cost_pc
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)
13590: ,to_date(null) -- not needed in VO ppvsch.last_update_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
13608: ,ppe.STATUS_CODE
13609: ,null -- Populating Task Status Name as NULL
13610: ,ppe.phase_code
13611: ,pps5.project_status_name
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)
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
13644: , ppru.eqpmt_etc_effort
13645: , null
13646: , ppru.subprj_ppl_etc_effort
13646: , ppru.subprj_ppl_etc_effort
13647: , ppru.subprj_eqpmt_etc_effort
13648: , null
13649: , null
13650: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
13651: , ppru.eqpmt_act_effort_to_date
13652: , null
13653: , ppru.subprj_ppl_act_effort
13654: , ppru.subprj_eqpmt_act_effort
13684: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
13685: ,pfxat.prj_raw_cost raw_cost
13686: ,pfxat.prj_brdn_cost burdened_cost
13687: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
13688: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
13689: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
13690: Actual_Effort -- Fix for Bug # 4319171.
13691: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
13692: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
13689: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
13690: Actual_Effort -- Fix for Bug # 4319171.
13691: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
13692: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
13693: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13694: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13695: ) percent_Spent_Effort
13696: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
13697: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13692: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
13693: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13694: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13695: ) percent_Spent_Effort
13696: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
13697: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13698: nvl(pfxat.prj_brdn_cost,0)
13699: ) percent_Spent_Cost
13700: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13696: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
13697: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13698: nvl(pfxat.prj_brdn_cost,0)
13699: ) percent_Spent_Cost
13700: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13701: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
13702: ) Percent_Complete_Effort
13703: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
13704: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13699: ) percent_Spent_Cost
13700: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13701: (nvl(ppru.estimated_remaining_effort,0)+nvl(ppru.eqpmt_etc_effort,0))
13702: ) Percent_Complete_Effort
13703: ,PA_PROGRESS_UTILS.Percent_Complete_Value((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
13704: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13705: (nvl(ppru.oth_etc_cost_pc,0)+nvl(ppru.ppl_etc_cost_pc,0)+nvl(ppru.eqpmt_etc_cost_pc,0))
13706: ) Percent_Complete_Cost
13707: ,trunc(ppru.actual_finish_date) - trunc(ppru.actual_start_date) Actual_Duration
13724: , (ppvsch.ESTIMATED_START_DATE - ppe.BASELINE_START_DATE) Estimated_Baseline_Start
13725: , (ppvsch.ESTIMATED_FINISH_DATE - ppe.BASELINE_FINISH_DATE) Estimated_Baseline_Finish
13726: ,to_number ( null ) Planned_Baseline_Start
13727: ,to_number ( null ) Planned_Baseline_Finish
13728: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
13729: -- Fix for Bug # 4319171.
13730: ----------------------------------------------------------------------------------
13731: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
13732: , ppru.estimated_remaining_effort
13727: ,to_number ( null ) Planned_Baseline_Finish
13728: ,pa_progress_utils.calc_plan(pfxat.base_equip_hours, pfxat.base_labor_hours, null) Baseline_effort
13729: -- Fix for Bug # 4319171.
13730: ----------------------------------------------------------------------------------
13731: , pa_progress_utils.calc_etc(pa_progress_utils.calc_plan(pfxat.labor_hours, pfxat.equipment_hours, null)
13732: , ppru.estimated_remaining_effort
13733: , ppru.eqpmt_etc_effort
13734: , null
13735: , ppru.subprj_ppl_etc_effort
13735: , ppru.subprj_ppl_etc_effort
13736: , ppru.subprj_eqpmt_etc_effort
13737: , null
13738: , null
13739: , pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date
13740: , ppru.eqpmt_act_effort_to_date
13741: , null
13742: , ppru.subprj_ppl_act_effort
13743: , ppru.subprj_eqpmt_act_effort
13743: , ppru.subprj_eqpmt_act_effort
13744: , null)) ETC_EFFORT -- Fix for Bug # 4319171.
13745: ,(nvl(ppru.ppl_act_effort_to_date,0)
13746: +nvl(ppru.eqpmt_act_effort_to_date,0)
13747: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13748: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
13749: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
13750: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
13751: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
13751: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH')) Estimate_At_Completion_Effort
13752: ,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))
13753: -(nvl(ppru.ppl_act_effort_to_date,0)
13754: +nvl(ppru.eqpmt_act_effort_to_date,0)
13755: +pa_progress_utils.sum_etc_values((nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13756: ,ppru.estimated_remaining_effort,ppru.eqpmt_etc_effort,null
13757: ,ppru.subprj_ppl_etc_effort,ppru.subprj_eqpmt_etc_effort,null,null
13758: ,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)
13759: +nvl(ppru.subprj_ppl_act_effort,0)+nvl(ppru.subprj_eqpmt_act_effort,0)),'PUBLISH'))) Variance_At_Completion_Effort
13760: ,((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
13761: nvl(ppru.eqpmt_act_effort_to_date,0)))
13762: ,round((((ppru.earned_value)-(nvl(ppru.ppl_act_effort_to_date,0)+
13763: nvl(ppru.eqpmt_act_effort_to_date,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
13764: ,pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
13765: , ppru.eqpmt_act_cost_to_date_pc
13766: , ppru.oth_act_cost_to_date_pc
13767: , null
13768: , null
13770: ,pfxat.prj_base_brdn_cost baseline_cost
13771: ,(nvl(ppru.oth_act_cost_to_date_pc,0)
13772: +nvl(ppru.ppl_act_cost_to_date_pc,0)
13773: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
13774: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
13775: ,ppru.ppl_etc_cost_pc
13776: ,ppru.eqpmt_etc_cost_pc
13777: ,ppru.oth_etc_cost_pc
13778: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
13794: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)/DECODE(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0),0,1,ppru.CUMULATIVE_WORK_QUANTITY)),ppa.project_currency_code) Actual_Cost_Per_Unit -- 4195352
13795: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
13796: ,round((((ppru.CUMULATIVE_WORK_QUANTITY-ppvsch.WQ_PLANNED_QUANTITY)/DECODE(NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0,1,ppvsch.WQ_PLANNED_QUANTITY))*100),2) Work_Quantity_Variance_Percent
13797: ,ppru.earned_value Earned_Value
13798: ,(nvl(ppru.earned_value,0)-nvl(pa_progress_utils.get_bcws(ppa.project_id,
13799: ppru.object_id,
13800: ppv.proj_element_id,
13801: ppru.as_of_date,
13802: ppv.parent_structure_version_id,
13808: ppe.baseline_finish_date,ppa.project_currency_code),0)) Schedule_Variance
13809: ,(NVL(ppru.earned_value,0)-NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13810: NVL(ppru.ppl_act_cost_to_date_pc,0)+
13811: NVL(ppru.eqpmt_act_cost_to_date_pc,0)),0)) Earned_Value_Cost_Variance
13812: ,(NVL(ppru.earned_value,0)-NVL(pa_progress_utils.get_bcws(ppa.project_id,
13813: ppru.object_id,
13814: ppe.proj_element_id,
13815: ppru.as_of_date,
13816: ppv.parent_structure_version_id,
13823: ,((nvl(pfxat.prj_base_brdn_cost,0))
13824: -(nvl(ppru.oth_act_cost_to_date_pc,0)
13825: +nvl(ppru.ppl_act_cost_to_date_pc,0)
13826: +nvl(ppru.eqpmt_act_cost_to_date_pc,0)
13827: +pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
13828: ,ppru.ppl_etc_cost_pc
13829: ,ppru.eqpmt_etc_cost_pc
13830: ,ppru.oth_etc_cost_pc
13831: ,ppru.subprj_ppl_etc_cost_pc,ppru.subprj_eqpmt_etc_cost_pc
13862: +nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),'EFFORT',(((nvl(pfxat.base_labor_hours,0)
13863: +nvl(pfxat.base_equip_hours,0))-ppru.earned_value)/decode(((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
13864: +nvl(ppru.eqpmt_act_effort_to_date,0))),0,1,((nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0))-(nvl(ppru.ppl_act_effort_to_date,0)
13865: +nvl(ppru.eqpmt_act_effort_to_date,0))))))),2) To_Complete_Performance_Index
13866: */ ,(nvl(pa_progress_utils.get_bcws(ppa.project_id,
13867: ppru.object_id,
13868: ppe.proj_element_id,
13869: ppru.as_of_date,
13870: ppv.parent_structure_version_id,
13873: l_task_weight_basis_code,
13874: -- End of Bug Fix 56117760
13875: ppe.baseline_start_date,
13876: ppe.baseline_finish_date,ppa.project_currency_code),0)) Budgeted_Cost_Of_Work_Sch
13877: ,round((nvl(ppru.earned_value,0)/decode(nvl(pa_progress_utils.get_bcws(ppa.project_id,
13878: ppru.object_id,
13879: ppe.proj_element_id,
13880: ppru.as_of_date,
13881: ppv.parent_structure_version_id,
13884: l_task_weight_basis_code,
13885: -- End of Bug Fix 56117760
13886: ppe.baseline_start_date,
13887: ppe.baseline_finish_date,ppa.project_currency_code),0),0,1,
13888: nvl(pa_progress_utils.get_bcws(ppa.project_id,ppru.object_id,
13889: ppe.proj_element_id,ppru.as_of_date,
13890: ppv.parent_structure_version_id,
13891: -- Bug Fix 56117760
13892: -- ppru.task_wt_basis_code,
13908: ,ppe.wf_process
13909: ,ppe.wf_start_lead_days
13910: ,ppe.enable_wf_flag
13911: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
13912: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
13913: , ppru.ppl_etc_cost_pc
13914: , ppru.eqpmt_etc_cost_pc
13915: , ppru.oth_etc_cost_pc
13916: , ppru.subprj_ppl_etc_cost_pc
13916: , ppru.subprj_ppl_etc_cost_pc
13917: , ppru.subprj_eqpmt_etc_cost_pc
13918: , ppru.subprj_oth_etc_cost_pc
13919: , null
13920: , pa_progress_utils.calc_act(ppru.ppl_act_cost_to_date_pc
13921: , ppru.eqpmt_act_cost_to_date_pc
13922: , ppru.oth_act_cost_to_date_pc
13923: , ppru.subprj_ppl_act_cost_pc
13924: , ppru.subprj_eqpmt_act_cost_pc