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_BOOKS

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 1304: element => 'Updating FA_BOOKS',

1300:
1301: if (g_print_debug) then
1302: fa_debug_pkg.add
1303: (fname => l_calling_fn,
1304: element => 'Updating FA_BOOKS',
1305: value => '');
1306: end if;
1307:
1308: /* Replaced this with the following

Line 1310: UPDATE FA_BOOKS

1306: end if;
1307:
1308: /* Replaced this with the following
1309: if (h_mrc_primary_book_flag = 1) then
1310: UPDATE FA_BOOKS
1311: SET date_ineffective = h_today, -- to_date(h_today,'DD/MM/YYYY hh24:mi:ss'),
1312: transaction_header_id_out = h_rethdrout,
1313: last_updated_by = h_user_id,
1314: last_update_date = h_today -- to_date(h_today, 'DD/MM/YYYY hh24:mi:ss')

Line 1323: element => 'Deactivate fa_books row',

1319: */
1320: if (g_print_debug) then
1321: fa_debug_pkg.add
1322: (fname => l_calling_fn,
1323: element => 'Deactivate fa_books row',
1324: value => '');
1325: end if;
1326:
1327: if (g_print_debug) then

Line 1339: from fa_books

1335: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1336: if ret.mrc_sob_type_code <> 'R' then
1337: select nvl(rate_in_use,0)
1338: into l_rate_in_use
1339: from fa_books
1340: where asset_id = ret.asset_id
1341: and book_type_code = ret.book
1342: and transaction_header_id_out is null;
1343:

Line 1352: from fa_books_mrc_v

1348: else -- for reporting
1349: -- MRC
1350: /*select nvl(rate_in_use,0)
1351: into l_rate_in_use
1352: from fa_books_mrc_v
1353: where asset_id = ret.asset_id
1354: and book_type_code = ret.book
1355: and transaction_header_id_out is null;*/
1356:

Line 1365: fa_books_pkg.deactivate_row

1361: end if;
1362: -- Bug:6665510:Japan Tax Reform Project (End)
1363:
1364: -- terminate the active row
1365: fa_books_pkg.deactivate_row
1366: (X_asset_id => h_asset_id,
1367: X_book_type_code => h_book,
1368: X_transaction_header_id_out => h_rethdrout,
1369: X_date_ineffective => h_today,

Line 1378: element => 'Create a new fa_books row',

1374:
1375: if (g_print_debug) then
1376: fa_debug_pkg.add
1377: (fname => l_calling_fn,
1378: element => 'Create a new fa_books row',
1379: value => '');
1380: end if;
1381:
1382: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books

Line 1382: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books

1378: element => 'Create a new fa_books row',
1379: value => '');
1380: end if;
1381:
1382: /* Fix for Bug# 2513013: When reinstated, a newly created row in fa_books
1383: * had null in period_counter_life_complete since this was missing in the following insert.
1384: */
1385:
1386: if ret.mrc_sob_type_code <> 'R' then

Line 1387: INSERT into fa_books

1383: * had null in period_counter_life_complete since this was missing in the following insert.
1384: */
1385:
1386: if ret.mrc_sob_type_code <> 'R' then
1387: INSERT into fa_books
1388: (book_type_Code, asset_id, date_placed_in_service,
1389: transaction_header_id_in, date_effective, transaction_header_id_out,
1390: date_ineffective, deprn_start_date, deprn_method_code,
1391: life_in_months, rate_adjustment_factor, adjusted_cost, cost,

Line 1510: FROM fa_books

1506: , retirement_deprn_option
1507: , p_asset_fin_rec_new.adjusted_recoverable_cost /* fix for bug 3149457 */
1508: , extended_deprn_flag -- Japan Tax Phase3
1509: , extended_depreciation_period -- Japan Tax Phase3
1510: FROM fa_books
1511: WHERE asset_id = ret.asset_id
1512: AND book_type_code = ret.book
1513: AND transaction_header_id_out = h_rethdrout;
1514: else -- for reporting

Line 1515: INSERT into fa_books_mrc_v

1511: WHERE asset_id = ret.asset_id
1512: AND book_type_code = ret.book
1513: AND transaction_header_id_out = h_rethdrout;
1514: else -- for reporting
1515: INSERT into fa_books_mrc_v
1516: (book_type_Code, asset_id, date_placed_in_service,
1517: transaction_header_id_in, date_effective, transaction_header_id_out,
1518: date_ineffective, deprn_start_date, deprn_method_code,
1519: life_in_months, rate_adjustment_factor, adjusted_cost, cost,

Line 1626: FROM fa_books_mrc_v

1622: , eop_formula_factor
1623: , exclude_proceeds_from_basis
1624: , retirement_deprn_option
1625: , p_asset_fin_rec_new.adjusted_recoverable_cost /* fix for bug 3149457 */
1626: FROM fa_books_mrc_v
1627: WHERE asset_id = ret.asset_id
1628: AND book_type_code = ret.book
1629: AND transaction_header_id_out = h_rethdrout;
1630: end if;

Line 1649: update fa_books

1645:
1646: -- Bug:6665510:Japan Tax Reform Project (Start)
1647: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1648: if ret.mrc_sob_type_code <> 'R' then
1649: update fa_books
1650: set rate_in_use = l_rate_in_use
1651: where asset_id = ret.asset_id
1652: and book_type_code = ret.Book
1653: and transaction_header_id_out is null;

Line 1661: /*update fa_books_mrc_v

1657: end if;
1658:
1659: else -- For Reporting
1660: -- TO DO -- MRC
1661: /*update fa_books_mrc_v
1662: set rate_in_use = l_rate_in_use
1663: where asset_id = ret.asset_id
1664: and book_type_code = ret.Book
1665: and transaction_header_id_out is null;*/