ERPstuff - Oracle EBS Community

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.

Pls. advice.

Thanks in advance.

Amitava

Hello Amitava.

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.

Hope this helps.
Octavio