What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?

in Reporting and Analytics for ERP 1 comment

Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account

Content (please ensure you mask any confidential information):

What tables/column names can we use to fetch following columns to create a custom Fixed Asset report in Oracle Fusion (BIP Report):

  1. Depreciation Method
  2. Asset Cost Center Code
  3. Asset Cost Natural Account 
  4. Asset Depreciation Expense Account

Appreciate if anyone can assist asap, thanks

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications25A (11.13.25.01.0)

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!