CREATE OR REPLACE FORCE VIEW EKONO.RCH_V_ZUNIFY_TRANSACTION
AS
   SELECT   B.N_ID,
            A.C_CARGO,
            A.C_TRANSACTIONID,
            A.C_ESTADO,
            A.N_MONTO,
            A.C_MONEDA,
            A.C_TERMINAL,
            A.N_DOCUMENTO,   
            B.TIPO LOG_TIPO,
            B.FECHA LOG_FECHA,
            B.ESQUEMA LOG_ESQUEMA,
            C.DBLINK CRT_DBLINK,
            B.PROCESAR
     FROM   ZUN_ZUNIFY_TRANSACTION A,
            LOG_ZUNIFY_TRANSACTION B,
            CG_REFRESH_TIMES C
    WHERE       A.N_ID(+) = B.N_ID
            AND C.TABLE_NAME = 'ZUN_ZUNIFY_TRANSACTION'
            AND C.LAST_REFRESH <= B.FECHA;
