Page History

SELECT sc.PARTICIPANTE_ORIGINATE,
sc.NRO_CUENTA_ORIGINANTE,
sc.DOCUMENTO_ORIGINANTE,
(SELECT ceibo.ORIGINANTE
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS TITULAR_ORIGINANTE,
(SELECT ceibo.CODIGO_ADQUIRIENTE
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS CODIGO_ADQUIRIENTE,
(SELECT ceibo.ADQUIRIENTE
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ADQUIRIENTE,
sc.TIPO_CUENTA_ORIGEN,
sc.FECHA_TRANSACCION,
sc.ID_SESION,
sc.ID_TRANSACCION,
sc.IMPORTE,
sc.MONEDA,
sc.TIPO_OPERACION,
(SELECT ceibo.TIPO_OPERACION
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS TIPO_RED,
sc.TIPO_TRANSACCION_INTERNA,
(SELECT ceibo.PAIS
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS PAIS,
sc.CANAL,
sc.COD_SERVICIO,
sc.GLOSA,
sc.MONTO_CARGO,
sc.DESTINO_FONDOS,
sc.EMISOR,
(SELECT ceibo.SUCURSAL_EMISOR
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS SUCURSAL_EMISOR,
(SELECT ceibo.CARTERA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS CARTERA,
(SELECT ceibo.EXTRANJERA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS EXTRANJERA,
(SELECT ceibo.GRUPO_AFINIDAD
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS GRUPO_AFINIDAD,
(SELECT ceibo.ORDEN_A
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ORDEN_A,
(SELECT ceibo.RUBRO
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION) 
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS RUBRO,
(SELECT ceibo.ISCOMERCIO
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ISCOMERCIO,
(SELECT ceibo.ATM
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ATM,
sc.PARTICIPANTE_DESTINO,
sc.CUENTA_DESTINO,
sc.TIPO_CUENTA_DESTINO,
sc.CI_NIT_DESTINATARIO,
sc.DESTINATARIO,
sc.NUM_ORDEN_DESTINATARIO,
(SELECT ceibo.ESTADO_CUENTA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ESTADO_CUENTA,
(SELECT ceibo.ESTADO_TARJETA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ESTADO_TARJETA,
(SELECT ceibo.TIPO_AUTORIZACION
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS TIPO_AUTORIZACION,
(SELECT ceibo.MODO_ENTRADA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS MODO_ENTRADA,
sc.ESTADO_TRANSACCION,
(SELECT ceibo.COTIZACION
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS COTIZACION ,
(SELECT ceibo.CAPTURA
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS CAPTURA ,
(SELECT ceibo.MANUAL
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS MANUAL ,
(SELECT ceibo.IMPORTE_DOLARES
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS IMPORTE_DOLARES ,
(SELECT ceibo.ADICIONAL
FROM AUT_H_ORDER ceibo
WHERE FUENTE_ORIGEN = 'CEIBO' 
AND TRUNC(ceibo.FECHA_TRANSACCION) = TRUNC(sc.FECHA_TRANSACCION)
AND sc.ID_TRANSACCION = ceibo.ID_TRANSACCION
AND ceibo.CODIGO_OPERACION = 0
) AS ADICIONAL ,
'SICOOP/CEIBO' AS FUENTE_ORIGEN
FROM AUT_H_ORDER sc
WHERE FUENTE_ORIGEN = 'SICOOP'