DBA Data[Home] [Help]

APPS.FARX_RR dependencies on FA_BOOKS

Line 133: fa_books bk,

129: decode(ah.asset_type, 'CIP', NULL, cb.reserve_account_ccid),
130: NULL
131: FROM fa_category_books cb,
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

Line 200: fa_books bk,

196: decode(ah.asset_type, 'CIP', NULL, cb.reserve_account_ccid),
197: th.transaction_header_id
198: FROM fa_category_books cb,
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

Line 269: FROM fa_books bk

265: bk.depreciate_flag,
266: bk.allowed_deprn_limit,
267: bk.allowed_deprn_limit_amount,
268: bk.percent_salvage_value
269: FROM fa_books bk
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

Line 315: FROM fa_books bk

311: bk.depreciate_flag,
312: bk.allowed_deprn_limit,
313: bk.allowed_deprn_limit_amount,
314: bk.percent_salvage_value
315: FROM fa_books bk
316: WHERE bk.asset_id = a_tbl(a_index).asset_id
317: AND bk.book_type_code = a_tbl(a_index).book_type_code
318: AND bk.transaction_header_id_in = h_adj_thid;
319: