Date check for Active assets( Not retired assets)

Hi ,

I want to extract all the active assets till date (sysdate). In which table i need to keep the date check?

I am using the date check part  by following query. Please check whether it will only extract the active assets till sysdate.

SELECT asset_id FROM FA_ASSET_HISTORY FAH, FA_ADDITIONS ADWHERE FAH.ASSET_ID=AD.ASSET_IDAND FAH.DATE_INEFFECTIVE IS NULL

AND FAH.DATE_EFFECTIVE <=TO_DATE('SYSDATE DATE TIME','DD/MM/YYYY HH24:MI:SS')AND AD.CREATION_DATE <=TO_DATE('SYSDATE DATE TIME','DD/MM/YYYY HH24:MI:SS')AND AD