SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_GENERAR_TRASPASO_TRANSFERENCIA' SELECT Dl_Lectura AS Nombre FROM Documento_Lectura WHERE Dl_Documento = '21-0003629' AND Dl_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Af_Cve_Activo_Fijo AS Nombre FROM Documento_Activo_Fijo WHERE Da_Documento = '21-0003629' AND Da_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Uen_Cve_Unidad_Estrategica_Negocio AS Nombre FROM Documento_UEN WHERE Du_Documento = '21-0003629' AND Du_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Cc_Cve_Centro_Costo AS Nombre FROM Documento_Centro_Costo WHERE Dc_Documento = '21-0003629' AND Dc_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Py_Cve_Proyecto AS Nombre FROM Documento_Proyecto WHERE Dp_Documento = '21-0003629' AND Dp_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0014' AND Al_Cve_Almacen = '0001' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0014' AND Sc_Cve_Sucursal <> '0021' SELECT Al_Descripcion AS Nombre FROM Almacen WHERE Al_Cve_Almacen = '0001' AND Sc_Cve_Sucursal = '0021' SELECT Sc_Centro_Distribucion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0021' SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'TRF04') SELECT Transferencia.*, Color.Cl_Descripcion, Talla.Tl_Descripcion FROM Transferencia INNER JOIN Talla ON Transferencia.Tl_Cve_Talla = Talla.Tl_Cve_Talla INNER JOIN Color ON Transferencia.Cl_Cve_Color = Color.Cl_Cve_Color WHERE Tr_Folio = '21-0003629' AND Tr_Tipo = 'SL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_GENERAR_TRASPASO_TRANSFERENCIA' SELECT Dl_Lectura AS Nombre FROM Documento_Lectura WHERE Dl_Documento = '21-0003629' AND Dl_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Af_Cve_Activo_Fijo AS Nombre FROM Documento_Activo_Fijo WHERE Da_Documento = '21-0003629' AND Da_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Uen_Cve_Unidad_Estrategica_Negocio AS Nombre FROM Documento_UEN WHERE Du_Documento = '21-0003629' AND Du_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Cc_Cve_Centro_Costo AS Nombre FROM Documento_Centro_Costo WHERE Dc_Documento = '21-0003629' AND Dc_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Py_Cve_Proyecto AS Nombre FROM Documento_Proyecto WHERE Dp_Documento = '21-0003629' AND Dp_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0014' AND Al_Cve_Almacen = '0001' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0014' AND Sc_Cve_Sucursal <> '0021' SELECT Al_Descripcion AS Nombre FROM Almacen WHERE Al_Cve_Almacen = '0001' AND Sc_Cve_Sucursal = '0021' SELECT Sc_Centro_Distribucion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0021' SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'TRF04') SELECT Transferencia.*, Color.Cl_Descripcion, Talla.Tl_Descripcion FROM Transferencia INNER JOIN Talla ON Transferencia.Tl_Cve_Talla = Talla.Tl_Cve_Talla INNER JOIN Color ON Transferencia.Cl_Cve_Color = Color.Cl_Cve_Color WHERE Tr_Folio = '21-0003629' AND Tr_Tipo = 'SL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Clave FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' 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 = 'MUITZIL' 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 * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'TRF4SC' ORDER BY Fr_ID EXEC SP_RPT_TRF4SC_3 '21-0003629' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'TRF4SC' ORDER BY Fr_ID EXEC SP_RPT_TRF4SC_1 '21-0003629' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'TRF4SC' ORDER BY Fr_ID EXEC SP_RPT_TRF4SC_2 '21-0003629' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'TRF4SC' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'TRF4SC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_TRANSFERENCIA_SOLICITUD_SIN_COSTO' 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 = 'FIN_MONEDA_LOCAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_GENERAR_TRASPASO_TRANSFERENCIA' SELECT Dl_Lectura AS Nombre FROM Documento_Lectura WHERE Dl_Documento = '21-0003629' AND Dl_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Af_Cve_Activo_Fijo AS Nombre FROM Documento_Activo_Fijo WHERE Da_Documento = '21-0003629' AND Da_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Uen_Cve_Unidad_Estrategica_Negocio AS Nombre FROM Documento_UEN WHERE Du_Documento = '21-0003629' AND Du_Tabla = 'SOLICITUD_TRANSFERENCIA' SELECT Cc_Cve_Centro_Costo AS Nombre FROM Documento_Centro_Costo WHERE Dc_Documento = '21-0003629' AND Dc_Tabla = 'SOLICITUD_TRANSFERENCIA'