[Oracle]How to Query assignments in FA

SELECT FAD.BOOK_TYPE_CODE,
       FA.ASSET_ID,
       FA.ASSET_NUMBER,
       FA.CURRENT_UNITS,
       FA.DESCRIPTION,
       FA.ASSET_CATEGORY_ID,
       FA.ATTRIBUTE_CATEGORY_CODE,
       FAD.UNITS_ASSIGNED,
       FAD.CODE_COMBINATION_ID,
       GCC.SEGMENT1 || '.' || GCC.SEGMENT2 || '.' || GCC.SEGMENT3 || '.' ||
       GCC.SEGMENT4 || '.' || GCC.SEGMENT5 || '.' || GCC.SEGMENT6 ACCOUNTS,
       FAD.LOCATION_ID,
       FL.SEGMENT1 || '-' || GCC.SEGMENT2 LOCATIONS
  FROM FA_ADDITIONS_V          FA,
       FA_DISTRIBUTION_HISTORY FAD,
       GL_CODE_COMBINATIONS    GCC,
       FA_LOCATIONS            FL
 WHERE 1 = 1
   AND FA.ASSET_ID = FAD.ASSET_ID
      --AND FA.ASSET_ID = 134758
   AND FAD.BOOK_TYPE_CODE = 'TW资产帐'
   AND FAD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
   AND FAD.LOCATION_ID = FL.LOCATION_ID