DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on STANDARD

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

3785: 'N', sbl.project_burdened_cost,
3786: 'A', sbl.burdened_cost)),
3787: sum(decode(l_txn_currency_flag,
3788: 'Y', sbl.quantity *
3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3787: sum(decode(l_txn_currency_flag,
3788: 'Y', sbl.quantity *
3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3794: sum(decode(l_txn_currency_flag,
3795: 'Y', sbl.quantity *

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

3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3794: sum(decode(l_txn_currency_flag,
3795: 'Y', sbl.quantity *
3796: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3797: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

3853: 'N', sbl.project_burdened_cost,
3854: 'A', sbl.burdened_cost)),
3855: sum(decode(l_txn_currency_flag,
3856: 'Y', sbl.quantity *
3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3855: sum(decode(l_txn_currency_flag,
3856: 'Y', sbl.quantity *
3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3862: sum(decode(l_txn_currency_flag,
3863: 'Y', sbl.quantity *

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

3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3862: sum(decode(l_txn_currency_flag,
3863: 'Y', sbl.quantity *
3864: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3865: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

3921: 'N', sbl.project_burdened_cost,
3922: 'A', sbl.burdened_cost)),
3923: sum(decode(l_txn_currency_flag,
3924: 'Y', sbl.quantity *
3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3923: sum(decode(l_txn_currency_flag,
3924: 'Y', sbl.quantity *
3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3930: sum(decode(l_txn_currency_flag,
3931: 'Y', sbl.quantity *

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

3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3930: sum(decode(l_txn_currency_flag,
3931: 'Y', sbl.quantity *
3932: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3933: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

3994: 'N', sbl.project_burdened_cost,
3995: 'A', sbl.burdened_cost)),
3996: sum(decode(l_txn_currency_flag,
3997: 'Y', sbl.quantity *
3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost

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

3996: sum(decode(l_txn_currency_flag,
3997: 'Y', sbl.quantity *
3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
4003: sum(decode(l_txn_currency_flag,
4004: 'Y', sbl.quantity *

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

3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
4003: sum(decode(l_txn_currency_flag,
4004: 'Y', sbl.quantity *
4005: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4006: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

4066: 'N', sbl.project_burdened_cost,
4067: 'A', sbl.burdened_cost))/pa_gl.multiplier),
4068: sum((decode(l_txn_currency_flag,
4069: 'Y', sbl.quantity *
4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost

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

4068: sum((decode(l_txn_currency_flag,
4069: 'Y', sbl.quantity *
4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4075: sum((decode(l_txn_currency_flag,
4076: 'Y', sbl.quantity *

Line 4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost

4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4075: sum((decode(l_txn_currency_flag,
4076: 'Y', sbl.quantity *
4077: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4078: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *

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

4139: 'N', sbl.project_burdened_cost,
4140: 'A', sbl.burdened_cost))/pa_gl.multiplier),
4141: sum((decode(l_txn_currency_flag,
4142: 'Y', sbl.quantity *
4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost

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

4141: sum((decode(l_txn_currency_flag,
4142: 'Y', sbl.quantity *
4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4148: sum((decode(l_txn_currency_flag,
4149: 'Y', sbl.quantity *

Line 4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost

4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4148: sum((decode(l_txn_currency_flag,
4149: 'Y', sbl.quantity *
4150: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4151: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *