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