Need a query to get FA book, Asset Category, PO Number, Asset Cost, Asset Cost GL account etc
Need a query to get FA book, Asset Category, PO Number, Asset Cost, Asset Cost GL account, Asset Clearing Account, Asset Expense Account (need the latest expense account from the distribution), NBV using any of the the below tables.
fa_additions_b, fa_asset_invoices, fa_book_controls, fa_books, fa_categories_b, fa_category_books, fa_deprn_detail, fa_distribution_accounts, fa_distribution_history, fa_mass_additions, fa_methods, fnd_flex_values, fnd_flex_values_tl, gl_code_combinations
This is important, anyone please respond whether can be achievable or not. If achivable please help me by providing the query.