Oracle Fixed Asset Details Query

SELECT
    A.ASSET_NUMBER,
    A.DESCRIPTION,
    A.ASSET_TYPE,
    D.SEGMENT1 ASSET_KEY,
    C.SEGMENT1 MAJOR_CATEGORY,
    C.SEGMENT2 MINOR_CATEGORY,
    B.DEPRN_METHOD_CODE,
    B.LIFE_IN_MONTHS / 12 LIFE,
    B.BOOK_TYPE_CODE,
    B.DATE_PLACED_IN_SERVICE,
    B.DEPRECIATE_FLAG,
    B.COST,
    H.UNITS_ASSIGNED UNITS,
    G.SEGMENT1 COMPANY,
    G.SEGMENT2 DEPARTMENT,
    G.SEGMENT3 ACCOUNT,
    L.SEGMENT1 COUNTRY,
    L.SEGMENT2 STATE,
    L.SEGMENT3 CITY,
    L.SEGMENT4 BUILDING
FROM
    FA_ADDITIONS A,
    FA_BOOKS_V B,
    FA_CATEGORIES C,
    FA_ASSET_KEYWORDS D,
    GL_CODE_COMBINATIONS G,
    FA_DISTRIBUTION_HISTORY H,
    FA_LOCATIONS L
WHERE
        A.ASSET_ID = B.ASSET_ID
    AND
        A.ASSET_ID = H.ASSET_ID
    AND
        A.ASSET_CATEGORY_ID = C.CATEGORY_ID
    AND
        H.CODE_COMBINATION_ID = G.CODE_COMBINATION_ID
    AND
        H.LOCATION_ID = L.LOCATION_ID
    AND
        A.ASSET_KEY_CCID = D.CODE_COMBINATION_ID
    AND
        B.BOOK_TYPE_CODE LIKE 'MWANI_CORP_BOOK'
    AND
        H.TRANSACTION_HEADER_ID_OUT IS NULL