This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
I want to generate a list of assets which are live. How can I understand that one asset is fully retired(from table). I want to exclude the fully retired assets from the list.
Information about retired assets is kept on table FA_RETIREMENTS. For a fully retired asset a record with STATUS = 'PROCESSED' should exist on this table. Also ADJUSTED_COST cost on table FA_BOOKS is equal to zero.
