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.

[Home] [Help]

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_RETIREMENTS_MRC_V

Line 123: fa_retirements_mrc_v faret,

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
127: AND faadj.book_type_Code = faret.book_type_code

Line 149: fa_retirements_mrc_v faret,

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
153: AND faadj.book_type_Code = faret.book_type_code

Line 192: UPDATE FA_RETIREMENTS_MRC_V

188: last_update_date = today,
189: last_updated_by = user_id
190: WHERE retirement_id = ret.retirement_id;
191: else
192: UPDATE FA_RETIREMENTS_MRC_V
193: SET status = 'DELETED',
194: last_update_date = today,
195: last_updated_by = user_id
196: WHERE retirement_id = ret.retirement_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 3345: FROM FA_RETIREMENTS_MRC_V faret, fa_distribution_history fadh,

3341: fadh.code_combination_id,
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

Line 3387: FA_RETIREMENTS_MRC_V faret,

3383: faadj.distribution_id,
3384: faadj.code_combination_id,
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