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.FA_GAINLOSS_UND_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 122: fa_adjustments_mrc_v faadj,

118: faadj.adjustment_type,
119: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
120: faadj.adjustment_amount
121: FROM
122: fa_adjustments_mrc_v faadj,
123: fa_retirements_mrc_v faret,
124: fa_deprn_periods dp
125: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
126: AND faadj.asset_id = faret.asset_id

Line 148: fa_adjustments_mrc_v faadj,

144: faadj.adjustment_type,
145: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
146: faadj.adjustment_amount
147: FROM
148: fa_adjustments_mrc_v faadj,
149: fa_retirements_mrc_v faret,
150: fa_deprn_periods dp
151: WHERE faadj.transaction_header_id = p_group_thid
152: AND faadj.asset_id = p_group_asset_id

Line 1714: UPDATE fa_adjustments_mrc_v aj

1710: AND aj.book_type_code = h_book
1711: AND aj.distribution_id = h_pdistid
1712: AND aj.transaction_header_id = h_rethdrout;
1713: else
1714: UPDATE fa_adjustments_mrc_v aj
1715: SET distribution_id = h_tdistid
1716: WHERE aj.asset_id = h_asset_id
1717: AND aj.book_type_code = h_book
1718: AND aj.distribution_id = h_pdistid

Line 1751: UPDATE fa_adjustments_mrc_v aj

1747: AND aj.book_type_code = h_book
1748: AND aj.distribution_id = h_pdistid
1749: AND aj.transaction_header_id = h_rethdrout;
1750: else
1751: UPDATE fa_adjustments_mrc_v aj
1752: SET distribution_id = h_tdistid
1753: WHERE aj.asset_id = h_asset_id
1754: AND aj.book_type_code = h_book
1755: AND aj.distribution_id = h_pdistid

Line 2178: UPDATE FA_ADJUSTMENTS_MRC_V

2174: AND nvl (r.assigned_to, -99) = nvl (d.assigned_to, -99)
2175: );
2176:
2177: -- CHECK: this was fa_adjustments table before which i think was wrong
2178: UPDATE FA_ADJUSTMENTS_MRC_V
2179: SET DISTRIBUTION_ID = C1_rec.distribution_id
2180: WHERE TRANSACTION_HEADER_ID = h_rethdrout
2181: AND DISTRIBUTION_ID = l_temp_dist_id1;
2182:

Line 2273: UPDATE FA_ADJUSTMENTS_MRC_V

2269: );
2270:
2271: else
2272:
2273: UPDATE FA_ADJUSTMENTS_MRC_V
2274: SET DISTRIBUTION_ID = h_adj_distid
2275: WHERE TRANSACTION_HEADER_ID = h_rethdrout
2276: AND DISTRIBUTION_ID <> h_adj_distid
2277: AND DISTRIBUTION_ID =

Line 2396: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret

