DBA Data[Home] [Help]

APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_ASSET_HISTORY

Line 215: x_category_id fa_asset_history.category_id%TYPE;

211:
212: x_transaction_header_id_in fa_transaction_headers.transaction_header_id%TYPE;
213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:

Line 216: x_prior_category_id fa_asset_history.category_id%TYPE;

212: x_transaction_header_id_in fa_transaction_headers.transaction_header_id%TYPE;
213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;

Line 217: x_old_category_id fa_asset_history.category_id%TYPE;

213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;

Line 342: fa_asset_history ah,

338: bk.rowid book_rowid
339: FROM fa_transaction_headers th,
340: fa_deprn_periods dp,
341: fa_additions ad,
342: fa_asset_history ah,
343: fa_books bk
344: WHERE dp.book_type_code = pc_tax_book
345: AND dp.period_counter = pc_period_counter
346: AND th.book_type_code = dp.book_type_code

Line 388: fa_asset_history ah,

384: bk.rowid
385: FROM fa_transaction_headers th,
386: fa_deprn_periods dp,
387: fa_additions ad,
388: fa_asset_history ah,
389: fa_books bk
390: WHERE dp.book_type_code = pc_corporate_book
391: AND dp.period_counter = pc_period_counter
392: AND th.book_type_code = dp.book_type_code

Line 460: FROM fa_asset_history

456: pc_transaction_header_id IN NUMBER
457: )
458: IS
459: SELECT category_id
460: FROM fa_asset_history
461: WHERE asset_id = pc_asset_id
462: AND transaction_header_id_out = pc_transaction_header_id;
463:
464: -----------------------------------------------------------------------------

Line 731: fa_asset_history ah,

727: bk.transaction_header_id_in,
728: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
729: bk.rowid book_rowid
730: FROM fa_additions ad,
731: fa_asset_history ah,
732: fa_books bk,
733: fa_deprn_summary ds
734: WHERE ds.book_type_code = pc_book_type_code
735: AND ds.period_counter = pc_period_counter