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_POLISH_PVT dependencies on FA_BOOKS_MRC_V

Line 318: fa_books_mrc_v bks

314: select fy.fiscal_year
315: into l_first_fiscal_year
316: from fa_fiscal_year fy,
317: fa_book_controls_mrc_v bc,
318: fa_books_mrc_v bks
319: where bc.book_type_code = p_Book_Type_Code
320: and bc.fiscal_year_name = fy.fiscal_year_name
321: and bks.book_type_code = p_Book_Type_Code
322: and bks.asset_id = p_Asset_Id

Line 330: fa_books_mrc_v bks

326:
327: select dp.period_counter
328: into l_first_period_counter
329: from fa_deprn_periods_mrc_v dp,
330: fa_books_mrc_v bks
331: where dp.book_type_code = p_Book_Type_Code
332: and bks.book_type_code = p_Book_Type_Code
333: and bks.asset_id = p_Asset_Id
334: and bks.transaction_header_id_out is null

Line 395: from fa_books_mrc_v

391: if (p_MRC_SOB_Type_Code = 'R') then
392:
393: select adjusted_cost
394: into l_old_adjusted_cost
395: from fa_books_mrc_v
396: where book_type_code = p_Book_Type_Code
397: and asset_id = p_Asset_Id
398: and transaction_header_id_out is null;
399:

Line 593: from fa_books_mrc_v bks

589: select bks.adjusted_cost,
590: bks.adjusted_recoverable_cost
591: into l_prev_year_adjusted_cost,
592: l_prev_year_adj_rec_cost
593: from fa_books_mrc_v bks
594: where bks.book_type_code = p_Book_Type_Code
595: and bks.asset_id = p_Asset_Id
596: and bks.rowid =
597: (

Line 599: from fa_books_mrc_v bks1,

595: and bks.asset_id = p_Asset_Id
596: and bks.rowid =
597: (
598: select max(bks1.rowid)
599: from fa_books_mrc_v bks1,
600: fa_deprn_periods_mrc_v dp
601: where bks1.book_type_code = p_Book_Type_Code
602: and bks1.asset_id = p_Asset_Id
603: and bks1.book_type_code = dp.book_type_code

Line 620: from fa_books_mrc_v bks

616: select bks.adjusted_cost,
617: bks.adjusted_recoverable_cost
618: into l_prev_year_adjusted_cost,
619: l_prev_year_adj_rec_cost
620: from fa_books_mrc_v bks
621: where bks.book_type_code = p_Book_Type_Code
622: and bks.asset_id = p_Asset_Id
623: and bks.rowid =
624: (

Line 626: from fa_books_mrc_v bks1

622: and bks.asset_id = p_Asset_Id
623: and bks.rowid =
624: (
625: select min(bks1.rowid)
626: from fa_books_mrc_v bks1
627: where bks1.book_type_code = p_Book_Type_Code
628: and bks1.asset_id = p_Asset_Id
629: );
630: exception

Line 764: from fa_books_mrc_v

760: if (p_MRC_SOB_Type_Code = 'R') then
761:
762: select adjusted_cost
763: into l_prev_year_adjusted_cost
764: from fa_books_mrc_v
765: where asset_id = p_asset_id
766: and book_type_code = p_book_type_code
767: and transaction_header_id_out is null;
768:

Line 1422: from fa_books_mrc_v bks

1418: select bks.adjusted_cost,
1419: bks.adjusted_recoverable_cost
1420: into x_prev_basis,
1421: x_prev_adj_rec_cost
1422: from fa_books_mrc_v bks
1423: where bks.book_type_code = p_Book_Type_Code
1424: and bks.asset_id = p_Asset_Id
1425: and bks.rowid =
1426: (

Line 1428: from fa_books_mrc_v bks1,

1424: and bks.asset_id = p_Asset_Id
1425: and bks.rowid =
1426: (
1427: select max(bks1.rowid)
1428: from fa_books_mrc_v bks1,
1429: fa_deprn_periods_mrc_v dp
1430: where bks1.book_type_code = p_Book_Type_Code
1431: and bks1.asset_id = p_Asset_Id
1432: and bks1.book_type_code = dp.book_type_code

Line 1445: from fa_books_mrc_v bks

1441: select bks.adjusted_cost,
1442: bks.adjusted_recoverable_cost
1443: into x_prev_basis,
1444: x_prev_adj_rec_cost
1445: from fa_books_mrc_v bks
1446: where bks.book_type_code = p_Book_Type_Code
1447: and bks.asset_id = p_Asset_Id
1448: and bks.rowid =
1449: (

Line 1451: from fa_books_mrc_v bks1

1447: and bks.asset_id = p_Asset_Id
1448: and bks.rowid =
1449: (
1450: select min(bks1.rowid)
1451: from fa_books_mrc_v bks1
1452: where bks1.book_type_code = p_Book_Type_Code
1453: and bks1.asset_id = p_Asset_Id
1454: );
1455: end;

Line 1670: from fa_books_mrc_v bks

1666: select bks.adjusted_cost,
1667: bks.adjusted_recoverable_cost
1668: into x_prev_basis,
1669: x_prev_adj_rec_cost
1670: from fa_books_mrc_v bks
1671: where bks.book_type_code = p_Book_Type_Code
1672: and bks.asset_id = p_Asset_Id
1673: and bks.rowid =
1674: (

Line 1676: from fa_books_mrc_v bks1,

1672: and bks.asset_id = p_Asset_Id
1673: and bks.rowid =
1674: (
1675: select max(bks1.rowid)
1676: from fa_books_mrc_v bks1,
1677: fa_deprn_periods_mrc_v dp
1678: where bks1.book_type_code = p_Book_Type_Code
1679: and bks1.asset_id = p_Asset_Id
1680: and bks1.book_type_code = dp.book_type_code

Line 1693: from fa_books_mrc_v bks

1689: select bks.adjusted_cost,
1690: bks.adjusted_recoverable_cost
1691: into x_prev_basis,
1692: x_prev_adj_rec_cost
1693: from fa_books_mrc_v bks
1694: where bks.book_type_code = p_Book_Type_Code
1695: and bks.asset_id = p_Asset_Id
1696: and bks.rowid =
1697: (

Line 1699: from fa_books_mrc_v bks1

1695: and bks.asset_id = p_Asset_Id
1696: and bks.rowid =
1697: (
1698: select min(bks1.rowid)
1699: from fa_books_mrc_v bks1
1700: where bks1.book_type_code = p_Book_Type_Code
1701: and bks1.asset_id = p_Asset_Id
1702: );
1703: end;