2392: faadj.code_combination_id,
2393: faadj.adjustment_type,
2394: DECODE(faadj.debit_credit_flag, 'DR', 'CR','DR'),
2395: faadj.adjustment_amount
2396: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret
2397: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2398: AND faadj.asset_id = RET.asset_id
2399: AND faadj.book_type_code = faret.book_type_code
2400: AND faadj.source_type_code = decode(RET.wip_asset, 1,

Line 2633: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret

2629: faadj.code_combination_id,
2630: DECODE(faadj.debit_credit_flag, 'DR', 'CR','DR'),
2631: faadj.adjustment_amount,
2632: faadj.adjustment_type
2633: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret
2634: WHERE ((faadj.transaction_header_id = faret.transaction_header_id_in
2635: AND faadj.asset_id = h_asset_id) OR
2636: (faadj.transaction_header_id = l_group_thid
2637: AND faadj.asset_id = bk.group_asset_id))

Line 2807: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret

2803: SELECT
2804: sum(faadj.adjustment_amount*
2805: decode(faadj.debit_credit_flag,'CR',1,-1))
2806: INTO h_reserve
2807: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret
2808: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2809: AND faadj.asset_id = h_asset_id
2810: AND faadj.book_type_code = faret.book_type_code
2811: AND faadj.source_type_code = 'RETIREMENT'

Line 2921: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret

2917: SELECT
2918: sum(faadj.adjustment_amount*
2919: decode(faadj.debit_credit_flag,'CR',1,-1))
2920: INTO h_bonus_reserve
2921: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret
2922: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2923: AND faadj.asset_id = h_asset_id
2924: AND faadj.book_type_code = faret.book_type_code
2925: AND faadj.source_type_code = 'RETIREMENT'

Line 3030: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret

3026: SELECT
3027: sum(faadj.adjustment_amount*
3028: decode(faadj.debit_credit_flag,'CR',1,-1))
3029: INTO h_reval_rsv
3030: FROM fa_adjustments_mrc_v faadj, fa_retirements_mrc_v faret
3031: WHERE faadj.transaction_header_id =
3032: faret.transaction_header_id_in
3033: AND faadj.asset_id = h_asset_id
3034: AND faadj.book_type_code = faret.book_type_code

Line 3262: FA_ADJUSTMENTS_MRC_V adj

3258: nvl(adj.adjustment_amount, 0)
3259: FROM
3260: FA_DISTRIBUTION_HISTORY dh,
3261: FA_ASSET_HISTORY ah,
3262: FA_ADJUSTMENTS_MRC_V adj
3263: WHERE dh.asset_id = RET.asset_id
3264: AND dh.book_type_code = BK.dis_book
3265: AND dh.date_ineffective is null
3266: AND dh.distribution_id = adj.distribution_id(+)

Line 3303: fa_adjustments_mrc_v faadj

3299: faadj.code_combination_id,
3300: - 1 * faadj.adjustment_amount
3301: FROM
3302: fa_distribution_history fadh,
3303: fa_adjustments_mrc_v faadj
3304: WHERE fadh.asset_id(+) = RET.asset_id
3305: AND fadh.book_type_code(+) = BK.dis_book
3306: AND fadh.date_ineffective(+) is null
3307: AND fadh.distribution_id(+) = faadj.distribution_id

Line 3346: fa_adjustments_mrc_v faadj

3342: (ABS(fadh.transaction_units) / faret.units)
3343: * expense_amount -
3344: NVL(faadj.adjustment_amount, 0)
3345: FROM FA_RETIREMENTS_MRC_V faret, fa_distribution_history fadh,
3346: fa_adjustments_mrc_v faadj
3347: WHERE fadh.asset_id = RET.asset_id
3348: AND fadh.book_type_code = BK.dis_book
3349: AND fadh.retirement_id = RET.retirement_id
3350: AND fadh.distribution_id = faadj.distribution_id(+)

Line 3389: FA_ADJUSTMENTS_MRC_V faadj

3385: - 1 * faadj.adjustment_amount
3386: FROM
3387: FA_RETIREMENTS_MRC_V faret,
3388: FA_DISTRIBUTION_HISTORY fadh,
3389: FA_ADJUSTMENTS_MRC_V faadj
3390: WHERE fadh.asset_id(+) = RET.asset_id
3391: AND fadh.book_type_code(+) = BK.dis_book
3392: AND fadh.retirement_id(+) = RET.retirement_id
3393: AND fadh.distribution_id(+) = faadj.distribution_id

Line 4072: FROM fa_adjustments_mrc_v faadj

4068: -1 * faadj.adjustment_amount,
4069: faadj.adjustment_amount),
4070: faadj.adjustment_amount))
4071: INTO h_tot_deprn_adj
4072: FROM fa_adjustments_mrc_v faadj
4073: WHERE faadj.asset_id = RET.asset_id
4074: AND faadj.book_type_code = RET.book
4075: AND faadj.source_type_code = 'RETIREMENT'
4076: AND faadj.adjustment_type in ('RESERVE', 'EXPENSE', 'REVAL EXPENSE')

Line 4121: FROM fa_adjustments_mrc_v faadj

4117: -1 * faadj.adjustment_amount,
4118: faadj.adjustment_amount),
4119: faadj.adjustment_amount))
4120: INTO h_tot_bonus_deprn_adj
4121: FROM fa_adjustments_mrc_v faadj
4122: WHERE faadj.asset_id = RET.asset_id
4123: AND faadj.book_type_code = RET.book
4124: AND faadj.source_type_code = 'RETIREMENT'
4125: AND faadj.adjustment_type in ('BONUS RESERVE', 'BONUS EXPENSE')

Line 4170: FROM fa_adjustments_mrc_v faadj

4166: -1 * faadj.adjustment_amount,
4167: faadj.adjustment_amount),
4168: -1 * faadj.adjustment_amount))
4169: INTO h_tot_reval_adj
4170: FROM fa_adjustments_mrc_v faadj
4171: WHERE faadj.asset_id = RET.asset_id
4172: AND faadj.book_type_code = RET.book
4173: AND faadj.source_type_code = 'RETIREMENT'
4174: AND faadj.adjustment_type in ('REVAL RESERVE', 'REVAL AMORT')