
BEGIN

INSERT INTO CG_QUERIES (
                        QUERYNAME,
                        DALMODULE,
                        DESCRIPTION,
                        QUERY,
                        CREATED_DATE
            )VALUES(
                '113',
                'PDV',
                'MUESTRA FACTURAS PAGADAS CON ZUNIFY',
                'SELECT DOCUMENTO, LINEA, FACTURA, MONEDA, MONTO FROM ZUNIFY_V_OBTFACTURAS WHERE JORNADA = &&JORNADA&&',
                SYSDATE    
            );
END;