FROM   (SELECT  B.VDR_CD AS VDR_CD,
                B.COD_STTL_CLS_DT AS COD_STTL_CLS_DT,
                C.DLVR_PHY_DTRBT_DIV AS DLVR_PHY_DTRBT_DIV,
                COUNT(*) AS OBJECT_X_COUNT,
                SUM(NVL(B.TXIN_DCNT_TL_AMT,0) + NVL(B.TXIN_CRRG_FEE_DCNT_TL_AMT,0)) AS DIV_ONE_AMT,
                SUM(NVL(B.PRDCNT_TXIN_SALITM_PRC_TL_AMT,0)) AS PRDCNT_TXIN_SALITM_PRC_TL_AMT,
                SUM(NVL(B.PRDCNT_TXIN_CRRG_FEE_TL_AMT,0)) AS PRDCNT_TXIN_CRRG_FEE_TL_AMT,
                SUM(NVL(B.TXIN_WG_TL_AMT,0)) AS COD_STTL_WG_TL_PLS_AMT