Query to get Depreciation Reserve, Impairment Reserve and Net Book Value for lease — 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

Query to get Depreciation Reserve, Impairment Reserve and Net Book Value for lease

edited Aug 4, 2025 12:16PM in Assets 3 comments

Summary:


I need a query to retrieve Depreciation Reserve, Impairment Reserve, and Net Book Value for a lease.

The Lease Accounting ERD: Tables List from Oracle is available here:
Lease Accounting ERD PDF

However, the tables like fla_leases_all in the document appears to be empty, so I’m currently using the FA_LEASES (L) and FA_LEASE_BOOKS (B) tables.
So far, I haven’t been able to find the columns that provide the values shown in the screenshot.

How can I retrieve these values?

Content (please ensure you mask any confidential information):


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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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