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

Line 129: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

125: 'A', c_projfunc_currency_code),
126: sum(quantity),
127: sum(decode(l_txn_currency_flag,
128: 'Y', sbl.quantity *
129: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
130: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
131: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
132: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
133: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 131: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

127: sum(decode(l_txn_currency_flag,
128: 'Y', sbl.quantity *
129: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
130: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
131: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
132: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
133: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
134: sum(decode(l_txn_currency_flag,
135: 'Y', sbl.quantity *

Line 133: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

129: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
130: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
131: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
132: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
133: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
134: sum(decode(l_txn_currency_flag,
135: 'Y', sbl.quantity *
136: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
137: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

Line 143: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

139: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
140: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
141: sum(decode(l_txn_currency_flag,
142: 'Y', sbl.quantity *
143: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
145: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
147: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 145: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

141: sum(decode(l_txn_currency_flag,
142: 'Y', sbl.quantity *
143: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
145: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
147: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
148: NULL,
149: NULL,

Line 147: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

143: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
145: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
147: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
148: NULL,
149: NULL,
150: NULL,
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */

Line 229: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

225: 'A', c_projfunc_currency_code),
226: sum(quantity),
227: sum(decode(l_txn_currency_flag,
228: 'Y', sbl.quantity *
229: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
230: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
231: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
232: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
233: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 231: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

227: sum(decode(l_txn_currency_flag,
228: 'Y', sbl.quantity *
229: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
230: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
231: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
232: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
233: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
234: sum(decode(l_txn_currency_flag,
235: 'Y', sbl.quantity *

Line 233: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

229: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
230: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
231: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
232: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
233: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
234: sum(decode(l_txn_currency_flag,
235: 'Y', sbl.quantity *
236: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
237: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

Line 243: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

239: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
240: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
241: sum(decode(l_txn_currency_flag,
242: 'Y', sbl.quantity *
243: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
244: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
245: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
246: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
247: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 245: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

241: sum(decode(l_txn_currency_flag,
242: 'Y', sbl.quantity *
243: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
244: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
245: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
246: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
247: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
248: NULL,
249: NULL,

Line 247: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

243: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
244: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
245: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
246: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
247: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
248: NULL,
249: NULL,
250: NULL,
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */

Line 300: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

296: 'A', c_projfunc_currency_code),
297: sum(sbl.quantity-NVL(sbl.init_quantity,0)),
298: sum(decode(l_txn_currency_flag,
299: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
300: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
301: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
302: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
303: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
304: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 302: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

298: sum(decode(l_txn_currency_flag,
299: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
300: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
301: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
302: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
303: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
304: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
305: sum(decode(l_txn_currency_flag,
306: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *

Line 304: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

300: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
301: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
302: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
303: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
304: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
305: sum(decode(l_txn_currency_flag,
306: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
307: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
308: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *

Line 314: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

310: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
311: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
312: sum(decode(l_txn_currency_flag,
313: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
314: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
315: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
316: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
317: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
318: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 316: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

312: sum(decode(l_txn_currency_flag,
313: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
314: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
315: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
316: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
317: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
318: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
319: NULL,
320: NULL,

Line 318: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

314: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
315: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
316: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
317: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
318: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
319: NULL,
320: NULL,
321: NULL,
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */

Line 2790: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

2786: 'N', sbl.project_revenue,
2787: 'A', sbl.revenue)),
2788: sum(decode(l_txn_currency_flag,
2789: 'Y', sbl.quantity *
2790: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2791: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2792: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2793: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2794: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 2792: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

2788: sum(decode(l_txn_currency_flag,
2789: 'Y', sbl.quantity *
2790: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2791: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2792: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2793: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2794: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2795: sum(decode(l_txn_currency_flag,
2796: 'Y', sbl.quantity *

Line 2794: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

2790: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2791: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2792: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2793: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2794: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2795: sum(decode(l_txn_currency_flag,
2796: 'Y', sbl.quantity *
2797: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
2798: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

Line 2804: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

2800: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2801: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
2802: sum(decode(l_txn_currency_flag,
2803: 'Y', sbl.quantity *
2804: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2805: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2806: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2807: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2808: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 2806: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

2802: sum(decode(l_txn_currency_flag,
2803: 'Y', sbl.quantity *
2804: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2805: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2806: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2807: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2808: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
2809: sum(sbl.project_raw_cost),
2810: sum(sbl.project_burdened_cost),

Line 2808: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

2804: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2805: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2806: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2807: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2808: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
2809: sum(sbl.project_raw_cost),
2810: sum(sbl.project_burdened_cost),
2811: sum(sbl.project_revenue),
2812: sum(sbl.raw_cost),

Line 2880: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),

2876: 'N', sbl.project_revenue,
2877: 'A', sbl.revenue)),
2878: sum(decode(l_txn_currency_flag,
2879: 'Y', sbl.quantity *
2880: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2881: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2882: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2883: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2884: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),

Line 2882: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),

2878: sum(decode(l_txn_currency_flag,
2879: 'Y', sbl.quantity *
2880: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2881: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2882: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2883: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2884: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),
2885: sum(decode(l_txn_currency_flag,
2886: 'Y', sbl.quantity *

Line 2884: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),

2880: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2881: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2882: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2883: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2884: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),
2885: sum(decode(l_txn_currency_flag,
2886: 'Y', sbl.quantity *
2887: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate),
2888: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

Line 2894: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),

2890: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2891: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))),
2892: sum(decode(l_txn_currency_flag,
2893: 'Y', sbl.quantity *
2894: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2895: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2896: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2897: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2898: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),

Line 2896: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),

2892: sum(decode(l_txn_currency_flag,
2893: 'Y', sbl.quantity *
2894: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2895: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2896: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2897: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2898: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),
2899: sum(sbl.project_raw_cost),
2900: sum(sbl.project_burdened_cost),

Line 2898: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),

2894: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2895: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2896: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2897: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2898: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),
2899: sum(sbl.project_raw_cost),
2900: sum(sbl.project_burdened_cost),
2901: sum(sbl.project_revenue),
2902: sum(sbl.raw_cost),

Line 2975: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

2971: 'N', sbl.project_revenue,
2972: 'A', sbl.revenue)),
2973: sum(decode(l_txn_currency_flag,
2974: 'Y', sbl.quantity *
2975: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2976: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2977: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2978: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2979: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 2977: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

2973: sum(decode(l_txn_currency_flag,
2974: 'Y', sbl.quantity *
2975: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2976: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2977: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2978: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2979: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2980: sum(decode(l_txn_currency_flag,
2981: 'Y', sbl.quantity *

Line 2979: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

2975: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2976: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2977: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2978: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2979: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2980: sum(decode(l_txn_currency_flag,
2981: 'Y', sbl.quantity *
2982: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
2983: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

Line 2989: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

2985: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2986: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
2987: sum(decode(l_txn_currency_flag,
2988: 'Y', sbl.quantity *
2989: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2990: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2991: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2992: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2993: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 2991: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

2987: sum(decode(l_txn_currency_flag,
2988: 'Y', sbl.quantity *
2989: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2990: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2991: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2992: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2993: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
2994: sum(sbl.project_raw_cost),
2995: sum(sbl.project_burdened_cost),

Line 2993: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

2989: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2990: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2991: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2992: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2993: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
2994: sum(sbl.project_raw_cost),
2995: sum(sbl.project_burdened_cost),
2996: sum(sbl.project_revenue),
2997: sum(sbl.raw_cost),

Line 3072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

3068: 'N', sbl.project_revenue - NVL(sbl.project_init_revenue,0),
3069: 'A', sbl.revenue - NVL(sbl.init_revenue,0))),
3070: sum(decode(l_txn_currency_flag,
3071: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3073: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3075: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3076: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

Line 3074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost

3070: sum(decode(l_txn_currency_flag,
3071: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3073: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3075: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3076: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3077: sum(decode(l_txn_currency_flag,
3078: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *

Line 3076: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

3072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3073: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3075: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3076: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3077: sum(decode(l_txn_currency_flag,
3078: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3079: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3080: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *

Line 3086: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue

3082: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3083: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3084: sum(decode(l_txn_currency_flag,
3085: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3086: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3087: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3088: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3089: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3090: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

Line 3088: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue

3084: sum(decode(l_txn_currency_flag,
3085: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3086: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3087: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3088: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3089: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3090: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3091: sum(sbl.project_raw_cost - NVL(sbl.project_init_raw_cost,0)),
3092: sum(sbl.project_burdened_cost - NVL(sbl.project_init_burdened_cost,0)),

Line 3090: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

3086: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3087: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3088: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3089: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3090: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3091: sum(sbl.project_raw_cost - NVL(sbl.project_init_raw_cost,0)),
3092: sum(sbl.project_burdened_cost - NVL(sbl.project_init_burdened_cost,0)),
3093: sum(sbl.project_revenue - NVL(sbl.project_init_revenue,0)),
3094: sum(sbl.raw_cost - NVL(sbl.init_raw_cost,0)),