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_MC_BOOKS

Line 430: fa_mc_books bks

426: into l_first_fiscal_year
427: from fa_fiscal_year fy,
428: fa_mc_book_controls mbc,
429: fa_book_controls bc,
430: fa_mc_books bks
431: where bc.book_type_code = p_Book_Type_Code
432: and mbc.book_type_code = p_Book_Type_Code
433: and bc.fiscal_year_name = fy.fiscal_year_name
434: and mbc.set_of_books_id = p_set_of_books_id

Line 445: fa_mc_books bks

441:
442: select dp.period_counter
443: into l_first_period_counter
444: from fa_mc_deprn_periods dp,
445: fa_mc_books bks
446: where dp.book_type_code = p_Book_Type_Code
447: and dp.set_of_books_id = p_set_of_books_id
448: and bks.book_type_code = p_Book_Type_Code
449: and bks.asset_id = p_Asset_Id

Line 513: from fa_mc_books

509: if (p_MRC_SOB_Type_Code = 'R') then
510:
511: select adjusted_cost
512: into l_old_adjusted_cost
513: from fa_mc_books
514: where book_type_code = p_Book_Type_Code
515: and asset_id = p_Asset_Id
516: and transaction_header_id_out is null
517: and set_of_books_id = p_set_of_books_id;

Line 688: from fa_mc_books_summary

684: select polish_deprn_basis,
685: polish_adj_rec_cost
686: into l_prev_year_adjusted_cost,
687: l_prev_year_adj_rec_cost
688: from fa_mc_books_summary
689: where book_type_code = p_Book_Type_Code
690: and asset_id = p_Asset_Id
691: and period_counter = l_prev_year_period_counter
692: and set_of_books_id = p_set_of_books_id;

Line 723: from fa_mc_books bks

719: select bks.adjusted_cost,
720: bks.adjusted_recoverable_cost
721: into l_prev_year_adjusted_cost,
722: l_prev_year_adj_rec_cost
723: from fa_mc_books bks
724: where bks.book_type_code = p_Book_Type_Code
725: and bks.asset_id = p_Asset_Id
726: and bks.set_of_books_id = p_set_of_books_id
727: and bks.rowid =

Line 730: from fa_mc_books bks1,

