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.FARX_RR dependencies on FA_TRANSACTION_HEADERS

Line 136: fa_transaction_headers th

132: fa_book_controls bc,
133: fa_books bk,
134: fa_asset_history ah,
135: fa_additions ad,
136: fa_transaction_headers th
137: /* mr_rec.conc_request_id will correspond to the request id
138: for the last time the transaction was "run" by the mass
139: reclass program.
140:

Line 165: -- Only corporate book is stored in fa_transaction_headers in case

161: th.transaction_header_id, ah.transaction_header_id_in)
162: AND ah.transaction_header_id_in <= th.transaction_header_id
163: AND nvl(ah.transaction_header_id_out, th.transaction_header_id + 1) >
164: th.transaction_header_id
165: -- Only corporate book is stored in fa_transaction_headers in case
166: -- of basic reclass only(without redefault.)
167: AND bk.asset_id = th.asset_id
168: AND bk.book_type_code = bc.book_type_code
169: AND bc.book_class IN ('CORPORATE', 'TAX')

Line 173: -- basic reclass transaction is recorded in fa_transaction_headers

169: AND bc.book_class IN ('CORPORATE', 'TAX')
170: AND bc.distribution_source_book = th.book_type_code
171: -- Get the book row at the time of reclass run. Need to figure out
172: -- the book row by comparing transaction_header_id's, since only
173: -- basic reclass transaction is recorded in fa_transaction_headers
174: -- table, when redefault is not performed.
175: AND bk.transaction_header_id_in < th.transaction_header_id
176: AND nvl(bk.transaction_header_id_out, th.transaction_header_id + 1) >
177: th.transaction_header_id

Line 203: fa_transaction_headers th

199: fa_book_controls bc,
200: fa_books bk,
201: fa_asset_history ah,
202: fa_additions ad,
203: fa_transaction_headers th
204: /* mr_rec.conc_request_id will correspond to the request id
205: for the last time the transaction was "run" by the mass
206: reclass program.
207: BMR: this is no longer true - see BUG# 2371326

Line 274: -- basic reclass transaction is recorded in fa_transaction_headers

270: WHERE bk.asset_id = a_tbl(a_index).asset_id
271: AND bk.book_type_code = a_tbl(a_index).book_type_code
272: -- Get the book row at the time of reclass run. Need to figure out
273: -- the book row by comparing transaction_header_id's, since only
274: -- basic reclass transaction is recorded in fa_transaction_headers
275: -- table, when redefault is not performed or when rules remain the same.
276: AND bk.transaction_header_id_in < h_rcl_thid
277: AND nvl(bk.transaction_header_id_out, h_rcl_thid + 1) > h_rcl_thid;
278:

Line 282: FROM fa_transaction_headers

278:
279: -- cursor to get ADJUSTMENT transaction header id for redefault transaction.
280: CURSOR get_adjust_thid IS
281: SELECT transaction_header_id
282: FROM fa_transaction_headers
283: -- BMR: BUG# 2371326
284: -- for rerunnability we will show all assets/trxs
285: -- WHERE mass_reference_id = mr_rec.conc_request_id
286: WHERE mass_transaction_id = mr_rec.mass_reclass_id

Line 299: -- is recorded in fa_transaction_headers in this case.)

295: -- cursor to get the book information.
296: -- book_info2 is used when inherit_deprn_rules_flag = 'YES' and
297: -- when redefault transaction was actually performed and caused
298: -- changes in depreciation rules(a separate ADJUSTMENT transaction
299: -- is recorded in fa_transaction_headers in this case.)
300: CURSOR book_info2 IS
301: SELECT bk.book_type_code,
302: bk.prorate_convention_code,
303: bk.ceiling_name,