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.JA_CN_FA_BI_EXPORT_PKG dependencies on FA_CATEGORY_BOOKS

Line 69: ,fa_category_books fcb

65: -- to get the fixed asset account
66: CURSOR fixed_asset_account_cur IS
67: SELECT DISTINCT fcb.asset_cost_acct
68: FROM fa_book_controls_sec fbcs
69: ,fa_category_books fcb
70: ,fa_additions_v fav
71: WHERE fbcs.book_type_code = fcb.book_type_code
72: AND fbcs.set_of_books_id = pn_ledger_id
73: AND fbcs.book_class IN ('CORPORATE', 'TAX')

Line 117: ,fa_category_books fcb

113: -- to get the accumulated impairment account
114: CURSOR impairment_account_cur IS
115: SELECT DISTINCT fcb.impair_reserve_acct
116: FROM fa_book_controls_sec fbcs
117: ,fa_category_books fcb
118: ,fa_additions_v fav
119: WHERE fbcs.book_type_code = fcb.book_type_code
120: AND fbcs.set_of_books_id = pn_ledger_id
121: AND fbcs.book_class IN ('CORPORATE', 'TAX')

Line 165: ,fa_category_books fcb

161: -- to get the accumulated depreciation account
162: CURSOR depreciation_account_cur IS
163: SELECT DISTINCT fcb.deprn_reserve_acct
164: FROM fa_book_controls_sec fbcs
165: ,fa_category_books fcb
166: ,fa_additions_v fav
167: WHERE fbcs.book_type_code = fcb.book_type_code
168: AND fbcs.set_of_books_id = pn_ledger_id
169: AND fbcs.book_class IN ('CORPORATE', 'TAX')