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;