726: and bks.set_of_books_id = p_set_of_books_id
727: and bks.rowid =
728: (
729: select max(bks1.rowid)
730: from fa_mc_books bks1,
731: fa_mc_deprn_periods dp
732: where bks1.book_type_code = p_Book_Type_Code
733: and bks1.asset_id = p_Asset_Id
734: and bks1.book_type_code = dp.book_type_code

Line 753: from fa_mc_books bks

749: select bks.adjusted_cost,
750: bks.adjusted_recoverable_cost
751: into l_prev_year_adjusted_cost,
752: l_prev_year_adj_rec_cost
753: from fa_mc_books bks
754: where bks.book_type_code = p_Book_Type_Code
755: and bks.asset_id = p_Asset_Id
756: and bks.set_of_books_id = p_set_of_books_id
757: and bks.rowid =

Line 760: from fa_mc_books bks1

756: and bks.set_of_books_id = p_set_of_books_id
757: and bks.rowid =
758: (
759: select min(bks1.rowid)
760: from fa_mc_books bks1
761: where bks1.book_type_code = p_Book_Type_Code
762: and bks1.asset_id = p_Asset_Id
763: and bks1.set_of_books_id = p_set_of_books_id
764: );

Line 908: from fa_mc_books

904: if (p_MRC_SOB_Type_Code = 'R') then
905:
906: select adjusted_cost
907: into l_prev_year_adjusted_cost
908: from fa_mc_books
909: where asset_id = p_asset_id
910: and book_type_code = p_book_type_code
911: and transaction_header_id_out is null
912: and set_of_books_id = p_set_of_books_id;

Line 1543: from fa_mc_books_summary

1539: select polish_deprn_basis,
1540: polish_adj_rec_cost
1541: into x_prev_basis,
1542: x_prev_adj_rec_cost
1543: from fa_mc_books_summary
1544: where book_type_code = p_Book_Type_Code
1545: and asset_id = p_Asset_Id
1546: and period_counter = x_bef_trxn_period_counter
1547: and set_of_books_id = p_set_of_books_id;

Line 1580: from fa_mc_books bks

1576: select bks.adjusted_cost,
1577: bks.adjusted_recoverable_cost
1578: into x_prev_basis,
1579: x_prev_adj_rec_cost
1580: from fa_mc_books bks
1581: where bks.book_type_code = p_Book_Type_Code
1582: and bks.asset_id = p_Asset_Id
1583: and bks.set_of_books_id = p_set_of_books_id
1584: and bks.rowid =

Line 1587: from fa_mc_books bks1,

1583: and bks.set_of_books_id = p_set_of_books_id
1584: and bks.rowid =
1585: (
1586: select max(bks1.rowid)
1587: from fa_mc_books bks1,
1588: fa_mc_deprn_periods dp
1589: where bks1.book_type_code = p_Book_Type_Code
1590: and bks1.asset_id = p_Asset_Id
1591: and bks1.book_type_code = dp.book_type_code

Line 1606: from fa_mc_books bks

1602: select bks.adjusted_cost,
1603: bks.adjusted_recoverable_cost
1604: into x_prev_basis,
1605: x_prev_adj_rec_cost
1606: from fa_mc_books bks
1607: where bks.book_type_code = p_Book_Type_Code
1608: and bks.asset_id = p_Asset_Id
1609: and bks.set_of_books_id = p_set_of_books_id
1610: and bks.rowid =

Line 1613: from fa_mc_books bks1

1609: and bks.set_of_books_id = p_set_of_books_id
1610: and bks.rowid =
1611: (
1612: select min(bks1.rowid)
1613: from fa_mc_books bks1
1614: where bks1.book_type_code = p_Book_Type_Code
1615: and bks1.asset_id = p_Asset_Id
1616: and bks.set_of_books_id = p_set_of_books_id
1617: );

Line 1814: from fa_mc_books_summary

1810: select polish_deprn_basis,
1811: polish_adj_rec_cost
1812: into x_prev_basis,
1813: x_prev_adj_rec_cost
1814: from fa_mc_books_summary
1815: where book_type_code = p_Book_Type_Code
1816: and asset_id = p_Asset_Id
1817: and period_counter = x_bef_trxn_period_counter
1818: and set_of_books_id = p_set_of_books_id;

Line 1851: from fa_mc_books bks

1847: select bks.adjusted_cost,
1848: bks.adjusted_recoverable_cost
1849: into x_prev_basis,
1850: x_prev_adj_rec_cost
1851: from fa_mc_books bks
1852: where bks.book_type_code = p_Book_Type_Code
1853: and bks.asset_id = p_Asset_Id
1854: and bks.set_of_books_id = p_set_of_books_id
1855: and bks.rowid =

Line 1858: from fa_mc_books bks1,

1854: and bks.set_of_books_id = p_set_of_books_id
1855: and bks.rowid =
1856: (
1857: select max(bks1.rowid)
1858: from fa_mc_books bks1,
1859: fa_mc_deprn_periods dp
1860: where bks1.book_type_code = p_Book_Type_Code
1861: and bks1.asset_id = p_Asset_Id
1862: and bks1.set_of_books_id = p_set_of_books_id

Line 1877: from fa_mc_books bks

1873: select bks.adjusted_cost,
1874: bks.adjusted_recoverable_cost
1875: into x_prev_basis,
1876: x_prev_adj_rec_cost
1877: from fa_mc_books bks
1878: where bks.book_type_code = p_Book_Type_Code
1879: and bks.asset_id = p_Asset_Id
1880: and bks.set_of_books_id = p_set_of_books_id
1881: and bks.rowid =

Line 1884: from fa_mc_books bks1

1880: and bks.set_of_books_id = p_set_of_books_id
1881: and bks.rowid =
1882: (
1883: select min(bks1.rowid)
1884: from fa_mc_books bks1
1885: where bks1.book_type_code = p_Book_Type_Code
1886: and bks1.asset_id = p_Asset_Id
1887: and bks1.set_of_books_id = p_set_of_books_id
1888: );

Line 2134: from fa_mc_books_summary

2130: begin
2131:
2132: select nvl(switch_code, 'XX')
2133: into x_switch_code
2134: from fa_mc_books_summary
2135: where book_type_code = p_book_type_code
2136: and asset_id = p_asset_id
2137: and period_counter = p_period_counter
2138: and set_of_books_id = p_set_of_books_id;

Line 2166: from fa_mc_books_summary

2162:
2163: begin
2164: select nvl(switch_code, 'XX')
2165: into l_prev_switch_code
2166: from fa_mc_books_summary
2167: where book_type_code = p_book_type_code
2168: and asset_id = p_asset_id
2169: and period_counter = p_period_counter - 1
2170: and set_of_books_id = p_set_of_books_id;