Query to get the 11i Asset categories setup information with GL Code Combinations,Salvage value and depreciation rate

SELECT fcb.book_type_code, fc.segment1, fc.segment2, FC.DESCRIPTION,FC.ENABLED_FLAG,fc.category_type,
       fc.owned_leased,
       (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.ASSET_CLEARING_ACCOUNT_CCID) asset_clearing_cost,
        (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.ASSET_COST_ACCOUNT_CCID ) asset_cost,
         DEPRN_RESERVE_ACCT,
          fcb.DEPRN_EXPENSE_ACCT,
          (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.RESERVE_ACCOUNT_CCID) ACCUM_DEPRN,
  fcb.BONUS_DEPRN_EXPENSE_ACCT,
          BONUS_DEPRN_RESERVE_ACCT ,
          (select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.BONUS_RESERVE_ACCT_CCID) BONUS_RESERVE_ACCT,
          fcb.CIP_COST_ACCT  ,
(select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.WIP_COST_ACCOUNT_CCID) CIP_cost,
          fcb.CIP_CLEARING_ACCT ,
(select CONCATENATED_SEGMENTS from gl_code_combinations_kfv where code_combination_id=fcb.WIP_CLEARING_ACCOUNT_CCID) CIP_CLEARING,
  fcbd.DEPRN_METHOD,
          fcbd.BASIC_RATE ,
          fcbd.ADJUSTED_RATE ,
 FCBD.LIFE_IN_MONTHS ,
 FCBD.PRORATE_CONVENTION_CODE,
 FCBD.RETIREMENT_PRORATE_CONVENTION,
 FCBD.PERCENT_SALVAGE_VALUE
  FROM fa_category_books fcb, fa_categories fc,fa_category_book_defaults fcbd
 WHERE  fcb.category_id = fc.category_id
 AND fcb.CATEGORY_ID=fcbd.CATEGORY_ID
 AND fcb.BOOK_TYPE_CODE=fcbd.BOOK_TYPE_CODE
--- AND Fcb.book_type_code =
  --AND fc.CATEGORY_ID=1