11.5.10 Oracle Fix Assets Report by Period

Hello Oracle

I would like to ask you if you can share with me any fix assets reports by period.

I have the following script but I think is not working.

SELECT
a.asset_number "Asset Number",
a.asset_id,
a.asset_category_id,
d.deprn_method_code,
d.life_in_months,
a.attribute_category_code,a.context,
D.PERIOD_COUNTER_FULLY_RETIRED "Asset Retired",
D.period_counter_fully_reserved "Assets Fully Reserved",
DECODE(a.asset_type,'CAPITALIZED','Capitalized',a.asset_type) Asset_Type,
DECODE(d.depreciate_flag,'YES','Yes','NO','No',depreciate_flag) deprn_yn,
d.date_placed_in_service DPIS ,