Assets Details SQL Query

select
fa1.asset_id,
fa1.asset_number,
fa1.asset_key_ccid,
fas.concatenated_segments asset_key,
fa1.current_units,
fa1.asset_type,
fa1.tag_number,
fa1.description,
fa1.asset_category_id,
fc.segment1||'.'||fc.segment2 asset_category,
fc.description category_description,
fa1.parent_asset_id,
fa2.asset_number parent_asset_number,
fa2.description parent_asset_description,
fa1.manufacturer_name,
fa1.serial_number,
fa1.model_number,
fa1.in_use_flag,
fa1.owned_leased,
fa1.new_used,
fa1.inventorial,
fa1.unit_adjustment_flag,
fa1.add_cost_je_flag,
fa1.lease_id,
fa1.last_update_date,
fa1.last_updated_by,
fa1.created_by,
fa1.creation_date

from
fa_additions fa1,
fa_additions fa2,
fa_asset_keywords_kfv fas,
fa_categories fc

where
fa2.asset_id (+) =fa1.parent_asset_id 

and fas.code_combination_id (+)=fa1.asset_key_ccid 

and fc.category_id (+)=fa1.asset_category_id