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 130: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost

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

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

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

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

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

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

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

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

142: sum(decode(l_txn_currency_flag,
143: 'Y', sbl.quantity *
144: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
145: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
146: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
147: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
148: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
149: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
150: sum(decode(l_txn_currency_flag,

Line 148: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */

144: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
145: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
146: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
147: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
148: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
149: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
150: sum(decode(l_txn_currency_flag,
151: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))

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

148: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
149: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
150: sum(decode(l_txn_currency_flag,
151: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
153: + NVL(sbl.txn_init_raw_cost,0)), --sbl.txn_raw_cost
154: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
155: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
156: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost

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

151: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
153: + NVL(sbl.txn_init_raw_cost,0)), --sbl.txn_raw_cost
154: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
155: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
156: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost
157: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
158: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
159: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))

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

154: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
155: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
156: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost
157: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
158: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
159: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
160: )), --sbl.raw_cost
161: sum(decode(l_txn_currency_flag,
162: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *

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

170: + NVL(sbl.txn_init_burdened_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
171: )), --sbl.burdened_cost
172: sum(decode(l_txn_currency_flag,
173: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
174: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
175: + NVL(sbl.txn_init_revenue,0)), --sbl.txn_revenue
176: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
177: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
178: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue

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

173: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
174: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
175: + NVL(sbl.txn_init_revenue,0)), --sbl.txn_revenue
176: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
177: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
178: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue
179: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
180: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
181: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))

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

176: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
177: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
178: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue
179: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
180: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
181: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
182: )),
183: NULL,
184: NULL,

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

