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

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_CURRENCY

Line 1381: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

1377: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
1378: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1379: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1380: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1381: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
1382: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1383: NVL(ppru.ppl_act_cost_to_date_pc,0)+
1384: 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
1385: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 1382: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

1378: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1379: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1380: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1381: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
1382: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1383: NVL(ppru.ppl_act_cost_to_date_pc,0)+
1384: 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
1385: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
1386: ,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

Line 1958: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

1954: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
1955: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1956: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1957: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1958: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
1959: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1960: NVL(ppru.ppl_act_cost_to_date_pc,0)+
1961: 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
1962: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 1959: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

1955: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1956: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1957: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1958: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
1959: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1960: NVL(ppru.ppl_act_cost_to_date_pc,0)+
1961: 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
1962: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
1963: ,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

Line 2771: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

2767: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
2768: nvl(ppru.ppl_act_cost_to_date_pc,0)+
2769: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
2770: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
2771: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
2772: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
2773: NVL(ppru.ppl_act_cost_to_date_pc,0)+
2774: 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
2775: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 2772: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

2768: nvl(ppru.ppl_act_cost_to_date_pc,0)+
2769: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
2770: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
2771: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
2772: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
2773: NVL(ppru.ppl_act_cost_to_date_pc,0)+
2774: 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
2775: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
2776: ,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

Line 3351: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

3347: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
3348: nvl(ppru.ppl_act_cost_to_date_pc,0)+
3349: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3350: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
3351: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
3352: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
3353: NVL(ppru.ppl_act_cost_to_date_pc,0)+
3354: 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
3355: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 3352: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

3348: nvl(ppru.ppl_act_cost_to_date_pc,0)+
3349: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3350: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
3351: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
3352: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
3353: NVL(ppru.ppl_act_cost_to_date_pc,0)+
3354: 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
3355: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
3356: ,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

Line 4226: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

4222: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
4223: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4224: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
4225: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
4226: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
4227: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4228: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4229: 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
4230: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 4227: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

4223: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4224: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
4225: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
4226: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
4227: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4228: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4229: 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
4230: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
4231: ,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

Line 4801: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

4797: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
4798: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4799: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
4800: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
4801: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
4802: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4803: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4804: 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
4805: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 4802: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

4798: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4799: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
4800: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
4801: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
4802: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4803: NVL(ppru.ppl_act_cost_to_date_pc,0)+
4804: 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
4805: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
4806: ,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

Line 5832: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

5828: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
5829: nvl(ppru.ppl_act_cost_to_date_pc,0)+
5830: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
5831: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
5832: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
5833: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
5834: NVL(ppru.ppl_act_cost_to_date_pc,0)+
5835: 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
5836: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 5833: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

5829: nvl(ppru.ppl_act_cost_to_date_pc,0)+
5830: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
5831: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
5832: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
5833: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
5834: NVL(ppru.ppl_act_cost_to_date_pc,0)+
5835: 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
5836: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
5837: ,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

Line 6658: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

6654: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
6655: nvl(ppru.ppl_act_cost_to_date_pc,0)+
6656: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
6657: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
6658: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
6659: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
6660: NVL(ppru.ppl_act_cost_to_date_pc,0)+
6661: 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
6662: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 6659: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

6655: nvl(ppru.ppl_act_cost_to_date_pc,0)+
6656: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
6657: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
6658: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
6659: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
6660: NVL(ppru.ppl_act_cost_to_date_pc,0)+
6661: 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
6662: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
6663: ,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

Line 7485: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

7481: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
7482: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7483: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
7484: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
7485: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
7486: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7487: NVL(ppru.ppl_act_cost_to_date_pc,0)+
7488: 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
7489: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 7486: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

7482: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7483: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
7484: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
7485: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
7486: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7487: NVL(ppru.ppl_act_cost_to_date_pc,0)+
7488: 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
7489: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
7490: ,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

Line 8436: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

8432: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
8433: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8434: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8435: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
8436: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
8437: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8438: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8439: 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
8440: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 8437: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

8433: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8434: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8435: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
8436: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
8437: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8438: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8439: 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
8440: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
8441: ,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

Line 8927: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

8923: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
8924: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8925: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8926: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
8927: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
8928: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8929: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8930: 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
8931: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 8928: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

8924: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8925: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8926: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
8927: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
8928: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8929: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8930: 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
8931: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
8932: ,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

Line 9435: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

9431: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
9432: nvl(ppru.ppl_act_cost_to_date_pc,0)+
9433: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
9434: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
9435: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
9436: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
9437: NVL(ppru.ppl_act_cost_to_date_pc,0)+
9438: 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
9439: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 9436: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

