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_RETIREMENTS

Line 70: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

66: faadj.adjustment_type,
67: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
68: faadj.adjustment_amount
69: FROM
70: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
71: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
72: AND faadj.asset_id = faret.asset_id
73: AND faadj.book_type_Code = faret.book_type_code
74: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 94: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

90: faadj.adjustment_type,
91: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
92: faadj.adjustment_amount
93: FROM
94: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
95: WHERE faadj.transaction_header_id = p_group_thid
96: AND faadj.asset_id = p_group_asset_id
97: AND faadj.book_type_Code = faret.book_type_code
98: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

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 181: element => 'Updating fa_retirements',

177:
178: if (g_print_debug) then
179: fa_debug_pkg.add
180: (fname => l_calling_fn,
181: element => 'Updating fa_retirements',
182: value => '');
183: end if;
184:
185: if (ret.mrc_sob_type_code <> 'R') then

Line 186: UPDATE FA_RETIREMENTS

182: value => '');
183: end if;
184:
185: if (ret.mrc_sob_type_code <> 'R') then
186: UPDATE FA_RETIREMENTS
187: SET status = 'DELETED',
188: last_update_date = today,
189: last_updated_by = user_id
190: WHERE retirement_id = ret.retirement_id;

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 203: from fa_retirements

199: -- Get thid_out from fa_rets
200: -- this can never be different for primary and reporting book
201: select transaction_header_id_out
202: into h_th_id_out
203: from fa_retirements
204: where retirement_id = h_ret_id;
205:
206: if ret.wip_asset > 0 then
207: adj_row.source_type_code := 'CIP RETIREMENT';

Line 374: FROM fa_book_controls bc, fa_retirements retire, fa_books bk

370: bc.book_type_code,
371: retire.transaction_header_id_out,
372: retire.transaction_header_id_in,
373: bk.group_asset_id
374: FROM fa_book_controls bc, fa_retirements retire, fa_books bk
375: WHERE
376: retire.retirement_id = RET.retirement_id
377: AND retire.units is not null
378: AND bc.distribution_source_book = retire.book_type_code

Line 1158: fa_retirements rt

1154: CURSOR PRET IS
1155: SELECT dh.distribution_id
1156: FROM fa_distribution_history dh,
1157: fa_book_controls bc,
1158: fa_retirements rt
1159: WHERE dh.asset_id = h_asset_id
1160: AND dh.book_type_code = bc.distribution_source_book
1161: AND bc.book_type_code = h_book
1162: AND rt.asset_id = dh.asset_id

Line 1298: FROM fa_retirements

1294:
1295: SELECT
1296: transaction_header_id_out
1297: INTO h_rethdrout
1298: FROM fa_retirements
1299: WHERE retirement_id = h_ret_id;
1300:
1301: if (g_print_debug) then
1302: fa_debug_pkg.add

Line 2380: FROM fa_adjustments faadj, fa_retirements faret

2376: faadj.code_combination_id,
2377: faadj.adjustment_type,
2378: DECODE(faadj.debit_credit_flag, 'DR', 'CR','DR'),
2379: faadj.adjustment_amount
2380: FROM fa_adjustments faadj, fa_retirements faret
2381: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2382: AND faadj.asset_id = RET.asset_id
2383: AND faadj.book_type_code = faret.book_type_code
2384: AND faadj.source_type_code = decode(RET.wip_asset, 1,

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 2425: from fa_retirements

2421: end if;
2422:
2423: select transaction_header_id_out
2424: into h_th_id_out
2425: from fa_retirements
2426: where retirement_id = h_retirement_id;
2427:
2428: /* Bug 843625 fix */
2429: if RET.wip_asset > 0 then

Line 2614: FROM fa_adjustments faadj, fa_retirements faret

2610: faadj.code_combination_id,
2611: DECODE(faadj.debit_credit_flag, 'DR', 'CR','DR'),
2612: faadj.adjustment_amount,
2613: faadj.adjustment_type
2614: FROM fa_adjustments faadj, fa_retirements faret
2615: WHERE ((faadj.transaction_header_id = faret.transaction_header_id_in
2616: AND faadj.asset_id = h_asset_id) OR
2617: (faadj.transaction_header_id = l_group_thid
2618: AND faadj.asset_id = bk.group_asset_id))

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 2665: from fa_retirements

2661:
2662: begin
2663: select transaction_header_id_out
2664: into h_th_id_out
2665: from fa_retirements
2666: where retirement_id = h_retirement_id;
2667: EXCEPTION
2668: when no_data_found then
2669: raise fagiav_error;

Line 2785: FROM fa_adjustments faadj, fa_retirements faret

2781: SELECT
2782: sum(faadj.adjustment_amount*
2783: decode(faadj.debit_credit_flag,'CR',1,-1))
2784: INTO h_reserve
2785: FROM fa_adjustments faadj, fa_retirements faret
2786: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2787: AND faadj.asset_id = h_asset_id
2788: AND faadj.book_type_code = faret.book_type_code
2789: AND faadj.source_type_code = 'RETIREMENT'

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 2899: FROM fa_adjustments faadj, fa_retirements faret

2895: SELECT
2896: sum(faadj.adjustment_amount*
2897: decode(faadj.debit_credit_flag,'CR',1,-1))
2898: INTO h_bonus_reserve
2899: FROM fa_adjustments faadj, fa_retirements faret
2900: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
2901: AND faadj.asset_id = h_asset_id
2902: AND faadj.book_type_code = faret.book_type_code
2903: 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 3014: FROM fa_adjustments faadj, fa_retirements faret

3010: SELECT
3011: sum(faadj.adjustment_amount*
3012: decode(faadj.debit_credit_flag,'CR',1,-1))
3013: INTO h_reval_rsv
3014: FROM fa_adjustments faadj, fa_retirements faret
3015: WHERE faadj.transaction_header_id =
3016: faret.transaction_header_id_in
3017: AND faadj.asset_id = h_asset_id
3018: AND faadj.book_type_code = faret.book_type_code

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 3324: FROM FA_RETIREMENTS faret, fa_distribution_history fadh,

3320: fadh.code_combination_id,
3321: (ABS(fadh.transaction_units) / faret.units)
3322: * expense_amount -
3323: NVL(faadj.adjustment_amount, 0)
3324: FROM FA_RETIREMENTS faret, fa_distribution_history fadh,
3325: fa_adjustments faadj
3326: WHERE fadh.asset_id = RET.asset_id
3327: AND fadh.book_type_code = BK.dis_book
3328: AND fadh.retirement_id = RET.retirement_id

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 3365: FA_RETIREMENTS faret,

3361: faadj.distribution_id,
3362: faadj.code_combination_id,
3363: - 1 * faadj.adjustment_amount
3364: FROM
3365: FA_RETIREMENTS faret,
3366: FA_DISTRIBUTION_HISTORY fadh,
3367: FA_ADJUSTMENTS faadj
3368: WHERE fadh.asset_id(+) = RET.asset_id
3369: AND fadh.book_type_code(+) = BK.dis_book

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

Line 3428: from fa_retirements

3424: end if;
3425:
3426: select transaction_header_id_out
3427: into h_th_id_out
3428: from fa_retirements
3429: where retirement_id = h_retirement_id;
3430:
3431:
3432: --The following statement will insert rows into FA_ADJUSTMENTS for