SELECT
    TRUNC (B.FECHA_CAPTURA)        AS RECEPCION_DCL,
    TRUNC (CREATE_DATE)            AS RECEPCION_CSC,
    DEC_DICT                       AS DEC_DICT,
    NVL (ID_DECENA, ID_DECENA_EXT) AS DEC_CSC,
    COUNT (*)                      AS AFORO,
    SUM (AMOUNT_REAL)              AS IMPORTE_CSC,
    SUM (AMOUNT_CHARGED)           AS IMPORTE_DCL
FROM AMS_TRANSACTION A
LEFT OUTER JOIN TBL_DCL_CRUCES B ON ID_CRUCES = IDCRUCES
WHERE     CREATE_DATE > :FECHA - (1 / (24 * 3600))
    AND CREATE_DATE < :FECHA + 1
    AND (NVL(ID_DECENA, ID_DECENA_EXT) = '164' OR NVL(ID_DECENA, ID_DECENA_EXT) IN ('193','191'))
    AND ID_CONCESSIONAIRE > 0
GROUP BY
    TRUNC (B.FECHA_CAPTURA),
    TRUNC (CREATE_DATE),
    DEC_DICT,
    NVL (ID_DECENA, ID_DECENA_EXT)