SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'COTI_PIE' and not imagen is null EXEC SP_RPT_ZCOT01_3 '01-0000002' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'COTI_ENCA' and not imagen is null EXEC SP_RPT_ZCOT01_1 '01-0000002' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID EXEC SP_RPT_ZCOT01_2 '01-0000002' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Horizontal, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZCOT01' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'CONFIG' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZCOT01' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_COTIZACION_NORMAL' SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL19' SELECT Cotizacion.Ct_Folio, Vendedor.Vn_Email, Vendedor.Vn_Descripcion, Vendedor.Vn_Email_Contacto, (SELECT MAX(ISNULL(Ct_Partida,0)) FROM Cotizacion c WHERE c.Ct_Folio = Cotizacion.Ct_Folio) AS PARTIDA FROM Cotizacion_Encabezado Cotizacion INNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_Vendedor INNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_Cliente WHERE Cotizacion.Ct_Folio = '01-0000002' SELECT Cotizacion.Ct_Folio AS FOLIO, Cliente.Cl_Razon_Social AS CLIENTE_RAZON_SOCIAL, CASE WHEN Cliente.Cl_Contacto_1 <> '' THEN Cliente.Cl_Contacto_1 ELSE Cliente.Cl_Contacto_2 END AS CONTACTO, CASE WHEN Cliente.Cl_email_contacto_1 <> '' THEN Cliente.Cl_email_contacto_1 ELSE Cliente.Cl_email_contacto_2 END EMAIL, Empresa.Em_Razon_Social AS EMPRESA, Vendedor.Vn_Telefono_1 AS TELEFONO1, Vendedor.Vn_Telefono_2 AS TELEFONO2, Vendedor.Vn_Telefono_3 AS TELEFONO3FROM Cotizacion_Encabezado CotizacionINNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_ClienteINNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_VendedorINNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal = Cliente.Sc_Cve_SucursalINNER JOIN Empresa ON Empresa.Em_Cve_Empresa = Sucursal.Em_Cve_EmpresaWHERE Cotizacion.Ct_Folio = '01-0000002' SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COTIZACION_PL' SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL19' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'PL_COTIZACION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_ENVIAR_EMAIL_VENDEDOR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_ENVIAR_AUTOMATICAMENTE' Select top 25 Modulos.Clave, Modulos.Descripcion, Menus.EasyAccess, EasyAccess.Transaccion, EasyAccess.Accesos FROM EMPRESAS..EasyAccess EasyAccess INNER JOIN EMPRESAS..Operadores Operadores ON EasyAccess.Operador = Operadores.Operador INNER JOIN EMPRESAS..Permisos Permisos ON EasyAccess.Empresa = Permisos.Empresa AND EasyAccess.Transaccion = Permisos.Menu AND Operadores.Perfil = Permisos.Perfil AND Permisos.Estado = 'AC' INNER JOIN EMPRESAS..Menus Menus ON EasyAccess.Transaccion = Menus.Clave INNER JOIN EMPRESAS..Modulos Modulos ON Menus.Modulo = Modulos.Clave WHERE EasyAccess.Personalizado = 'SI' AND EasyAccess.Bloqueado = 'NO' AND EasyAccess.Operador = 'CONFIG' AND EasyAccess.Empresa = '01' ORDER BY EasyAccess.Accesos Desc SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'COTI_PIE' and not imagen is null EXEC SP_RPT_ZCOT01_3 '01-0000002' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'COTI_ENCA' and not imagen is null EXEC SP_RPT_ZCOT01_1 '01-0000002' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZCOT01' ORDER BY Fr_ID EXEC SP_RPT_ZCOT01_2 '01-0000002' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Horizontal, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZCOT01' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'CONFIG' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZCOT01' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_COTIZACION_NORMAL' SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL19' SELECT Cotizacion.Ct_Folio, Vendedor.Vn_Email, Vendedor.Vn_Descripcion, Vendedor.Vn_Email_Contacto, (SELECT MAX(ISNULL(Ct_Partida,0)) FROM Cotizacion c WHERE c.Ct_Folio = Cotizacion.Ct_Folio) AS PARTIDA FROM Cotizacion_Encabezado Cotizacion INNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_Vendedor INNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_Cliente WHERE Cotizacion.Ct_Folio = '01-0000002' SELECT Cotizacion.Ct_Folio AS FOLIO, Cliente.Cl_Razon_Social AS CLIENTE_RAZON_SOCIAL, CASE WHEN Cliente.Cl_Contacto_1 <> '' THEN Cliente.Cl_Contacto_1 ELSE Cliente.Cl_Contacto_2 END AS CONTACTO, CASE WHEN Cliente.Cl_email_contacto_1 <> '' THEN Cliente.Cl_email_contacto_1 ELSE Cliente.Cl_email_contacto_2 END EMAIL, Empresa.Em_Razon_Social AS EMPRESA, Vendedor.Vn_Telefono_1 AS TELEFONO1, Vendedor.Vn_Telefono_2 AS TELEFONO2, Vendedor.Vn_Telefono_3 AS TELEFONO3FROM Cotizacion_Encabezado CotizacionINNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_ClienteINNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_VendedorINNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal = Cliente.Sc_Cve_SucursalINNER JOIN Empresa ON Empresa.Em_Cve_Empresa = Sucursal.Em_Cve_EmpresaWHERE Cotizacion.Ct_Folio = '01-0000002'