Fixed Assets Query

SELECT distinct
fab.model_number,
FAB.ASSET_TYPE ASSET_CLASS,
FAB.ASSET_NUMBER ASSET,
FAT.DESCRIPTION ASSET_DESCRITPION,
FB.BOOK_TYPE_CODE BOOK,
FB.ORIGINAL_COST ASSET_COST,
FDS.DEPRN_RESERVE ACCUMULATED_DEPRECIATION,
fds.deprn_amount The_last_depreciation_amount,
(FB.ORIGINAL_COST-FDS.DEPRN_RESERVE) Net_Book_Value,
fb.salvage_value Residual_value,
to_char(fb.prorate_date,'DD-MON-RRRR') prorate_date,
fb.life_in_months||' Motnhs'  Life_of_asset,
FAB.SERIAL_NUMBER SERIAL_NUMBER,
round((DECODE (
          fb.period_counter_fully_retired,
          NULL, GREATEST (
                   NVL (fb.life_in_months, 0)
                   - TRUNC (
                        MONTHS_BETWEEN (SYSDATE,
                                        fb.date_placed_in_service)),
                   0),
          0)) /12,1)
          remaining_life_in_years
FROM
FA_ADDITIONS_B FAB,
FA_ADDITIONS_TL FAT,
FA_BOOKS FB,
FA_DISTRIBUTION_HISTORY FDH,
PER_ALL_PEOPLE_F PAPF,
FA_LOCATIONS_KFV FLK,
GL_CODE_COMBINATIONS_KFV GCCK,
FA_DEPRN_SUMMARY FDS,
GL_ledgers  GSOB
WHERE
FAB.ASSET_ID=FAT.ASSET_ID
AND FAB.ASSET_ID=FDH.ASSET_ID
AND FAB.ASSET_ID=FB.ASSET_ID
AND FDH.DATE_INEFFECTIVE IS NULL
AND FDS.ASSET_ID=FB.ASSET_ID
AND FDS.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND FDS.DEPRN_SOURCE_CODE='DEPRN'
AND FDS.PERIOD_COUNTER =(SELECT MAX(PERIOD_COUNTER) FROM FA_DEPRN_SUMMARY FDSS WHERE FDSS.DEPRN_SOURCE_CODE='DEPRN' AND FDSS.ASSET_ID=FB.ASSET_ID AND FDSS.BOOK_TYPE_CODE=FB.BOOK_TYPE_CODE)
AND FB.TRANSACTION_HEADER_ID_IN=(SELECT MAX(TRANSACTION_HEADER_ID_IN) FROM FA_BOOKS FB1 WHERE FB1.ASSET_ID=FB.ASSET_ID AND FB1.BOOK_TYPE_CODE=FB.BOOK_TYPE_CODE)
AND FB.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND FDH.LOCATION_ID=FLK.LOCATION_ID
AND GCCK.CODE_COMBINATION_ID = FDH.CODE_COMBINATION_ID
AND GCCK.CHART_OF_ACCOUNTS_ID=GSOB.CHART_OF_ACCOUNTS_ID
AND FDH.ASSIGNED_TO = PAPF.PERSON_ID (+)
AND FAT.LANGUAGE = USERENV('LANG')
AND FB.BOOK_TYPE_CODE <>'ACE TAX'
and fb.asset_id = 3316768
and fb.book_type_code = 'NEW MTN'
ORDER BY fb.ASSET_ID ;