9432: nvl(ppru.ppl_act_cost_to_date_pc,0)+
9433: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
9434: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
9435: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
9436: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
9437: NVL(ppru.ppl_act_cost_to_date_pc,0)+
9438: 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
9439: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
9440: ,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

Line 10323: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit

10319: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
10320: nvl(ppru.ppl_act_cost_to_date_pc,0)+
10321: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
10322: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
10323: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit
10324: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
10325: NVL(ppru.ppl_act_cost_to_date_pc,0)+
10326: 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
10327: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

Line 10324: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

10320: nvl(ppru.ppl_act_cost_to_date_pc,0)+
10321: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
10322: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
10323: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit
10324: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
10325: NVL(ppru.ppl_act_cost_to_date_pc,0)+
10326: 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
10327: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
10328: ,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

Line 11082: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit

11078: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
11079: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11080: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11081: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11082: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit
11083: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11084: NVL(ppru.ppl_act_cost_to_date_pc,0)+
11085: 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
11086: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 11083: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

11079: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11080: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11081: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11082: ,null --pa_currency.round_trans_currency_amt((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit
11083: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11084: NVL(ppru.ppl_act_cost_to_date_pc,0)+
11085: 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
11086: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
11087: ,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

Line 11950: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

11946: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
11947: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11948: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11949: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11950: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
11951: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11952: NVL(ppru.ppl_act_cost_to_date_pc,0)+
11953: 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
11954: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 11951: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

11947: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11948: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11949: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11950: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
11951: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11952: NVL(ppru.ppl_act_cost_to_date_pc,0)+
11953: 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
11954: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
11955: ,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

Line 12778: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

12774: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
12775: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12776: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12777: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12778: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
12779: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12780: NVL(ppru.ppl_act_cost_to_date_pc,0)+
12781: 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
12782: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 12779: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

12775: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12776: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12777: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12778: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
12779: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12780: NVL(ppru.ppl_act_cost_to_date_pc,0)+
12781: 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
12782: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
12783: ,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

Line 13607: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

13603: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
13604: nvl(ppru.ppl_act_cost_to_date_pc,0)+
13605: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
13606: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
13607: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
13608: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13609: NVL(ppru.ppl_act_cost_to_date_pc,0)+
13610: 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
13611: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 13608: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

13604: nvl(ppru.ppl_act_cost_to_date_pc,0)+
13605: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
13606: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
13607: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
13608: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13609: NVL(ppru.ppl_act_cost_to_date_pc,0)+
13610: 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
13611: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
13612: ,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

Line 14532: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

14528: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
14529: nvl(ppru.ppl_act_cost_to_date_pc,0)+
14530: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
14531: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
14532: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
14533: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
14534: NVL(ppru.ppl_act_cost_to_date_pc,0)+
14535: 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
14536: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 14533: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

14529: nvl(ppru.ppl_act_cost_to_date_pc,0)+
14530: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
14531: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
14532: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
14533: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
14534: NVL(ppru.ppl_act_cost_to_date_pc,0)+
14535: 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
14536: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
14537: ,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

Line 15329: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

15325: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
15326: nvl(ppru.ppl_act_cost_to_date_pc,0)+
15327: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
15328: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
15329: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
15330: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
15331: NVL(ppru.ppl_act_cost_to_date_pc,0)+
15332: 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
15333: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 15330: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

15326: nvl(ppru.ppl_act_cost_to_date_pc,0)+
15327: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
15328: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
15329: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
15330: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
15331: NVL(ppru.ppl_act_cost_to_date_pc,0)+
15332: 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
15333: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
15334: ,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

Line 16127: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352

16123: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
16124: nvl(ppru.ppl_act_cost_to_date_pc,0)+
16125: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
16126: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
16127: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
16128: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
16129: NVL(ppru.ppl_act_cost_to_date_pc,0)+
16130: 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
16131: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

Line 16128: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+

16124: nvl(ppru.ppl_act_cost_to_date_pc,0)+
16125: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
16126: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
16127: ,pa_currency.round_trans_currency_amt1((nvl(pfxat.prj_brdn_cost,0)/decode(nvl(cumulative_work_quantity,0),0,1,nvl(cumulative_work_quantity,0))),ppa.project_currency_code) Planned_Cost_Per_Unit -- 4195352
16128: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
16129: NVL(ppru.ppl_act_cost_to_date_pc,0)+
16130: 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
16131: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
16132: ,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