Fixed Asset Depreciation Details

WITH PROJECT_ASSET AS (
    SELECT
        PPAV.SEGMENT1               AS Project_Number,
        FAI.ASSET_ID                AS Asset_Id,
        FAI.BOOK_TYPE_CODE          AS Book_Type_Code
    FROM
        PJF_PROJECTS_ALL_VL         PPAV,
        FA_ASSET_INVOICES           FAI
    WHERE
        FAI.PROJECT_ID              = PPAV.PROJECT_ID
    GROUP BY
        PPAV.SEGMENT1,
        FAI.ASSET_ID,
        FAI.BOOK_TYPE_CODE
)
SELECT
    FAB.ASSET_NUMBER                                        AS Asset_Number,
    REPLACE(FCB.SEGMENT1, ' ', '_')                         AS Major_Category,
    REPLACE(FCB.SEGMENT2, ' ', '_')                         AS Minor_Category,
    REPLACE(FCB.SEGMENT1, ' ', '_') || '.' ||
    REPLACE(FCB.SEGMENT2, ' ', '_')                         AS Major_Minor_Category,
    PA.Project_Number                                       AS Project_Number,
    GCC.SEGMENT1 || '.' ||
    GCC.SEGMENT2 || '.' ||
    GCC.SEGMENT3 || '.' ||
    GCC.SEGMENT5 || '.' ||
    GCC.SEGMENT6                                            AS Expense_Account,
    GCC.SEGMENT4                                            AS Natural_Account,
    GLL.CURRENCY_CODE                                       AS Currency_Code,
    FDP.FISCAL_YEAR                                         AS Fiscal_Year,
    FDP.PERIOD_NAME                                         AS Period_Name,
    SUM(FDD.DEPRN_AMOUNT)                                   AS Depreciation_Amount
FROM
    FA_ADDITIONS_B                 FAB,
    FA_CATEGORIES_B                FCB,
    FA_ADDITIONS_TL                FAT,
    FA_BOOKS                       FB,
    FA_DEPRN_PERIODS               FDP,
    FA_BOOK_CONTROLS               FBC,
    FA_DISTRIBUTION_HISTORY        FDH,
    GL_CODE_COMBINATIONS           GCC,
    GL_LEDGERS                     GLL,
    FA_DEPRN_DETAIL                FDD,
    PROJECT_ASSET                  PA
WHERE
        FCB.CATEGORY_ID            = FAB.ASSET_CATEGORY_ID
    AND FAB.ASSET_ID               = FAT.ASSET_ID
    AND FAT.LANGUAGE               = USERENV('LANG')
    AND FAB.ASSET_ID               = FB.ASSET_ID
    AND FB.BOOK_TYPE_CODE          = FBC.BOOK_TYPE_CODE
    AND FB.DATE_INEFFECTIVE        IS NULL
    AND FAB.ASSET_ID               = FDH.ASSET_ID
    AND FB.BOOK_TYPE_CODE          = FDH.BOOK_TYPE_CODE
    AND FDH.DATE_INEFFECTIVE       IS NULL
    AND FDH.CODE_COMBINATION_ID    = GCC.CODE_COMBINATION_ID
    AND FBC.SET_OF_BOOKS_ID        = GLL.LEDGER_ID
    AND FDD.ASSET_ID               = FAB.ASSET_ID
    AND FDD.BOOK_TYPE_CODE         = FDP.BOOK_TYPE_CODE
    AND FDD.PERIOD_COUNTER         = FDP.PERIOD_COUNTER
    AND FDD.DISTRIBUTION_ID        = FDH.DISTRIBUTION_ID
    AND FDD.DEPRN_SOURCE_CODE      = 'D'
    AND PA.Asset_Id (+)            = FAB.ASSET_ID
    AND PA.Book_Type_Code (+)      = FB.BOOK_TYPE_CODE
    AND NVL(FB.COST, 0)
        - NVL(FDD.DEPRN_RESERVE, 0)
        - NVL(FDD.IMPAIRMENT_RESERVE, 0) <> 0
GROUP BY
    FAB.ASSET_NUMBER,
    FCB.SEGMENT1,
    FCB.SEGMENT2,
    PA.Project_Number,
    GCC.SEGMENT1 || '.' ||
    GCC.SEGMENT2 || '.' ||
    GCC.SEGMENT3 || '.' ||
    GCC.SEGMENT5 || '.' ||
    GCC.SEGMENT6,
    GCC.SEGMENT4,
    GLL.CURRENCY_CODE,
    FDP.FISCAL_YEAR,
    FDP.PERIOD_NAME
ORDER BY
    FAB.ASSET_NUMBER