260: 'A', c_projfunc_currency_code),
261: sum(quantity),
262: sum(decode(l_txn_currency_flag,
263: 'Y', sbl.quantity *
264: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
265: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
266: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
267: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
268: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

262: sum(decode(l_txn_currency_flag,
263: 'Y', sbl.quantity *
264: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
265: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
266: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
267: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
268: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
269: sum(decode(l_txn_currency_flag,
270: 'Y', sbl.quantity *

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

264: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
265: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
266: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
267: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
268: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
269: sum(decode(l_txn_currency_flag,
270: 'Y', sbl.quantity *
271: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
272: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

274: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
275: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
276: sum(decode(l_txn_currency_flag,
277: 'Y', sbl.quantity *
278: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
279: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
280: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
281: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
282: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

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

276: sum(decode(l_txn_currency_flag,
277: 'Y', sbl.quantity *
278: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
279: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
280: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
281: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
282: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
283: NULL,
284: NULL,

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

278: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
279: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
280: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
281: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
282: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
283: NULL,
284: NULL,
285: NULL,
286: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */

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

331: 'A', c_projfunc_currency_code),
332: sum(sbl.quantity-NVL(sbl.init_quantity,0)),
333: sum(decode(l_txn_currency_flag,
334: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
335: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
336: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
337: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
338: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
339: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

333: sum(decode(l_txn_currency_flag,
334: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
335: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
336: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
337: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
338: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
339: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
340: sum(decode(l_txn_currency_flag,
341: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *

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

335: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
336: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
337: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
338: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
339: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
340: sum(decode(l_txn_currency_flag,
341: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
342: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
343: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *

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

345: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
346: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
347: sum(decode(l_txn_currency_flag,
348: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
349: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
350: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
351: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
352: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
353: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

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

347: sum(decode(l_txn_currency_flag,
348: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
349: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
350: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
351: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
352: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
353: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
354: NULL,
355: NULL,

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

349: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
350: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
351: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
352: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
353: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
354: NULL,
355: NULL,
356: NULL,
357: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */

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

2829: 'A', sbl.revenue)),
2830: /*
2831: sum(decode(l_txn_currency_flag,
2832: 'Y', sbl.quantity *
2833: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2834: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2835: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2836: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2837: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

2831: sum(decode(l_txn_currency_flag,
2832: 'Y', sbl.quantity *
2833: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2834: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2835: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2836: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2837: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2838: sum(decode(l_txn_currency_flag,
2839: 'Y', sbl.quantity *

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

2833: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
2834: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2835: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
2836: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2837: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
2838: sum(decode(l_txn_currency_flag,
2839: 'Y', sbl.quantity *
2840: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
2841: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

2843: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2844: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
2845: sum(decode(l_txn_currency_flag,
2846: 'Y', sbl.quantity *
2847: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2848: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2849: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2850: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2851: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */

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

2845: sum(decode(l_txn_currency_flag,
2846: 'Y', sbl.quantity *
2847: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2848: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2849: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2850: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2851: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
2852: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
2853: sum(decode(l_txn_currency_flag,

Line 2851: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */

2847: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
2848: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2849: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
2850: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2851: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
2852: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
2853: sum(decode(l_txn_currency_flag,
2854: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
2855: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))

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

2851: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue */
2852: -- Bug 8937993. Need to pull use source rates for only the plannned quantity.
2853: sum(decode(l_txn_currency_flag,
2854: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
2855: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2856: + NVL(sbl.txn_init_raw_cost,0)), --sbl.txn_raw_cost
2857: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2858: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2859: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost

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

2854: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
2855: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2856: + NVL(sbl.txn_init_raw_cost,0)), --sbl.txn_raw_cost
2857: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2858: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2859: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost
2860: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2862: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))

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

2857: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2858: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2859: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_raw_cost
2860: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))
2862: + NVL(sbl.txn_init_raw_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
2863: )), --sbl.raw_cost
2864: sum(decode(l_txn_currency_flag,
2865: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *

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

2873: + NVL(sbl.txn_init_burdened_cost,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
2874: )), --sbl.burdened_cost
2875: sum(decode(l_txn_currency_flag,
2876: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
2877: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2878: + NVL(sbl.txn_init_revenue,0)), --sbl.txn_revenue
2879: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2880: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2881: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue

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

2876: 'Y', (((sbl.quantity - nvl(sbl.init_quantity,0)) *
2877: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2878: + NVL(sbl.txn_init_revenue,0)), --sbl.txn_revenue
2879: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2880: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2881: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue
2882: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2883: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2884: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))

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

2879: 'N', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2880: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2881: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.project_cost_exchange_rate,1)) , --sbl.project_revenue
2882: 'A', ((((sbl.quantity - nvl(sbl.init_quantity,0)) *
2883: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))
2884: + NVL(sbl.txn_init_revenue,0)) * NVL(sbl.projfunc_cost_exchange_rate,1))
2885: )),
2886: sum(sbl.project_raw_cost),
2887: sum(sbl.project_burdened_cost),

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

2953: 'N', sbl.project_revenue,
2954: 'A', sbl.revenue)),
2955: sum(decode(l_txn_currency_flag,
2956: 'Y', sbl.quantity *
2957: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2958: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2959: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2960: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2961: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),

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

2955: sum(decode(l_txn_currency_flag,
2956: 'Y', sbl.quantity *
2957: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2958: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2959: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2960: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2961: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),
2962: sum(decode(l_txn_currency_flag,
2963: 'Y', sbl.quantity *

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

2957: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2958: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2959: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate),
2960: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2961: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))),
2962: sum(decode(l_txn_currency_flag,
2963: 'Y', sbl.quantity *
2964: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate),
2965: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

2967: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2968: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))),
2969: sum(decode(l_txn_currency_flag,
2970: 'Y', sbl.quantity *
2971: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2972: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2973: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2974: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2975: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),

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

2969: sum(decode(l_txn_currency_flag,
2970: 'Y', sbl.quantity *
2971: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2972: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2973: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2974: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2975: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),
2976: sum(sbl.project_raw_cost),
2977: sum(sbl.project_burdened_cost),

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

2971: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2972: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
2973: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate),
2974: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
2975: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))),
2976: sum(sbl.project_raw_cost),
2977: sum(sbl.project_burdened_cost),
2978: sum(sbl.project_revenue),
2979: sum(sbl.raw_cost),

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

3049: 'N', sbl.project_revenue,
3050: 'A', sbl.revenue)),
3051: sum(decode(l_txn_currency_flag,
3052: 'Y', sbl.quantity *
3053: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3054: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3055: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3056: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3057: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3051: sum(decode(l_txn_currency_flag,
3052: 'Y', sbl.quantity *
3053: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3054: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3055: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3056: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3057: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3058: sum(decode(l_txn_currency_flag,
3059: 'Y', sbl.quantity *

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

3053: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3054: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3055: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3056: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3057: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3058: sum(decode(l_txn_currency_flag,
3059: 'Y', sbl.quantity *
3060: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3061: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

3063: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3064: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3065: sum(decode(l_txn_currency_flag,
3066: 'Y', sbl.quantity *
3067: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3068: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3069: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3070: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3071: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

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

3065: sum(decode(l_txn_currency_flag,
3066: 'Y', sbl.quantity *
3067: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3068: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3069: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3070: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3071: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3072: sum(sbl.project_raw_cost),
3073: sum(sbl.project_burdened_cost),

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

3067: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3068: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3069: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3070: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3071: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3072: sum(sbl.project_raw_cost),
3073: sum(sbl.project_burdened_cost),
3074: sum(sbl.project_revenue),
3075: sum(sbl.raw_cost),

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

3146: 'N', sbl.project_revenue - NVL(sbl.project_init_revenue,0),
3147: 'A', sbl.revenue - NVL(sbl.init_revenue,0))),
3148: sum(decode(l_txn_currency_flag,
3149: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3150: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3151: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3153: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3154: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3148: sum(decode(l_txn_currency_flag,
3149: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3150: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3151: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3153: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3154: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3155: sum(decode(l_txn_currency_flag,
3156: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *

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

3150: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3151: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3152: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3153: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3154: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3155: sum(decode(l_txn_currency_flag,
3156: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3157: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3158: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *

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

3160: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3161: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3162: sum(decode(l_txn_currency_flag,
3163: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3164: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3165: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3166: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3167: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3168: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue

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

3162: sum(decode(l_txn_currency_flag,
3163: 'Y', (sbl.quantity-NVL(sbl.init_quantity,0)) *
3164: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3165: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3166: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3167: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3168: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3169: sum(sbl.project_raw_cost - NVL(sbl.project_init_raw_cost,0)),
3170: sum(sbl.project_burdened_cost - NVL(sbl.project_init_burdened_cost,0)),

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

3164: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.txn_revenue
3165: 'N', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.project_cost_exchange_rate,1) *
3166: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate), --sbl.project_revenue
3167: 'A', (sbl.quantity-NVL(sbl.init_quantity,0)) * NVL(sbl.projfunc_cost_exchange_rate,1) *
3168: NVL(sbl.txn_bill_rate_override,sbl.txn_standard_bill_rate))), --sbl.revenue
3169: sum(sbl.project_raw_cost - NVL(sbl.project_init_raw_cost,0)),
3170: sum(sbl.project_burdened_cost - NVL(sbl.project_init_burdened_cost,0)),
3171: sum(sbl.project_revenue - NVL(sbl.project_init_revenue,0)),
3172: sum(sbl.raw_cost - NVL(sbl.init_raw_cost,0)),