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_FP_WEBADI_UTILS dependencies on STANDARD

Line 3309: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3305: return to_number(null);
3306: end if;
3307:
3308: select decode(p_amount_code,'RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3309: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3310: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3311: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3312: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3313: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)

Line 3310: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

3306: end if;
3307:
3308: select decode(p_amount_code,'RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3309: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3310: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3311: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3312: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3313: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3314: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),

Line 3312: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3308: select decode(p_amount_code,'RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3309: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3310: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3311: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3312: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3313: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3314: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3315: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3316: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),

Line 3315: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3311: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3312: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3313: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3314: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3315: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3316: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3317: 'ETC_RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3318: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3319: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

Line 3318: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3314: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3315: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3316: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3317: 'ETC_RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3318: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3319: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3320: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3321: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3322: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)

Line 3319: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

3315: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3316: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3317: 'ETC_RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3318: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3319: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3320: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3321: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3322: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3323: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),

Line 3321: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3317: 'ETC_RAW_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3318: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3319: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
3320: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3321: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3322: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3323: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3324: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3325: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),

Line 3324: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),

3320: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3321: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3322: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3323: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3324: decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,to_number(null),
3325: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3326: 'BURDENED_COST_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3327: decode(nvl(bl.burden_cost_rate_override,nvl(bl.burden_cost_rate,0)),0,to_number(null),
3328: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.burden_cost_rate_override,nvl(bl.burden_cost_rate,0)))))))

Line 3345: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3341: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3342: decode(nvl(bl.burden_cost_rate_override,nvl(bl.burden_cost_rate,0)),0,to_number(null),
3343: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3344: 'BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3345: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3346: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3347: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3348: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3349: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)

Line 3346: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

3342: decode(nvl(bl.burden_cost_rate_override,nvl(bl.burden_cost_rate,0)),0,to_number(null),
3343: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3344: 'BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3345: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3346: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3347: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3348: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3349: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3350: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),

Line 3348: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3344: 'BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3345: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3346: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3347: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3348: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3349: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3350: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3351: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3352: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),

Line 3351: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3347: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3348: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3349: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3350: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3351: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3352: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3353: 'ETC_BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3354: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3355: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

Line 3354: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3350: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3351: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3352: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3353: 'ETC_BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3354: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3355: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3356: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3357: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3358: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)

Line 3355: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

3351: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3352: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3353: 'ETC_BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3354: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3355: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3356: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3357: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3358: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3359: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),

Line 3357: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3353: 'ETC_BILL_RATE',DECODE(pra.rate_based_flag,'Y',(sum((decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3354: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3355: ((nvl(bl.quantity,0) - nvl(bl.init_quantity,0))*nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
3356: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3357: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3358: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3359: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3360: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3361: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),

Line 3360: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),

3356: /decode(sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3357: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3358: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))),0, to_number(null)
3359: ,sum(decode(nvl(bl.quantity,0) - nvl(bl.init_quantity,0),0,to_number(null),
3360: decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,to_number(null),
3361: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0))))))),NULL),
3362: 'TOTAL_QTY',sum(bl.display_quantity),
3363: 'FCST_QTY',sum(bl.display_quantity),
3364: 'TOTAL_RAW_COST' ,sum(bl.txn_raw_cost),