get Manis

SELECT DISTINCT MAX(TO_CHAR(H_FECHA_ALTA,'yyyy/mm/dd hh24:mi:ss')) AS H_FECHA_ALTA,
WSUM.DS_INDICADORTRANSPORTEVACIO,
WSUM.DS_INDICADORMERCADERIABORDO,
WSUM.DS_CODIGOADUANAREGISTRO,
WSUM.DS_LUGAROPERATIVO,
DS_PAISTRANSPORTISTA,
PT.DPAIS AS PAIS_TRANSP,
DS_PAISMEDIOTRANSPORTE,
PM.DPAIS AS PAIS_MTRANSP,
DS_PAISPROCEDENCIA,
WSUM.DS_NOMBRETRANSPORTISTA,
DS_MATRICULAMEDIOTRANSPORTE,
WSUM.DS_NOMBRE_HABILITADO,
WSUM.DS_IDENTIFICADOR,
WVUE.NUMERO_VUELO,
DECODE(SIDIN.MIMPRESION,NULL,'NO',0,'NO',1,'SI') AS MIMPRESION
FROM WIT_SLSUMARIABASES WSUM, DOM_PAISES PT, DOM_PAISES PP , DOM_PAISES PM, SIDIN, WIT_SLSUMARIANROVUELO WVUE
WHERE WSUM.DS_PAISTRANSPORTISTA = PT.CPAISMARIA

--AND WVUE.NUMERO_VUELO IS NULL

AND WVUE.NUMERO_VUELO != 'AR1303' AND WVUE.NUMERO_VUELO != 'AR1065'


AND WSUM.DS_IDENTIFICADOR = SUBSTR(SIDIN.NANIO,3,2) || SIDIN.CADUANA || SIDIN.CTPDOCING || SIDIN.NREG || SIDIN.DLETRA
AND DS_PAISMEDIOTRANSPORTE = PM.CPAISMARIA
AND WVUE.DS_IDENTIFICADOR(+) = WSUM.DS_IDENTIFICADOR
AND DS_PAISPROCEDENCIA = PP.CPAISMARIA
AND PP.CSTATUS = 'A' AND PM.CSTATUS = 'A' AND PT.CSTATUS = 'A'
--AND WSUM.DS_LUGAROPERATIVO = ?
--AND WSUM.DS_CODIGOADUANAREGISTRO = ?
AND WSUM.DS_IDENTIFICADOR IN
(SELECT SUBSTR(SIDIN.NANIO,3,2) || SIDIN.CADUANA || SIDIN.CTPDOCING || SIDIN.NREG || SIDIN.DLETRA
FROM SIING , SIDIN, SIGUI
WHERE SIING.CESTADO = 'S'
AND SIDIN.CREGISTRO = SIING.CREGISTRO
AND SIDIN.CREGISTRO = SIGUI.CREGISTRO
AND SIGUI.CINT_GUIA = SIING.CINT_ING
AND (SIGUI.CTRANS <> 'CCC' AND SIGUI.CTRANS <> 'XXX')
AND SIDIN.FHRECEPCION >= SYSDATE -  + 300 )
GROUP BY
WSUM.DS_INDICADORTRANSPORTEVACIO,
WSUM.DS_INDICADORMERCADERIABORDO,
WSUM.DS_CODIGOADUANAREGISTRO,
WSUM.DS_LUGAROPERATIVO,
DS_PAISTRANSPORTISTA,
PT.DPAIS,
DS_PAISMEDIOTRANSPORTE,
PM.DPAIS,
DS_PAISPROCEDENCIA,
WSUM.DS_NOMBRETRANSPORTISTA,
DS_MATRICULAMEDIOTRANSPORTE,
WSUM.DS_NOMBRE_HABILITADO,
WSUM.DS_IDENTIFICADOR,
WVUE.NUMERO_VUELO,
DECODE(SIDIN.MIMPRESION,NULL,'NO',0,'NO',1,'SI')
ORDER BY 1 DESC;