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 1380: ,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

1376: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
1377: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1378: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1379: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1380: ,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
1381: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1382: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

1377: nvl(ppru.ppl_act_cost_to_date_pc,0)+
1378: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
1379: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
1380: ,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
1381: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
1382: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 2186: ,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

2182: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
2183: nvl(ppru.ppl_act_cost_to_date_pc,0)+
2184: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
2185: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
2186: ,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
2187: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
2188: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

2183: nvl(ppru.ppl_act_cost_to_date_pc,0)+
2184: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
2185: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
2186: ,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
2187: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
2188: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 3049: ,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

3045: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
3046: nvl(ppru.ppl_act_cost_to_date_pc,0)+
3047: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3048: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
3049: ,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
3050: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
3051: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

3046: nvl(ppru.ppl_act_cost_to_date_pc,0)+
3047: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
3048: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
3049: ,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
3050: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
3051: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 4020: ,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

4016: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
4017: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4018: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
4019: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
4020: ,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
4021: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4022: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

4017: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4018: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
4019: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
4020: ,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
4021: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4022: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 4845: ,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

4841: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
4842: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4843: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
4844: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
4845: ,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
4846: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4847: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

4842: nvl(ppru.ppl_act_cost_to_date_pc,0)+
4843: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
4844: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
4845: ,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
4846: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
4847: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 5671: ,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

5667: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
5668: nvl(ppru.ppl_act_cost_to_date_pc,0)+
5669: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
5670: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
5671: ,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
5672: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
5673: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

5668: nvl(ppru.ppl_act_cost_to_date_pc,0)+
5669: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
5670: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
5671: ,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
5672: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
5673: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 6621: ,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

6617: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
6618: nvl(ppru.ppl_act_cost_to_date_pc,0)+
6619: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
6620: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
6621: ,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
6622: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
6623: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

6618: nvl(ppru.ppl_act_cost_to_date_pc,0)+
6619: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
6620: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
6621: ,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
6622: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
6623: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 7111: ,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

7107: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
7108: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7109: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
7110: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
7111: ,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
7112: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7113: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

7108: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7109: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
7110: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
7111: ,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
7112: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7113: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 7993: ,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

7989: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
7990: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7991: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
7992: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
7993: ,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
7994: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7995: NVL(ppru.ppl_act_cost_to_date_pc,0)+
7996: 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
7997: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance

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

7990: nvl(ppru.ppl_act_cost_to_date_pc,0)+
7991: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(ppru.earned_value,0,1,ppru.earned_value))),2)
7992: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),2) ETC_Work_Quantity
7993: ,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
7994: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
7995: NVL(ppru.ppl_act_cost_to_date_pc,0)+
7996: 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
7997: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),2) Work_Quantity_Variance
7998: ,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 8752: ,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

8748: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
8749: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8750: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8751: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
8752: ,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
8753: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8754: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8755: 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
8756: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance

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

8749: nvl(ppru.ppl_act_cost_to_date_pc,0)+
8750: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
8751: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
8752: ,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
8753: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
8754: NVL(ppru.ppl_act_cost_to_date_pc,0)+
8755: 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
8756: ,round((NVL(NVL(ppru.CUMULATIVE_WORK_QUANTITY,0)-NVL(ppvsch.WQ_PLANNED_QUANTITY,0),0)),5) Work_Quantity_Variance
8757: ,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 9619: ,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

9615: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
9616: nvl(ppru.ppl_act_cost_to_date_pc,0)+
9617: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
9618: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
9619: ,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
9620: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
9621: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

9616: nvl(ppru.ppl_act_cost_to_date_pc,0)+
9617: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
9618: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
9619: ,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
9620: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
9621: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 10446: ,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

10442: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
10443: nvl(ppru.ppl_act_cost_to_date_pc,0)+
10444: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
10445: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
10446: ,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
10447: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
10448: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

10443: nvl(ppru.ppl_act_cost_to_date_pc,0)+
10444: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
10445: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
10446: ,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
10447: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
10448: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 11274: ,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

11270: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
11271: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11272: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11273: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11274: ,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
11275: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11276: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

11271: nvl(ppru.ppl_act_cost_to_date_pc,0)+
11272: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
11273: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
11274: ,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
11275: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
11276: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 12198: ,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

12194: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
12195: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12196: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12197: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12198: ,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
12199: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12200: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

12195: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12196: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12197: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12198: ,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
12199: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12200: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 12994: ,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

12990: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
12991: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12992: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12993: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12994: ,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
12995: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12996: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

12991: nvl(ppru.ppl_act_cost_to_date_pc,0)+
12992: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
12993: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
12994: ,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
12995: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
12996: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

Line 13791: ,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

13787: ,round((((NVL(ppru.earned_value,0))-(nvl(ppru.oth_act_cost_to_date_pc,0)+
13788: nvl(ppru.ppl_act_cost_to_date_pc,0)+
13789: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
13790: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
13791: ,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
13792: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13793: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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

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

13788: nvl(ppru.ppl_act_cost_to_date_pc,0)+
13789: nvl(ppru.eqpmt_act_cost_to_date_pc,0)))/(DECODE(NVL(ppru.earned_value,0),0,1,NVL(ppru.earned_value,0)))),2)
13790: ,round((NVL(ppvsch.wq_planned_quantity,0) - NVL(CUMULATIVE_WORK_QUANTITY,0)),5) ETC_Work_Quantity
13791: ,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
13792: ,pa_currency.round_trans_currency_amt1((NVL((NVL(ppru.oth_act_cost_to_date_pc,0)+
13793: NVL(ppru.ppl_act_cost_to_date_pc,0)+
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