Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement