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_ASSET_HISTORY

Line 572: element => 'Get category from fa_asset_history',

568:
569: if (p_log_level_rec.statement_level) then
570: fa_debug_pkg.add
571: (fname => l_calling_fn,
572: element => 'Get category from fa_asset_history',
573: value => '', p_log_level_rec => p_log_level_rec);
574: end if;
575:
576: if (p_log_level_rec.statement_level) then

Line 585: FROM fa_asset_history

581: end if;
582:
583: SELECT category_id
584: INTO h_category_id
585: FROM fa_asset_history
586: WHERE asset_id = RET.asset_id
587: AND date_ineffective is null;
588:
589: if (p_log_level_rec.statement_level) then

Line 2186: -- UPDATING FA_ASSET_HISTORY,

2182: element => '+++ Step 5',
2183: value => '', p_log_level_rec => p_log_level_rec);
2184: end if;
2185:
2186: -- UPDATING FA_ASSET_HISTORY,
2187: -- INSERTING FA_ASSET_HISTORY,
2188: -- UPDATING FA_ADDITIONS
2189: -- if (h_mrc_primary_book_flag = 1) then
2190: if (ret.mrc_sob_type_code <> 'R') then

Line 2187: -- INSERTING FA_ASSET_HISTORY,

2183: value => '', p_log_level_rec => p_log_level_rec);
2184: end if;
2185:
2186: -- UPDATING FA_ASSET_HISTORY,
2187: -- INSERTING FA_ASSET_HISTORY,
2188: -- UPDATING FA_ADDITIONS
2189: -- if (h_mrc_primary_book_flag = 1) then
2190: if (ret.mrc_sob_type_code <> 'R') then
2191:

Line 2202: from fa_asset_history

2198:
2199: -- select rowidtochar(rowid)
2200: select rowid
2201: into h_rowid
2202: from fa_asset_history
2203: where asset_id = RET.asset_id
2204: and date_ineffective is null;
2205:
2206: if p_log_level_rec.statement_level then

Line 2213: update fa_asset_history

2209: element => '+++ Step 5.1.5',
2210: value => '', p_log_level_rec => p_log_level_rec);
2211: end if;
2212:
2213: update fa_asset_history
2214: set date_ineffective = today,
2215: transaction_header_id_out = h_rethdrout
2216: where rowid = h_rowid;
2217:

Line 2225: insert into fa_asset_history

2221: element => '+++ Step 5.2',
2222: value => '', p_log_level_rec => p_log_level_rec);
2223: end if;
2224:
2225: insert into fa_asset_history
2226: (asset_id, category_id, units, asset_type,
2227: date_effective, date_ineffective, last_update_date,
2228: last_updated_by,transaction_header_id_in
2229: )

Line 2234: from fa_asset_history

2230: select asset_id, category_id, units + RET.units_retired,
2231: asset_type, today,
2232: null, today,
2233: user_id, h_rethdrout
2234: from fa_asset_history
2235: where rowid = h_rowid;
2236:
2237: if p_log_level_rec.statement_level then
2238: fa_debug_pkg.add

Line 2261: -- END UPDATING FA_ASSET_HISTORY,

2257: value => '', p_log_level_rec => p_log_level_rec);
2258: end if;
2259:
2260: end if;
2261: -- END UPDATING FA_ASSET_HISTORY,
2262: -- END INSERTING FA_ASSET_HISTORY,
2263: -- END UPDATING FA_ADDITIONS
2264:
2265: if p_log_level_rec.statement_level then

Line 2262: -- END INSERTING FA_ASSET_HISTORY,

2258: end if;
2259:
2260: end if;
2261: -- END UPDATING FA_ASSET_HISTORY,
2262: -- END INSERTING FA_ASSET_HISTORY,
2263: -- END UPDATING FA_ADDITIONS
2264:
2265: if p_log_level_rec.statement_level then
2266: fa_debug_pkg.add

Line 3320: element => 'Get category from fa_asset_history',

3316:
3317: if p_log_level_rec.statement_level then
3318: fa_debug_pkg.add
3319: (fname => l_calling_fn,
3320: element => 'Get category from fa_asset_history',
3321: value => '', p_log_level_rec => p_log_level_rec);
3322: end if;
3323:
3324: SELECT category_id

Line 3326: FROM fa_asset_history

3322: end if;
3323:
3324: SELECT category_id
3325: INTO h_category_id
3326: FROM fa_asset_history
3327: WHERE asset_id = RET.asset_id
3328: AND date_ineffective is null;
3329:
3330: adj_row.account := NULL;

Line 3553: FA_ASSET_HISTORY ah,

3549: (dh.units_assigned / ah.units)
3550: * expense_amount --Bug 6666666
3551: FROM
3552: FA_DISTRIBUTION_HISTORY dh,
3553: FA_ASSET_HISTORY ah,
3554: FA_ADJUSTMENTS adj
3555: WHERE dh.asset_id = RET.asset_id
3556: AND dh.book_type_code = BK.dis_book
3557: AND dh.date_ineffective is null

Line 3573: ,FA_ASSET_HISTORY ah

3569: dh.code_combination_id,
3570: ((1/(1-h_cost_frac))-1) * nvl(adj.adjustment_amount, 0),
3571: 0 -- Bug 6666666
3572: FROM FA_DISTRIBUTION_HISTORY dh
3573: ,FA_ASSET_HISTORY ah
3574: ,FA_TRANSACTION_HEADERS ret_th
3575: ,FA_ADJUSTMENTS adj
3576: ,FA_TRANSACTION_HEADERS exp_th
3577: WHERE dh.asset_id = RET.asset_id

Line 3610: FA_ASSET_HISTORY ah,

3606: (dh.units_assigned / ah.units)
3607: * expense_amount -- Bug 6666666
3608: FROM
3609: FA_DISTRIBUTION_HISTORY dh,
3610: FA_ASSET_HISTORY ah,
3611: FA_MC_ADJUSTMENTS adj
3612: WHERE dh.asset_id = RET.asset_id
3613: AND dh.book_type_code = BK.dis_book
3614: AND dh.date_ineffective is null

Line 3632: FA_ASSET_HISTORY ah,

3628: ((1/(1-h_cost_frac))-1) * nvl(adj.adjustment_amount, 0),
3629: 0 -- Bug 6666666
3630: FROM
3631: FA_DISTRIBUTION_HISTORY dh,
3632: FA_ASSET_HISTORY ah,
3633: FA_MC_ADJUSTMENTS adj -- bug#5094783 fix
3634: WHERE dh.asset_id = RET.asset_id
3635: AND dh.book_type_code = BK.dis_book
3636: AND dh.date_ineffective is null

Line 3865: FROM fa_asset_history

3861: -- old structs are kept here.
3862:
3863: SELECT category_id
3864: INTO h_category_id
3865: FROM fa_asset_history
3866: WHERE asset_id = RET.asset_id
3867: AND date_ineffective is null;
3868:
3869: if not fa_cache_pkg.fazccb(