Fixed Asset detail query

Fixed Assets details Query
------------------------------

SELECT DISTINCT fab.description, fcb.segment1 majorcategory,
fcb.segment2 minor_category, fcb.segment3 subminor,
fab.current_units units, fbv.COST asset_cost,
fbv.original_cost, fab.asset_number,
NVL ((SELECT deprn_amount
FROM fa_deprn_detail
WHERE asset_id = fab.asset_id
AND deprn_source_code = 'D'),
0
) deprn_amount,
fbv.COST
- NVL ((SELECT deprn_amount
FROM fa_deprn_detail
WHERE asset_id = fab.asset_id
AND deprn_source_code = 'D'),
0
) nbv_value,
fl.segment1 country, fl.segment2 region, fl.segment3 wilatay,
fl.segment4 sbu, fl.segment5 cost_centre,
fl.segment6 lasset_location,
gcc.segment1
|| '.'
|| gcc.segment2
|| '.'
|| gcc.segment3
|| '.'
|| gcc.segment4
|| '.'
|| gcc.segment5
|| '.'
|| gcc.segment6
|| '.'
|| gcc.segment7
|| '.'
|| gcc.segment8 expense_account,
NULL clearing_account, fbv.date_placed_in_service,
fbv.prorate_date, 'STL' depreciationmethod,
fbv.life_in_months lifeinmonths, fab.asset_type,
(SELECT segment1 || '.' || segment2
FROM fa_asset_keywords
WHERE code_combination_id = fab.asset_key_ccid
AND ROWNUM = 1) asset_key
FROM apps.fa_additions_v fab,
apps.fa_books_v fbv,
apps.fa_categories_b fcb,
apps.fa_deprn_periods fdp,
apps.fa_distribution_history fdh,
apps.gl_code_combinations gcc,
apps.fa_locations fl
WHERE 1 = 1
AND fab.asset_id = fbv.asset_id
AND fcb.category_id = fab.asset_category_id
AND fbv.transaction_header_id_out IS NULL
AND fdp.book_type_code = fbv.book_type_code
AND fdh.asset_id = fbv.asset_id
AND fdh.code_combination_id = gcc.code_combination_id
AND fdh.location_id = fl.location_id
AND fbv.transaction_header_id_out IS NULL
AND fdh.transaction_header_id_out IS NULL
--and fbv.date_placed_in_service!=fbv.PRORATE_DATE
--and fbv.COST! =fbv.ORIGINAL_COST
--and fab.asset_number like '%TEST%'