Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 5 February 2017

Query to Get List of Asset Books by Operating Unit

SELECT "Operating Unit" ,

  fbc.book_type_code "Book Code" ,

  fbc.book_type_name "Book Name" ,

  fbc.book_class "Class" ,


  FROM fa_additions fma ,

    fa_books bks

  WHERE fma.asset_id        = bks.asset_id

  AND bks.book_type_code    = fbc.book_type_code

  AND bks.date_ineffective IS NULL

  ) "Assets" ,

  fbc.last_deprn_run_date "Last Depreciation Run"

FROM gl_code_combinations_kfv gcc ,

  fa_book_controls fbc ,

  gl_sets_of_books sob ,

  fnd_id_flex_structures_tl ifs ,

  fa_deprn_periods fdp ,

  hr_all_organization_units hou

WHERE fbc.set_of_books_id         = sob.set_of_books_id

AND fbc.accounting_flex_structure = ifs.id_flex_num

AND ifs.id_flex_code              = 'GL#'

AND fbc.org_id                    = hou.organization_id (+)

AND fbc.last_period_counter       = fdp.period_counter (+)

AND fbc.book_type_code            = fdp.book_type_code (+)

AND fbc.flexbuilder_defaults_ccid = gcc.code_combination_id (+)


Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  2. Resource Protection alludes to shielding a people and organizations from common decisions by utilizing strategies, frameworks, methods and techniques created from legal law (directed by Congress or state councils) and customary law dependent on court choices.incorporate in nevada

  3. Learn why Phoenix is still one of the best long term real estate markets to invest in and why now is such a great time to invest in real estate in that region.warehouse space for lease near me

  4. Major Thanks for the post. Really thank you! Really Great.
    Custom Notebook Singapore