using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;

namespace LLNet.DAL.Oracle.General
{
	public class General : OracleDAL
	{

		#region CodeGen

		#region Declaraciones

		private System.Data.OracleClient.OracleCommand oracleInsertCommand2;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand2;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand2;
		private System.Data.OracleClient.OracleCommand cmdSelectZonas;
		public System.Data.OracleClient.OracleDataAdapter adpZonas;
		public System.Data.OracleClient.OracleDataAdapter adpClasificaciones;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand1;
		public System.Data.OracleClient.OracleDataAdapter adpFilters;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand3;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand3;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand3;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand3;
		public System.Data.OracleClient.OracleDataAdapter adpClasificacionSkus;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand4;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand4;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand4;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand4;
		public System.Data.OracleClient.OracleDataAdapter adpLOVSkus;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand5;
		public System.Data.OracleClient.OracleDataAdapter adpRankingVentas;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand6;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand5;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand5;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand5;
		public System.Data.OracleClient.OracleDataAdapter adpFormatoImpresiones;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand7;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand6;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand6;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand6;
		public System.Data.OracleClient.OracleDataAdapter adpCuentas;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand8;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand7;
		public System.Data.OracleClient.OracleDataAdapter adpClientes;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand9;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand8;
		private System.Data.OracleClient.OracleCommand selectLOVProveedores;
		public System.Data.OracleClient.OracleDataAdapter adpLOVProveedores;
		private System.Data.OracleClient.OracleCommand selectMonedas;
		public System.Data.OracleClient.OracleDataAdapter adpMonedas;
		public System.Data.OracleClient.OracleDataAdapter adpLOVClientes;
		private System.Data.OracleClient.OracleCommand selectLOVClientes;
		public System.Data.OracleClient.OracleDataAdapter adpAntiSaldos;
		private System.Data.OracleClient.OracleCommand oracleCommand1;
		public System.Data.OracleClient.OracleDataAdapter adpEstadoCuenta;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand10;
		public System.Data.OracleClient.OracleDataAdapter adpProveedores;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand11;
		public System.Data.OracleClient.OracleDataAdapter adpEstadoCuentaProveedores;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand12;
		public System.Data.OracleClient.OracleDataAdapter adpRegiones;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand13;
		public System.Data.OracleClient.OracleDataAdapter adpTiedasReabasto;
		private System.Data.OracleClient.OracleCommand oracleCommand2;
		private System.Data.OracleClient.OracleDataAdapter adpLOVPrecioSkus;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand14;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand9;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand2;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand1;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand1;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand1;
		public System.Data.OracleClient.OracleDataAdapter adp3PLEstadisticas;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand15;
		public System.Data.OracleClient.OracleDataAdapter adpLOVVendedores;
		private System.Data.OracleClient.OracleCommand selectLOVVendedores;
		public System.Data.OracleClient.OracleDataAdapter adpEmpresas;
		private System.Data.OracleClient.OracleCommand selectEmpresas;
		public System.Data.OracleClient.OracleDataAdapter adpRetVRegion;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand16;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand10;
		public System.Data.OracleClient.OracleDataAdapter adpCgDomains;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand17;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand11;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand7;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand7;
		public System.Data.OracleClient.OracleDataAdapter adpDomainColumns;
		public System.Data.OracleClient.OracleDataAdapter adpUserTabColumns;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand19;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand18;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand12;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand8;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand8;
		public System.Data.OracleClient.OracleDataAdapter adpDomains;
		public System.Data.OracleClient.OracleDataAdapter adpCgRefCodes;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand20;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand13;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand9;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand9;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand21;
        public System.Data.OracleClient.OracleDataAdapter adpNotasCredito;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand22;
        public System.Data.OracleClient.OracleDataAdapter adpnc;
        private System.Data.OracleClient.OracleConnection cnn1;
		private System.ComponentModel.IContainer components = null;

		#endregion

		#region Destructor

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#endregion

		#region Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(General));
            this.cmdSelectZonas = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleDeleteCommand2 = new System.Data.OracleClient.OracleCommand();
            this.adpZonas = new System.Data.OracleClient.OracleDataAdapter();
            this.adpClasificaciones = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand1 = new System.Data.OracleClient.OracleCommand();
            this.adpFilters = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand1 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand1 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand1 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleDeleteCommand3 = new System.Data.OracleClient.OracleCommand();
            this.adpClasificacionSkus = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand4 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand4 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand4 = new System.Data.OracleClient.OracleCommand();
            this.oracleDeleteCommand4 = new System.Data.OracleClient.OracleCommand();
            this.adpLOVSkus = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand5 = new System.Data.OracleClient.OracleCommand();
            this.adpRankingVentas = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand6 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand5 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand5 = new System.Data.OracleClient.OracleCommand();
            this.oracleDeleteCommand5 = new System.Data.OracleClient.OracleCommand();
            this.adpDomains = new System.Data.OracleClient.OracleDataAdapter();
            this.adpFormatoImpresiones = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand6 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand6 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand7 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand6 = new System.Data.OracleClient.OracleCommand();
            this.adpCuentas = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleInsertCommand7 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand8 = new System.Data.OracleClient.OracleCommand();
            this.adpClientes = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleInsertCommand8 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand9 = new System.Data.OracleClient.OracleCommand();
            this.selectLOVProveedores = new System.Data.OracleClient.OracleCommand();
            this.adpLOVProveedores = new System.Data.OracleClient.OracleDataAdapter();
            this.selectMonedas = new System.Data.OracleClient.OracleCommand();
            this.adpMonedas = new System.Data.OracleClient.OracleDataAdapter();
            this.adpLOVClientes = new System.Data.OracleClient.OracleDataAdapter();
            this.selectLOVClientes = new System.Data.OracleClient.OracleCommand();
            this.adpAntiSaldos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand1 = new System.Data.OracleClient.OracleCommand();
            this.adpEstadoCuenta = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand10 = new System.Data.OracleClient.OracleCommand();
            this.adpProveedores = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand11 = new System.Data.OracleClient.OracleCommand();
            this.adpEstadoCuentaProveedores = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand12 = new System.Data.OracleClient.OracleCommand();
            this.adpRegiones = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand13 = new System.Data.OracleClient.OracleCommand();
            this.adpTiedasReabasto = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand2 = new System.Data.OracleClient.OracleCommand();
            this.adpLOVPrecioSkus = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleInsertCommand9 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand14 = new System.Data.OracleClient.OracleCommand();
            this.adp3PLEstadisticas = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand15 = new System.Data.OracleClient.OracleCommand();
            this.adpLOVVendedores = new System.Data.OracleClient.OracleDataAdapter();
            this.selectLOVVendedores = new System.Data.OracleClient.OracleCommand();
            this.adpEmpresas = new System.Data.OracleClient.OracleDataAdapter();
            this.selectEmpresas = new System.Data.OracleClient.OracleCommand();
            this.adpRetVRegion = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleInsertCommand10 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand16 = new System.Data.OracleClient.OracleCommand();
            this.adpCgDomains = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand7 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand11 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand17 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand7 = new System.Data.OracleClient.OracleCommand();
            this.adpDomainColumns = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand8 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand12 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand18 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand8 = new System.Data.OracleClient.OracleCommand();
            this.adpUserTabColumns = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand19 = new System.Data.OracleClient.OracleCommand();
            this.adpCgRefCodes = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand9 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand13 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand20 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand9 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand21 = new System.Data.OracleClient.OracleCommand();
            this.adpNotasCredito = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand22 = new System.Data.OracleClient.OracleCommand();
            this.adpnc = new System.Data.OracleClient.OracleDataAdapter();
            this.cnn1 = new System.Data.OracleClient.OracleConnection();
            this.SuspendLayout();
            // 
            // cnn
            // 
            this.cnn.ConnectionString = "user id=logistika600;data source=server3;password=logistika600";
            // 
            // cmdSelectZonas
            // 
            this.cmdSelectZonas.CommandText = "SELECT B.BODEGA, A.NOMBRE || \'->\' || B.NOMBRE AS NOMBRE FROM WMS_BODEGAS A, WMS_B" +
                "ODEGAS B WHERE A.BODEGA = B.BODEGA_PADRE";
            this.cmdSelectZonas.Connection = this.cnn;
            // 
            // oracleInsertCommand2
            // 
            this.oracleInsertCommand2.CommandText = resources.GetString("oracleInsertCommand2.CommandText");
            this.oracleInsertCommand2.Connection = this.cnn;
            this.oracleInsertCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":INDICE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "INDICE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":BODEGA_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA_PADRE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 50, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 1, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":DIRECCION", System.Data.OracleClient.OracleType.VarChar, 200, "DIRECCION"),
            new System.Data.OracleClient.OracleParameter(":TELEFONOS", System.Data.OracleClient.OracleType.VarChar, 20, "TELEFONOS"),
            new System.Data.OracleClient.OracleParameter(":RESPONSABLE", System.Data.OracleClient.OracleType.VarChar, 30, "RESPONSABLE"),
            new System.Data.OracleClient.OracleParameter(":BDD", System.Data.OracleClient.OracleType.VarChar, 20, "BDD"),
            new System.Data.OracleClient.OracleParameter(":BODEGA_ALTERNA", System.Data.OracleClient.OracleType.VarChar, 20, "BODEGA_ALTERNA"),
            new System.Data.OracleClient.OracleParameter(":REPLICAR_TRASLADOS", System.Data.OracleClient.OracleType.VarChar, 1, "REPLICAR_TRASLADOS"),
            new System.Data.OracleClient.OracleParameter(":REGION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "REGION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":PRIORIDAD_DESCARGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "PRIORIDAD_DESCARGA", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleUpdateCommand2
            // 
            this.oracleUpdateCommand2.CommandText = resources.GetString("oracleUpdateCommand2.CommandText");
            this.oracleUpdateCommand2.Connection = this.cnn;
            this.oracleUpdateCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":INDICE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "INDICE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":BODEGA_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA_PADRE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 50, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 1, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":DIRECCION", System.Data.OracleClient.OracleType.VarChar, 200, "DIRECCION"),
            new System.Data.OracleClient.OracleParameter(":TELEFONOS", System.Data.OracleClient.OracleType.VarChar, 20, "TELEFONOS"),
            new System.Data.OracleClient.OracleParameter(":RESPONSABLE", System.Data.OracleClient.OracleType.VarChar, 30, "RESPONSABLE"),
            new System.Data.OracleClient.OracleParameter(":BDD", System.Data.OracleClient.OracleType.VarChar, 20, "BDD"),
            new System.Data.OracleClient.OracleParameter(":BODEGA_ALTERNA", System.Data.OracleClient.OracleType.VarChar, 20, "BODEGA_ALTERNA"),
            new System.Data.OracleClient.OracleParameter(":REPLICAR_TRASLADOS", System.Data.OracleClient.OracleType.VarChar, 1, "REPLICAR_TRASLADOS"),
            new System.Data.OracleClient.OracleParameter(":REGION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "REGION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":PRIORIDAD_DESCARGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "PRIORIDAD_DESCARGA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BDD", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BDD", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA_ALTERNA", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BODEGA_ALTERNA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA_PADRE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DIRECCION", System.Data.OracleClient.OracleType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DIRECCION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_INDICE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "INDICE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_NOMBRE", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NOMBRE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_PRIORIDAD_DESCARGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "PRIORIDAD_DESCARGA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_REGION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "REGION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_REPLICAR_TRASLADOS", System.Data.OracleClient.OracleType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "REPLICAR_TRASLADOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RESPONSABLE", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RESPONSABLE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TELEFONOS", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TELEFONOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TIPO", System.Data.OracleClient.OracleType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TIPO", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleDeleteCommand2
            // 
            this.oracleDeleteCommand2.CommandText = resources.GetString("oracleDeleteCommand2.CommandText");
            this.oracleDeleteCommand2.Connection = this.cnn;
            this.oracleDeleteCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BDD", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BDD", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA_ALTERNA", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BODEGA_ALTERNA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_BODEGA_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "BODEGA_PADRE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DIRECCION", System.Data.OracleClient.OracleType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DIRECCION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_INDICE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "INDICE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_NOMBRE", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NOMBRE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_PRIORIDAD_DESCARGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "PRIORIDAD_DESCARGA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_REGION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "REGION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_REPLICAR_TRASLADOS", System.Data.OracleClient.OracleType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "REPLICAR_TRASLADOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RESPONSABLE", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RESPONSABLE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TELEFONOS", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TELEFONOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TIPO", System.Data.OracleClient.OracleType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TIPO", System.Data.DataRowVersion.Original, null)});
            // 
            // adpZonas
            // 
            this.adpZonas.DeleteCommand = this.oracleDeleteCommand2;
            this.adpZonas.InsertCommand = this.oracleInsertCommand2;
            this.adpZonas.SelectCommand = this.cmdSelectZonas;
            this.adpZonas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_BODEGAS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("BODEGA", "BODEGA"),
                        new System.Data.Common.DataColumnMapping("INDICE", "INDICE"),
                        new System.Data.Common.DataColumnMapping("BODEGA_PADRE", "BODEGA_PADRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
                        new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("RESPONSABLE", "RESPONSABLE"),
                        new System.Data.Common.DataColumnMapping("BDD", "BDD"),
                        new System.Data.Common.DataColumnMapping("BODEGA_ALTERNA", "BODEGA_ALTERNA"),
                        new System.Data.Common.DataColumnMapping("REPLICAR_TRASLADOS", "REPLICAR_TRASLADOS"),
                        new System.Data.Common.DataColumnMapping("REGION", "REGION"),
                        new System.Data.Common.DataColumnMapping("PRIORIDAD_DESCARGA", "PRIORIDAD_DESCARGA")})});
            this.adpZonas.UpdateCommand = this.oracleUpdateCommand2;
            // 
            // adpClasificaciones
            // 
            this.adpClasificaciones.SelectCommand = this.oracleSelectCommand1;
            this.adpClasificaciones.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_CLASIFICACIONES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CLASIFICACION", "CLASIFICACION"),
                        new System.Data.Common.DataColumnMapping("PADRE", "PADRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION")})});
            // 
            // oracleSelectCommand1
            // 
            this.oracleSelectCommand1.CommandText = "SELECT CLASIFICACION, PADRE, DESCRIPCION FROM WMS_CLASIFICACIONES WHERE 1 = 1";
            this.oracleSelectCommand1.Connection = this.cnn;
            // 
            // adpFilters
            // 
            this.adpFilters.DeleteCommand = this.oracleDeleteCommand1;
            this.adpFilters.InsertCommand = this.oracleInsertCommand1;
            this.adpFilters.SelectCommand = this.oracleSelectCommand2;
            this.adpFilters.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "CG_USER_FILTERS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("FILTER_NAME", "FILTER_NAME"),
                        new System.Data.Common.DataColumnMapping("WHERE_CLAUSE", "WHERE_CLAUSE"),
                        new System.Data.Common.DataColumnMapping("ORDERBY_CLAUSE", "ORDERBY_CLAUSE"),
                        new System.Data.Common.DataColumnMapping("USER_ID", "USER_ID"),
                        new System.Data.Common.DataColumnMapping("MODULE_NAME", "MODULE_NAME"),
                        new System.Data.Common.DataColumnMapping("PRIVATE_FILTER", "PRIVATE_FILTER"),
                        new System.Data.Common.DataColumnMapping("LAST_USED", "LAST_USED"),
                        new System.Data.Common.DataColumnMapping("PIVOT_LAYOUT", "PIVOT_LAYOUT")})});
            this.adpFilters.UpdateCommand = this.oracleUpdateCommand1;
            // 
            // oracleDeleteCommand1
            // 
            this.oracleDeleteCommand1.CommandText = "DELETE FROM CG_USER_FILTERS WHERE (FILTER_NAME = :Original_FILTER_NAME) AND (MODU" +
                "LE_NAME = :Original_MODULE_NAME) AND (USER_ID = :Original_USER_ID)";
            this.oracleDeleteCommand1.Connection = this.cnn;
            this.oracleDeleteCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_FILTER_NAME", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FILTER_NAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_MODULE_NAME", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MODULE_NAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_USER_ID", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "USER_ID", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand1
            // 
            this.oracleInsertCommand1.CommandText = resources.GetString("oracleInsertCommand1.CommandText");
            this.oracleInsertCommand1.Connection = this.cnn;
            this.oracleInsertCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":FILTER_NAME", System.Data.OracleClient.OracleType.VarChar, 50, "FILTER_NAME"),
            new System.Data.OracleClient.OracleParameter(":WHERE_CLAUSE", System.Data.OracleClient.OracleType.VarChar, 4000, "WHERE_CLAUSE"),
            new System.Data.OracleClient.OracleParameter(":ORDERBY_CLAUSE", System.Data.OracleClient.OracleType.VarChar, 4000, "ORDERBY_CLAUSE"),
            new System.Data.OracleClient.OracleParameter(":USER_ID", System.Data.OracleClient.OracleType.VarChar, 30, "USER_ID"),
            new System.Data.OracleClient.OracleParameter(":MODULE_NAME", System.Data.OracleClient.OracleType.VarChar, 30, "MODULE_NAME"),
            new System.Data.OracleClient.OracleParameter(":PRIVATE_FILTER", System.Data.OracleClient.OracleType.VarChar, 1, "PRIVATE_FILTER"),
            new System.Data.OracleClient.OracleParameter(":LAST_USED", System.Data.OracleClient.OracleType.DateTime, 0, "LAST_USED"),
            new System.Data.OracleClient.OracleParameter(":PIVOT_LAYOUT", System.Data.OracleClient.OracleType.Raw, 0, "PIVOT_LAYOUT")});
            // 
            // oracleSelectCommand2
            // 
            this.oracleSelectCommand2.CommandText = "SELECT FILTER_NAME, WHERE_CLAUSE, ORDERBY_CLAUSE, USER_ID, MODULE_NAME, PRIVATE_F" +
                "ILTER, LAST_USED, PIVOT_LAYOUT FROM CG_USER_FILTERS";
            this.oracleSelectCommand2.Connection = this.cnn;
            // 
            // oracleUpdateCommand1
            // 
            this.oracleUpdateCommand1.CommandText = resources.GetString("oracleUpdateCommand1.CommandText");
            this.oracleUpdateCommand1.Connection = this.cnn;
            this.oracleUpdateCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":FILTER_NAME", System.Data.OracleClient.OracleType.VarChar, 50, "FILTER_NAME"),
            new System.Data.OracleClient.OracleParameter(":WHERE_CLAUSE", System.Data.OracleClient.OracleType.VarChar, 4000, "WHERE_CLAUSE"),
            new System.Data.OracleClient.OracleParameter(":ORDERBY_CLAUSE", System.Data.OracleClient.OracleType.VarChar, 4000, "ORDERBY_CLAUSE"),
            new System.Data.OracleClient.OracleParameter(":USER_ID", System.Data.OracleClient.OracleType.VarChar, 30, "USER_ID"),
            new System.Data.OracleClient.OracleParameter(":MODULE_NAME", System.Data.OracleClient.OracleType.VarChar, 30, "MODULE_NAME"),
            new System.Data.OracleClient.OracleParameter(":PRIVATE_FILTER", System.Data.OracleClient.OracleType.VarChar, 1, "PRIVATE_FILTER"),
            new System.Data.OracleClient.OracleParameter(":LAST_USED", System.Data.OracleClient.OracleType.DateTime, 0, "LAST_USED"),
            new System.Data.OracleClient.OracleParameter(":PIVOT_LAYOUT", System.Data.OracleClient.OracleType.Raw, 0, "PIVOT_LAYOUT"),
            new System.Data.OracleClient.OracleParameter(":Original_FILTER_NAME", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FILTER_NAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_MODULE_NAME", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MODULE_NAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_USER_ID", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "USER_ID", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleSelectCommand3
            // 
            this.oracleSelectCommand3.CommandText = "SELECT DESCRIPCION, CLASIFICACION FROM WMS_CLASIFICACIONES";
            this.oracleSelectCommand3.Connection = this.cnn;
            // 
            // oracleInsertCommand3
            // 
            this.oracleInsertCommand3.CommandText = "INSERT INTO WMS_CLASIFICACIONES(DESCRIPCION, CLASIFICACION) VALUES (:DESCRIPCION," +
                " :CLASIFICACION)";
            this.oracleInsertCommand3.Connection = this.cnn;
            this.oracleInsertCommand3.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 50, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":CLASIFICACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CLASIFICACION", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleUpdateCommand3
            // 
            this.oracleUpdateCommand3.CommandText = "UPDATE WMS_CLASIFICACIONES SET DESCRIPCION = :DESCRIPCION, CLASIFICACION = :CLASI" +
                "FICACION WHERE (CLASIFICACION = :Original_CLASIFICACION) AND (DESCRIPCION = :Ori" +
                "ginal_DESCRIPCION)";
            this.oracleUpdateCommand3.Connection = this.cnn;
            this.oracleUpdateCommand3.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 50, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":CLASIFICACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CLASIFICACION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":Original_CLASIFICACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CLASIFICACION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DESCRIPCION", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleDeleteCommand3
            // 
            this.oracleDeleteCommand3.CommandText = "DELETE FROM WMS_CLASIFICACIONES WHERE (CLASIFICACION = :Original_CLASIFICACION) A" +
                "ND (DESCRIPCION = :Original_DESCRIPCION)";
            this.oracleDeleteCommand3.Connection = this.cnn;
            this.oracleDeleteCommand3.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_CLASIFICACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CLASIFICACION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DESCRIPCION", System.Data.DataRowVersion.Original, null)});
            // 
            // adpClasificacionSkus
            // 
            this.adpClasificacionSkus.DeleteCommand = this.oracleDeleteCommand3;
            this.adpClasificacionSkus.InsertCommand = this.oracleInsertCommand3;
            this.adpClasificacionSkus.SelectCommand = this.oracleSelectCommand3;
            this.adpClasificacionSkus.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_CLASIFICACIONES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("CLASIFICACION", "CLASIFICACION")})});
            this.adpClasificacionSkus.UpdateCommand = this.oracleUpdateCommand3;
            // 
            // oracleSelectCommand4
            // 
            this.oracleSelectCommand4.CommandText = resources.GetString("oracleSelectCommand4.CommandText");
            this.oracleSelectCommand4.Connection = this.cnn;
            // 
            // oracleInsertCommand4
            // 
            this.oracleInsertCommand4.CommandText = "INSERT INTO WMS_SKUS(SKU, SKU_ALTERNO, DESCRIPCION, CODIGO_BARRAS) VALUES (:SKU, " +
                ":SKU_ALTERNO, :DESCRIPCION, :CODIGO_BARRAS)";
            this.oracleInsertCommand4.Connection = this.cnn;
            this.oracleInsertCommand4.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":SKU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SKU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SKU_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, "SKU_ALTERNO"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 120, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":CODIGO_BARRAS", System.Data.OracleClient.OracleType.VarChar, 40, "CODIGO_BARRAS")});
            // 
            // oracleUpdateCommand4
            // 
            this.oracleUpdateCommand4.CommandText = resources.GetString("oracleUpdateCommand4.CommandText");
            this.oracleUpdateCommand4.Connection = this.cnn;
            this.oracleUpdateCommand4.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":SKU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SKU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SKU_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, "SKU_ALTERNO"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 120, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":CODIGO_BARRAS", System.Data.OracleClient.OracleType.VarChar, 40, "CODIGO_BARRAS"),
            new System.Data.OracleClient.OracleParameter(":Original_SKU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SKU", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_CODIGO_BARRAS", System.Data.OracleClient.OracleType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CODIGO_BARRAS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 120, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DESCRIPCION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_SKU_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SKU_ALTERNO", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleDeleteCommand4
            // 
            this.oracleDeleteCommand4.CommandText = resources.GetString("oracleDeleteCommand4.CommandText");
            this.oracleDeleteCommand4.Connection = this.cnn;
            this.oracleDeleteCommand4.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_SKU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SKU", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_CODIGO_BARRAS", System.Data.OracleClient.OracleType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CODIGO_BARRAS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 120, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DESCRIPCION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_SKU_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SKU_ALTERNO", System.Data.DataRowVersion.Original, null)});
            // 
            // adpLOVSkus
            // 
            this.adpLOVSkus.DeleteCommand = this.oracleDeleteCommand4;
            this.adpLOVSkus.InsertCommand = this.oracleInsertCommand4;
            this.adpLOVSkus.SelectCommand = this.oracleSelectCommand4;
            this.adpLOVSkus.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_SKUS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SKU", "SKU"),
                        new System.Data.Common.DataColumnMapping("SKU_ALTERNO", "SKU_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("CODIGO_BARRAS", "CODIGO_BARRAS")})});
            this.adpLOVSkus.UpdateCommand = this.oracleUpdateCommand4;
            // 
            // oracleSelectCommand5
            // 
            this.oracleSelectCommand5.CommandText = "SELECT RV_LOW_VALUE, RV_MEANING FROM CG_REF_CODES WHERE (RV_DOMAIN = \'RANKING VEN" +
                "TAS\')";
            this.oracleSelectCommand5.Connection = this.cnn;
            // 
            // adpRankingVentas
            // 
            this.adpRankingVentas.SelectCommand = this.oracleSelectCommand5;
            this.adpRankingVentas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "RankingVentas", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("RV_LOW_VALUE", "RV_LOW_VALUE"),
                        new System.Data.Common.DataColumnMapping("RV_MEANING", "RV_MEANING")})});
            // 
            // oracleSelectCommand6
            // 
            this.oracleSelectCommand6.CommandText = resources.GetString("oracleSelectCommand6.CommandText");
            this.oracleSelectCommand6.Connection = this.cnn;
            // 
            // oracleInsertCommand5
            // 
            this.oracleInsertCommand5.CommandText = resources.GetString("oracleInsertCommand5.CommandText");
            this.oracleInsertCommand5.Connection = this.cnn;
            this.oracleInsertCommand5.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "RV_DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_LOW_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_HIGH_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, "RV_ABBREVIATION"),
            new System.Data.OracleClient.OracleParameter(":RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MEANING"),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC03"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC03"),
            new System.Data.OracleClient.OracleParameter(":RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CREATED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CREATED"),
            new System.Data.OracleClient.OracleParameter(":RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CHANGED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CHANGED"),
            new System.Data.OracleClient.OracleParameter(":RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, "RV_DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC00", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC00")});
            // 
            // oracleUpdateCommand5
            // 
            this.oracleUpdateCommand5.CommandText = resources.GetString("oracleUpdateCommand5.CommandText");
            this.oracleUpdateCommand5.Connection = this.cnn;
            this.oracleUpdateCommand5.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "RV_DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_LOW_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_HIGH_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, "RV_ABBREVIATION"),
            new System.Data.OracleClient.OracleParameter(":RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MEANING"),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC03"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC03"),
            new System.Data.OracleClient.OracleParameter(":RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CREATED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CREATED"),
            new System.Data.OracleClient.OracleParameter(":RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CHANGED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CHANGED"),
            new System.Data.OracleClient.OracleParameter(":RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, "RV_DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC00", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC00"),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_LOW_VALUE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_ABBREVIATION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_CHANGED_BY", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_CREATED_BY", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DATE_CHANGED", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DATE_CREATED", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DESCRIPTION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_HIGH_VALUE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MEANING", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC00", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC00", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleDeleteCommand5
            // 
            this.oracleDeleteCommand5.CommandText = resources.GetString("oracleDeleteCommand5.CommandText");
            this.oracleDeleteCommand5.Connection = this.cnn;
            this.oracleDeleteCommand5.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_LOW_VALUE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_ABBREVIATION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_CHANGED_BY", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_CREATED_BY", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DATE_CHANGED", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DATE_CREATED", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DESCRIPTION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_HIGH_VALUE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MEANING", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPCC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_MPDC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Original, null)});
            // 
            // adpDomains
            // 
            this.adpDomains.DeleteCommand = this.oracleDeleteCommand5;
            this.adpDomains.InsertCommand = this.oracleInsertCommand5;
            this.adpDomains.SelectCommand = this.oracleSelectCommand6;
            this.adpDomains.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "ALLDOMAINS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("RV_DOMAIN", "RV_DOMAIN"),
                        new System.Data.Common.DataColumnMapping("RV_LOW_VALUE", "RV_LOW_VALUE"),
                        new System.Data.Common.DataColumnMapping("RV_HIGH_VALUE", "RV_HIGH_VALUE"),
                        new System.Data.Common.DataColumnMapping("RV_ABBREVIATION", "RV_ABBREVIATION"),
                        new System.Data.Common.DataColumnMapping("RV_MEANING", "RV_MEANING"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC01", "RV_MPNC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC02", "RV_MPNC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC03", "RV_MPNC03"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC01", "RV_MPCC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC02", "RV_MPCC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC03", "RV_MPCC03"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC01", "RV_MPDC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC02", "RV_MPDC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC03", "RV_MPDC03"),
                        new System.Data.Common.DataColumnMapping("RV_CREATED_BY", "RV_CREATED_BY"),
                        new System.Data.Common.DataColumnMapping("RV_DATE_CREATED", "RV_DATE_CREATED"),
                        new System.Data.Common.DataColumnMapping("RV_CHANGED_BY", "RV_CHANGED_BY"),
                        new System.Data.Common.DataColumnMapping("RV_DATE_CHANGED", "RV_DATE_CHANGED"),
                        new System.Data.Common.DataColumnMapping("RV_TIMES_CHANGED", "RV_TIMES_CHANGED"),
                        new System.Data.Common.DataColumnMapping("RV_SEQUENCE", "RV_SEQUENCE"),
                        new System.Data.Common.DataColumnMapping("RV_DESCRIPTION", "RV_DESCRIPTION"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC00", "RV_MPCC00")})});
            this.adpDomains.UpdateCommand = this.oracleUpdateCommand5;
            // 
            // adpFormatoImpresiones
            // 
            this.adpFormatoImpresiones.DeleteCommand = this.oracleDeleteCommand6;
            this.adpFormatoImpresiones.InsertCommand = this.oracleInsertCommand6;
            this.adpFormatoImpresiones.SelectCommand = this.oracleSelectCommand7;
            this.adpFormatoImpresiones.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "PAR_FORMATO_IMPRESIONES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("IMPRESION", "IMPRESION"),
                        new System.Data.Common.DataColumnMapping("SECUENCIA", "SECUENCIA"),
                        new System.Data.Common.DataColumnMapping("VARIABLE", "VARIABLE"),
                        new System.Data.Common.DataColumnMapping("VALOR", "VALOR"),
                        new System.Data.Common.DataColumnMapping("TIPO_LETRA", "TIPO_LETRA"),
                        new System.Data.Common.DataColumnMapping("TAMAÑO", "TAMAÑO"),
                        new System.Data.Common.DataColumnMapping("ALINEACION", "ALINEACION"),
                        new System.Data.Common.DataColumnMapping("ATRIBUTOS", "ATRIBUTOS"),
                        new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO")})});
            this.adpFormatoImpresiones.UpdateCommand = this.oracleUpdateCommand6;
            // 
            // oracleDeleteCommand6
            // 
            this.oracleDeleteCommand6.CommandText = resources.GetString("oracleDeleteCommand6.CommandText");
            this.oracleDeleteCommand6.Connection = this.cnn;
            this.oracleDeleteCommand6.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_IMPRESION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "IMPRESION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_SECUENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "SECUENCIA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_ALINEACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(1)), ((byte)(0)), "ALINEACION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_ATRIBUTOS", System.Data.OracleClient.OracleType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ATRIBUTOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_GRUPO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "GRUPO", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TAMAÑO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(1)), "TAMAÑO", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TIPO_LETRA", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TIPO_LETRA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_VALOR", System.Data.OracleClient.OracleType.VarChar, 500, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALOR", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_VARIABLE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "VARIABLE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand6
            // 
            this.oracleInsertCommand6.CommandText = resources.GetString("oracleInsertCommand6.CommandText");
            this.oracleInsertCommand6.Connection = this.cnn;
            this.oracleInsertCommand6.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":IMPRESION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "IMPRESION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SECUENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "SECUENCIA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":VARIABLE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "VARIABLE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":VALOR", System.Data.OracleClient.OracleType.VarChar, 500, "VALOR"),
            new System.Data.OracleClient.OracleParameter(":TIPO_LETRA", System.Data.OracleClient.OracleType.VarChar, 30, "TIPO_LETRA"),
            new System.Data.OracleClient.OracleParameter(":TAMAÑO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(1)), "TAMAÑO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":ALINEACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(1)), ((byte)(0)), "ALINEACION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":ATRIBUTOS", System.Data.OracleClient.OracleType.VarChar, 10, "ATRIBUTOS"),
            new System.Data.OracleClient.OracleParameter(":GRUPO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "GRUPO", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleSelectCommand7
            // 
            this.oracleSelectCommand7.CommandText = "SELECT IMPRESION, SECUENCIA, VARIABLE, VALOR, TIPO_LETRA, TAMAÑO, ALINEACION, ATR" +
                "IBUTOS, GRUPO FROM PAR_FORMATO_IMPRESIONES ORDER BY IMPRESION, SECUENCIA";
            this.oracleSelectCommand7.Connection = this.cnn;
            // 
            // oracleUpdateCommand6
            // 
            this.oracleUpdateCommand6.CommandText = resources.GetString("oracleUpdateCommand6.CommandText");
            this.oracleUpdateCommand6.Connection = this.cnn;
            this.oracleUpdateCommand6.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":IMPRESION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "IMPRESION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SECUENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "SECUENCIA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":VARIABLE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "VARIABLE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":VALOR", System.Data.OracleClient.OracleType.VarChar, 500, "VALOR"),
            new System.Data.OracleClient.OracleParameter(":TIPO_LETRA", System.Data.OracleClient.OracleType.VarChar, 30, "TIPO_LETRA"),
            new System.Data.OracleClient.OracleParameter(":TAMAÑO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(1)), "TAMAÑO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":ALINEACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(1)), ((byte)(0)), "ALINEACION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":ATRIBUTOS", System.Data.OracleClient.OracleType.VarChar, 10, "ATRIBUTOS"),
            new System.Data.OracleClient.OracleParameter(":GRUPO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "GRUPO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":Original_IMPRESION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "IMPRESION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_SECUENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "SECUENCIA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_ALINEACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(1)), ((byte)(0)), "ALINEACION", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_ATRIBUTOS", System.Data.OracleClient.OracleType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ATRIBUTOS", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_GRUPO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "GRUPO", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TAMAÑO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(1)), "TAMAÑO", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_TIPO_LETRA", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TIPO_LETRA", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_VALOR", System.Data.OracleClient.OracleType.VarChar, 500, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALOR", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_VARIABLE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "VARIABLE", System.Data.DataRowVersion.Original, null)});
            // 
            // adpCuentas
            // 
            this.adpCuentas.InsertCommand = this.oracleInsertCommand7;
            this.adpCuentas.SelectCommand = this.oracleSelectCommand8;
            this.adpCuentas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "DOC_CUENTAS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CUENTA", "CUENTA"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE")})});
            // 
            // oracleInsertCommand7
            // 
            this.oracleInsertCommand7.CommandText = "INSERT INTO DOC_CUENTAS(CUENTA) VALUES (:CUENTA)";
            this.oracleInsertCommand7.Connection = this.cnn;
            this.oracleInsertCommand7.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CUENTA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CUENTA", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleSelectCommand8
            // 
            this.oracleSelectCommand8.CommandText = "SELECT CUENTA, NOMBRE || \' (\' || cg_f_code_meaning(\'BANCOS\', BANCO) || \')\' AS NOM" +
                "BRE FROM DOC_CUENTAS WHERE (TIPO_CUENTA IN (1, 2)) ORDER BY NOMBRE";
            this.oracleSelectCommand8.Connection = this.cnn;
            // 
            // adpClientes
            // 
            this.adpClientes.InsertCommand = this.oracleInsertCommand8;
            this.adpClientes.SelectCommand = this.oracleSelectCommand9;
            this.adpClientes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "RET_V_CLIENTES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_ALTERNO", "SOCIO_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_COMERCIAL", "NOMBRE_COMERCIAL"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("LIMITE_CREDITO", "LIMITE_CREDITO"),
                        new System.Data.Common.DataColumnMapping("DESCUENTO_PRONTO_PAGO", "DESCUENTO_PRONTO_PAGO"),
                        new System.Data.Common.DataColumnMapping("EMAIL", "EMAIL"),
                        new System.Data.Common.DataColumnMapping("DIRECCION1", "DIRECCION1"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("PLAZO_PAGO", "PLAZO_PAGO"),
                        new System.Data.Common.DataColumnMapping("RANKING_VENTAS", "RANKING_VENTAS"),
                        new System.Data.Common.DataColumnMapping("SOCIO_PADRE", "SOCIO_PADRE"),
                        new System.Data.Common.DataColumnMapping("ALTERNO_PADRE", "ALTERNO_PADRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_PADRE", "NOMBRE_PADRE"),
                        new System.Data.Common.DataColumnMapping("CREADO_EL", "CREADO_EL"),
                        new System.Data.Common.DataColumnMapping("MODIFICADO_EL", "MODIFICADO_EL")})});
            // 
            // oracleInsertCommand8
            // 
            this.oracleInsertCommand8.CommandText = "INSERT INTO RET_V_CLIENTES(SOCIO, SOCIO_ALTERNO, NOMBRE, NOMBRE_COMERCIAL, NIT) V" +
                "ALUES (:SOCIO, :SOCIO_ALTERNO, :NOMBRE, :NOMBRE_COMERCIAL, :NIT)";
            this.oracleInsertCommand8.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":SOCIO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SOCIO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SOCIO_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, "SOCIO_ALTERNO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE_COMERCIAL", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE_COMERCIAL"),
            new System.Data.OracleClient.OracleParameter(":NIT", System.Data.OracleClient.OracleType.VarChar, 30, "NIT")});
            // 
            // oracleSelectCommand9
            // 
            this.oracleSelectCommand9.CommandText = resources.GetString("oracleSelectCommand9.CommandText");
            this.oracleSelectCommand9.Connection = this.cnn;
            // 
            // selectLOVProveedores
            // 
            this.selectLOVProveedores.CommandText = "select socio, socio_alterno, nombre, nombre_comercial, nit, moneda, nvl(plazo_pag" +
                "o,0) plazo_pago from wms_socios where proveedor = \'S\'";
            this.selectLOVProveedores.Connection = this.cnn;
            // 
            // adpLOVProveedores
            // 
            this.adpLOVProveedores.SelectCommand = this.selectLOVProveedores;
            this.adpLOVProveedores.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "LOVProveedor", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_ALTERNO", "SOCIO_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_COMERCIAL", "NOMBRE_COMERCIAL"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("MONEDA", "MONEDA"),
                        new System.Data.Common.DataColumnMapping("PLAZO_PAGO", "PLAZO_PAGO")})});
            // 
            // selectMonedas
            // 
            this.selectMonedas.CommandText = resources.GetString("selectMonedas.CommandText");
            this.selectMonedas.Connection = this.cnn;
            // 
            // adpMonedas
            // 
            this.adpMonedas.SelectCommand = this.selectMonedas;
            this.adpMonedas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Monedas", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("SIMBOLO", "SIMBOLO"),
                        new System.Data.Common.DataColumnMapping("MONEDA", "MONEDA"),
                        new System.Data.Common.DataColumnMapping("TASA_MB", "TASA_MB"),
                        new System.Data.Common.DataColumnMapping("TASA_MA", "TASA_MA")})});
            // 
            // adpLOVClientes
            // 
            this.adpLOVClientes.SelectCommand = this.selectLOVClientes;
            this.adpLOVClientes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "LOVCliente", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_ALTERNO", "SOCIO_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_COMERCIAL", "NOMBRE_COMERCIAL"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT")})});
            // 
            // selectLOVClientes
            // 
            this.selectLOVClientes.CommandText = "select socio, socio_alterno, nombre, nombre_comercial, nit from wms_socios where " +
                "cliente = \'S\'";
            this.selectLOVClientes.Connection = this.cnn;
            // 
            // adpAntiSaldos
            // 
            this.adpAntiSaldos.SelectCommand = this.oracleCommand1;
            this.adpAntiSaldos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "CUF_V_CXC", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("VENDEDOR", "VENDEDOR"),
                        new System.Data.Common.DataColumnMapping("FECHA", "FECHA"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("CREADO_POR", "CREADO_POR"),
                        new System.Data.Common.DataColumnMapping("BODEGA", "BODEGA"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("DIAS_ATRASO", "DIAS_ATRASO"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("ANTIGUEDAD", "ANTIGUEDAD"),
                        new System.Data.Common.DataColumnMapping("SALDO_MA", "SALDO_MA"),
                        new System.Data.Common.DataColumnMapping("TOTAL_MA", "TOTAL_MA")})});
            // 
            // oracleCommand1
            // 
            this.oracleCommand1.CommandText = "select * from cuf_v_cxc where socio in (SELECT SOCIO FROM RET_V_CLIENTES WHERE (1" +
                " = 1))";
            this.oracleCommand1.Connection = this.cnn;
            // 
            // adpEstadoCuenta
            // 
            this.adpEstadoCuenta.SelectCommand = this.oracleSelectCommand10;
            this.adpEstadoCuenta.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "RET_V_EC", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("MOVIMIENTO", "MOVIMIENTO"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("FECHA", "FECHA"),
                        new System.Data.Common.DataColumnMapping("TIPO_REFERENCIA", "TIPO_REFERENCIA"),
                        new System.Data.Common.DataColumnMapping("REFERENCIA", "REFERENCIA"),
                        new System.Data.Common.DataColumnMapping("DEBITO", "DEBITO"),
                        new System.Data.Common.DataColumnMapping("CREDITO", "CREDITO"),
                        new System.Data.Common.DataColumnMapping("MONEDA", "MONEDA"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO")})});
            // 
            // oracleSelectCommand10
            // 
            this.oracleSelectCommand10.CommandText = "select * from RET_V_EC";
            this.oracleSelectCommand10.Connection = this.cnn;
            // 
            // adpProveedores
            // 
            this.adpProveedores.SelectCommand = this.oracleSelectCommand11;
            this.adpProveedores.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_SOCIOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_ALTERNO", "SOCIO_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_COMERCIAL", "NOMBRE_COMERCIAL"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("ABREV_MONEDA", "ABREV_MONEDA")})});
            // 
            // oracleSelectCommand11
            // 
            this.oracleSelectCommand11.CommandText = "SELECT SOCIO, SOCIO_ALTERNO, NOMBRE, NOMBRE_COMERCIAL, NIT, cg_f_code_abreviation" +
                " (\'MONEDA\', NVL (moneda, wms_f_moneda_base ())) ABREV_MONEDA FROM WMS_SOCIOS WHE" +
                "RE  PROVEEDOR = \'S\'";
            this.oracleSelectCommand11.Connection = this.cnn;
            // 
            // adpEstadoCuentaProveedores
            // 
            this.adpEstadoCuentaProveedores.SelectCommand = this.oracleSelectCommand12;
            this.adpEstadoCuentaProveedores.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "RET_V_ECP", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("MOVIMIENTO", "MOVIMIENTO"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("FECHA", "FECHA"),
                        new System.Data.Common.DataColumnMapping("TIPO_REFERENCIA", "TIPO_REFERENCIA"),
                        new System.Data.Common.DataColumnMapping("REFERENCIA", "REFERENCIA"),
                        new System.Data.Common.DataColumnMapping("DEBITO", "DEBITO"),
                        new System.Data.Common.DataColumnMapping("CREDITO", "CREDITO"),
                        new System.Data.Common.DataColumnMapping("MONEDA", "MONEDA"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO")})});
            // 
            // oracleSelectCommand12
            // 
            this.oracleSelectCommand12.CommandText = "SELECT MOVIMIENTO, SOCIO, FECHA, TIPO_REFERENCIA, REFERENCIA, DEBITO, CREDITO, MO" +
                "NEDA, SALDO FROM RET_V_ECP";
            this.oracleSelectCommand12.Connection = this.cnn;
            // 
            // adpRegiones
            // 
            this.adpRegiones.SelectCommand = this.oracleSelectCommand13;
            this.adpRegiones.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Regiones", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("Key", "Key"),
                        new System.Data.Common.DataColumnMapping("Value", "Value"),
                        new System.Data.Common.DataColumnMapping("DISPLAY", "Display")})});
            // 
            // oracleSelectCommand13
            // 
            this.oracleSelectCommand13.CommandText = "SELECT Clasificacion, Padre , Descripcion AS Display, wms_f_ancestros_clasificaci" +
                "on(Clasificacion) region FROM wms_clasificaciones where 1=1 ";
            this.oracleSelectCommand13.Connection = this.cnn;
            // 
            // adpTiedasReabasto
            // 
            this.adpTiedasReabasto.SelectCommand = this.oracleCommand2;
            this.adpTiedasReabasto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TiendasReabasto", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CLASIFICACION", "CLASIFICACION"),
                        new System.Data.Common.DataColumnMapping("PADRE", "PADRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION")})});
            // 
            // oracleCommand2
            // 
            this.oracleCommand2.CommandText = "SELECT CLASIFICACION, PADRE, DESCRIPCION FROM WMS_CLASIFICACIONES";
            this.oracleCommand2.Connection = this.cnn;
            // 
            // adpLOVPrecioSkus
            // 
            this.adpLOVPrecioSkus.InsertCommand = this.oracleInsertCommand9;
            this.adpLOVPrecioSkus.SelectCommand = this.oracleSelectCommand14;
            this.adpLOVPrecioSkus.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_SKUS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SKU", "SKU"),
                        new System.Data.Common.DataColumnMapping("SKU_ALTERNO", "SKU_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("CODIGO_BARRAS", "CODIGO_BARRAS"),
                        new System.Data.Common.DataColumnMapping("SIMBOLO_MONEDA", "SIMBOLO_MONEDA"),
                        new System.Data.Common.DataColumnMapping("PRECIO_BASE", "PRECIO_BASE"),
                        new System.Data.Common.DataColumnMapping("PRECIO_MB", "PRECIO_MB")})});
            // 
            // oracleInsertCommand9
            // 
            this.oracleInsertCommand9.CommandText = "INSERT INTO WMS_SKUS(SKU, SKU_ALTERNO, DESCRIPCION, CODIGO_BARRAS) VALUES (:SKU, " +
                ":SKU_ALTERNO, :DESCRIPCION, :CODIGO_BARRAS)";
            this.oracleInsertCommand9.Connection = this.cnn;
            this.oracleInsertCommand9.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":SKU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "SKU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":SKU_ALTERNO", System.Data.OracleClient.OracleType.VarChar, 20, "SKU_ALTERNO"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 120, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":CODIGO_BARRAS", System.Data.OracleClient.OracleType.VarChar, 40, "CODIGO_BARRAS")});
            // 
            // oracleSelectCommand14
            // 
            this.oracleSelectCommand14.CommandText = resources.GetString("oracleSelectCommand14.CommandText");
            this.oracleSelectCommand14.Connection = this.cnn;
            // 
            // adp3PLEstadisticas
            // 
            this.adp3PLEstadisticas.SelectCommand = this.oracleSelectCommand15;
            this.adp3PLEstadisticas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "MDA_3PLESTADISTICAS_INVENTARIO", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_CONSOLIDADOR", "SOCIO_CONSOLIDADOR"),
                        new System.Data.Common.DataColumnMapping("SKU", "SKU"),
                        new System.Data.Common.DataColumnMapping("EXISTENCIA_ACTUAL", "EXISTENCIA_ACTUAL"),
                        new System.Data.Common.DataColumnMapping("FECHA", "FECHA"),
                        new System.Data.Common.DataColumnMapping("FECHA_DESC", "FECHA_DESC"),
                        new System.Data.Common.DataColumnMapping("EXISTENCIA", "EXISTENCIA"),
                        new System.Data.Common.DataColumnMapping("VOLUMEN", "VOLUMEN"),
                        new System.Data.Common.DataColumnMapping("PESO", "PESO"),
                        new System.Data.Common.DataColumnMapping("RECIBOS", "RECIBOS"),
                        new System.Data.Common.DataColumnMapping("DESPACHOS", "DESPACHOS"),
                        new System.Data.Common.DataColumnMapping("SERVICIOS", "SERVICIOS")})});
            // 
            // oracleSelectCommand15
            // 
            this.oracleSelectCommand15.CommandText = "SELECT SOCIO, SOCIO_CONSOLIDADOR, SKU, EXISTENCIA_ACTUAL, FECHA, FECHA_DESC, EXIS" +
                "TENCIA, VOLUMEN, PESO, RECIBOS, DESPACHOS, SERVICIOS FROM MDA_3PLESTADISTICAS_IN" +
                "VENTARIO";
            this.oracleSelectCommand15.Connection = this.cnn;
            // 
            // adpLOVVendedores
            // 
            this.adpLOVVendedores.SelectCommand = this.selectLOVVendedores;
            this.adpLOVVendedores.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "LOVVendedores", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("USUARIO", "USUARIO"),
                        new System.Data.Common.DataColumnMapping("NOMBRES", "NOMBRES"),
                        new System.Data.Common.DataColumnMapping("APELLIDOS", "APELLIDOS")})});
            // 
            // selectLOVVendedores
            // 
            this.selectLOVVendedores.CommandText = "SELECT USUARIO, NOMBRES, APELLIDOS FROM WMS_USUARIOS WHERE (VENDEDOR = \'S\')";
            this.selectLOVVendedores.Connection = this.cnn;
            // 
            // adpEmpresas
            // 
            this.adpEmpresas.SelectCommand = this.selectEmpresas;
            this.adpEmpresas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_EMPRESAS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("EMPRESA", "EMPRESA"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("EMAIL", "EMAIL"),
                        new System.Data.Common.DataColumnMapping("PATENTE_DE_COMERCIO", "PATENTE_DE_COMERCIO"),
                        new System.Data.Common.DataColumnMapping("LOGO", "LOGO"),
                        new System.Data.Common.DataColumnMapping("ESTADO", "ESTADO")})});
            // 
            // selectEmpresas
            // 
            this.selectEmpresas.CommandText = "SELECT EMPRESA, NOMBRE, DIRECCION, TELEFONOS, NIT, EMAIL, PATENTE_DE_COMERCIO, LO" +
                "GO, ESTADO FROM WMS_EMPRESAS WHERE (ESTADO = \'A\')";
            this.selectEmpresas.Connection = this.cnn;
            // 
            // adpRetVRegion
            // 
            this.adpRetVRegion.InsertCommand = this.oracleInsertCommand10;
            this.adpRetVRegion.SelectCommand = this.oracleSelectCommand16;
            this.adpRetVRegion.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "RET_V_REGION", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CLASIFICACION", "CLASIFICACION"),
                        new System.Data.Common.DataColumnMapping("PADRE", "PADRE"),
                        new System.Data.Common.DataColumnMapping("DISPLAY", "DISPLAY"),
                        new System.Data.Common.DataColumnMapping("REGION", "REGION")})});
            // 
            // oracleInsertCommand10
            // 
            this.oracleInsertCommand10.CommandText = "INSERT INTO RET_V_REGION(CLASIFICACION, PADRE, DISPLAY, REGION) VALUES (:CLASIFIC" +
                "ACION, :PADRE, :DISPLAY, :REGION)";
            this.oracleInsertCommand10.Connection = this.cnn;
            this.oracleInsertCommand10.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CLASIFICACION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "CLASIFICACION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "PADRE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DISPLAY", System.Data.OracleClient.OracleType.VarChar, 50, "DISPLAY"),
            new System.Data.OracleClient.OracleParameter(":REGION", System.Data.OracleClient.OracleType.VarChar, 4000, "REGION")});
            // 
            // oracleSelectCommand16
            // 
            this.oracleSelectCommand16.CommandText = "SELECT CLASIFICACION, PADRE, DISPLAY, REGION FROM RET_V_REGION WHERE (1 = 1)";
            this.oracleSelectCommand16.Connection = this.cnn;
            // 
            // adpCgDomains
            // 
            this.adpCgDomains.DeleteCommand = this.oracleDeleteCommand7;
            this.adpCgDomains.InsertCommand = this.oracleInsertCommand11;
            this.adpCgDomains.SelectCommand = this.oracleSelectCommand17;
            this.adpCgDomains.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "CG_DOMAINS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOMAIN", "DOMAIN"),
                        new System.Data.Common.DataColumnMapping("DOMAIN_GROUP", "DOMAIN_GROUP"),
                        new System.Data.Common.DataColumnMapping("DATATYPE", "DATATYPE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPTION", "DESCRIPTION"),
                        new System.Data.Common.DataColumnMapping("DEFAULT_VALUE", "DEFAULT_VALUE"),
                        new System.Data.Common.DataColumnMapping("DYNAMIC_LIST", "DYNAMIC_LIST"),
                        new System.Data.Common.DataColumnMapping("SUGGESTION_LIST", "SUGGESTION_LIST")})});
            this.adpCgDomains.UpdateCommand = this.oracleUpdateCommand7;
            // 
            // oracleDeleteCommand7
            // 
            this.oracleDeleteCommand7.CommandText = "DELETE FROM CG_DOMAINS WHERE (DOMAIN = :Original_DOMAIN)";
            this.oracleDeleteCommand7.Connection = this.cnn;
            this.oracleDeleteCommand7.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand11
            // 
            this.oracleInsertCommand11.CommandText = resources.GetString("oracleInsertCommand11.CommandText");
            this.oracleInsertCommand11.Connection = this.cnn;
            this.oracleInsertCommand11.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":DOMAIN_GROUP", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN_GROUP"),
            new System.Data.OracleClient.OracleParameter(":DATATYPE", System.Data.OracleClient.OracleType.VarChar, 20, "DATATYPE"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 2000, "DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":DEFAULT_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "DEFAULT_VALUE"),
            new System.Data.OracleClient.OracleParameter(":DYNAMIC_LIST", System.Data.OracleClient.OracleType.VarChar, 1, "DYNAMIC_LIST"),
            new System.Data.OracleClient.OracleParameter(":SUGGESTION_LIST", System.Data.OracleClient.OracleType.VarChar, 1, "SUGGESTION_LIST")});
            // 
            // oracleSelectCommand17
            // 
            this.oracleSelectCommand17.CommandText = "SELECT DOMAIN, DOMAIN_GROUP, DATATYPE, DESCRIPTION, DEFAULT_VALUE, DYNAMIC_LIST, " +
                "SUGGESTION_LIST FROM CG_DOMAINS WHERE (1 = 1)";
            this.oracleSelectCommand17.Connection = this.cnn;
            // 
            // oracleUpdateCommand7
            // 
            this.oracleUpdateCommand7.CommandText = resources.GetString("oracleUpdateCommand7.CommandText");
            this.oracleUpdateCommand7.Connection = this.cnn;
            this.oracleUpdateCommand7.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":DOMAIN_GROUP", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN_GROUP"),
            new System.Data.OracleClient.OracleParameter(":DATATYPE", System.Data.OracleClient.OracleType.VarChar, 20, "DATATYPE"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 2000, "DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":DEFAULT_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "DEFAULT_VALUE"),
            new System.Data.OracleClient.OracleParameter(":DYNAMIC_LIST", System.Data.OracleClient.OracleType.VarChar, 1, "DYNAMIC_LIST"),
            new System.Data.OracleClient.OracleParameter(":SUGGESTION_LIST", System.Data.OracleClient.OracleType.VarChar, 1, "SUGGESTION_LIST"),
            new System.Data.OracleClient.OracleParameter(":Original_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // adpDomainColumns
            // 
            this.adpDomainColumns.DeleteCommand = this.oracleDeleteCommand8;
            this.adpDomainColumns.InsertCommand = this.oracleInsertCommand12;
            this.adpDomainColumns.SelectCommand = this.oracleSelectCommand18;
            this.adpDomainColumns.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "CG_DOMAIN_COLUMNS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOMAIN", "DOMAIN"),
                        new System.Data.Common.DataColumnMapping("COLUMNNAME", "COLUMNNAME"),
                        new System.Data.Common.DataColumnMapping("COLUMNCAPTION", "COLUMNCAPTION"),
                        new System.Data.Common.DataColumnMapping("VISIBLE", "VISIBLE")})});
            this.adpDomainColumns.UpdateCommand = this.oracleUpdateCommand8;
            // 
            // oracleDeleteCommand8
            // 
            this.oracleDeleteCommand8.CommandText = "DELETE FROM CG_DOMAIN_COLUMNS WHERE (COLUMNNAME = :Original_COLUMNNAME) AND (DOMA" +
                "IN = :Original_DOMAIN)";
            this.oracleDeleteCommand8.Connection = this.cnn;
            this.oracleDeleteCommand8.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_COLUMNNAME", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "COLUMNNAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand12
            // 
            this.oracleInsertCommand12.CommandText = "INSERT INTO CG_DOMAIN_COLUMNS(DOMAIN, COLUMNNAME, COLUMNCAPTION, VISIBLE) VALUES " +
                "(:DOMAIN, :COLUMNNAME, :COLUMNCAPTION, :VISIBLE)";
            this.oracleInsertCommand12.Connection = this.cnn;
            this.oracleInsertCommand12.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":COLUMNNAME", System.Data.OracleClient.OracleType.VarChar, 30, "COLUMNNAME"),
            new System.Data.OracleClient.OracleParameter(":COLUMNCAPTION", System.Data.OracleClient.OracleType.VarChar, 100, "COLUMNCAPTION"),
            new System.Data.OracleClient.OracleParameter(":VISIBLE", System.Data.OracleClient.OracleType.VarChar, 1, "VISIBLE")});
            // 
            // oracleSelectCommand18
            // 
            this.oracleSelectCommand18.CommandText = "SELECT DOMAIN, COLUMNNAME, COLUMNCAPTION, VISIBLE FROM CG_DOMAIN_COLUMNS WHERE (1" +
                " = 1)";
            this.oracleSelectCommand18.Connection = this.cnn;
            // 
            // oracleUpdateCommand8
            // 
            this.oracleUpdateCommand8.CommandText = "UPDATE CG_DOMAIN_COLUMNS SET DOMAIN = :DOMAIN, COLUMNNAME = :COLUMNNAME, COLUMNCA" +
                "PTION = :COLUMNCAPTION, VISIBLE = :VISIBLE WHERE (COLUMNNAME = :Original_COLUMNN" +
                "AME) AND (DOMAIN = :Original_DOMAIN)";
            this.oracleUpdateCommand8.Connection = this.cnn;
            this.oracleUpdateCommand8.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":COLUMNNAME", System.Data.OracleClient.OracleType.VarChar, 30, "COLUMNNAME"),
            new System.Data.OracleClient.OracleParameter(":COLUMNCAPTION", System.Data.OracleClient.OracleType.VarChar, 100, "COLUMNCAPTION"),
            new System.Data.OracleClient.OracleParameter(":VISIBLE", System.Data.OracleClient.OracleType.VarChar, 1, "VISIBLE"),
            new System.Data.OracleClient.OracleParameter(":Original_COLUMNNAME", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "COLUMNNAME", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // adpUserTabColumns
            // 
            this.adpUserTabColumns.SelectCommand = this.oracleSelectCommand19;
            this.adpUserTabColumns.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "USER_TAB_COLUMNS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("COLUMN_NAME", "COLUMN_NAME")})});
            // 
            // oracleSelectCommand19
            // 
            this.oracleSelectCommand19.CommandText = "SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE (TABLE_NAME = \'CG_REF_CODES\')";
            this.oracleSelectCommand19.Connection = this.cnn;
            // 
            // adpCgRefCodes
            // 
            this.adpCgRefCodes.DeleteCommand = this.oracleDeleteCommand9;
            this.adpCgRefCodes.InsertCommand = this.oracleInsertCommand13;
            this.adpCgRefCodes.SelectCommand = this.oracleSelectCommand20;
            this.adpCgRefCodes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "CG_REF_CODES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("RV_DOMAIN", "RV_DOMAIN"),
                        new System.Data.Common.DataColumnMapping("RV_LOW_VALUE", "RV_LOW_VALUE"),
                        new System.Data.Common.DataColumnMapping("RV_HIGH_VALUE", "RV_HIGH_VALUE"),
                        new System.Data.Common.DataColumnMapping("RV_ABBREVIATION", "RV_ABBREVIATION"),
                        new System.Data.Common.DataColumnMapping("RV_MEANING", "RV_MEANING"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC01", "RV_MPNC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC02", "RV_MPNC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPNC03", "RV_MPNC03"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC01", "RV_MPCC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC02", "RV_MPCC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC03", "RV_MPCC03"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC01", "RV_MPDC01"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC02", "RV_MPDC02"),
                        new System.Data.Common.DataColumnMapping("RV_MPDC03", "RV_MPDC03"),
                        new System.Data.Common.DataColumnMapping("RV_CREATED_BY", "RV_CREATED_BY"),
                        new System.Data.Common.DataColumnMapping("RV_DATE_CREATED", "RV_DATE_CREATED"),
                        new System.Data.Common.DataColumnMapping("RV_CHANGED_BY", "RV_CHANGED_BY"),
                        new System.Data.Common.DataColumnMapping("RV_DATE_CHANGED", "RV_DATE_CHANGED"),
                        new System.Data.Common.DataColumnMapping("RV_TIMES_CHANGED", "RV_TIMES_CHANGED"),
                        new System.Data.Common.DataColumnMapping("RV_SEQUENCE", "RV_SEQUENCE"),
                        new System.Data.Common.DataColumnMapping("RV_DESCRIPTION", "RV_DESCRIPTION"),
                        new System.Data.Common.DataColumnMapping("RV_MPCC00", "RV_MPCC00")})});
            this.adpCgRefCodes.UpdateCommand = this.oracleUpdateCommand9;
            // 
            // oracleDeleteCommand9
            // 
            this.oracleDeleteCommand9.CommandText = "DELETE FROM CG_REF_CODES WHERE (RV_DOMAIN = :Original_RV_DOMAIN) AND (RV_LOW_VALU" +
                "E = :Original_RV_LOW_VALUE)";
            this.oracleDeleteCommand9.Connection = this.cnn;
            this.oracleDeleteCommand9.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_LOW_VALUE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand13
            // 
            this.oracleInsertCommand13.CommandText = resources.GetString("oracleInsertCommand13.CommandText");
            this.oracleInsertCommand13.Connection = this.cnn;
            this.oracleInsertCommand13.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "RV_DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_LOW_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_HIGH_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, "RV_ABBREVIATION"),
            new System.Data.OracleClient.OracleParameter(":RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MEANING"),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 2000, "RV_MPCC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC03"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC03"),
            new System.Data.OracleClient.OracleParameter(":RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CREATED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CREATED"),
            new System.Data.OracleClient.OracleParameter(":RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CHANGED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CHANGED"),
            new System.Data.OracleClient.OracleParameter(":RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, "RV_DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC00", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC00")});
            // 
            // oracleSelectCommand20
            // 
            this.oracleSelectCommand20.CommandText = resources.GetString("oracleSelectCommand20.CommandText");
            this.oracleSelectCommand20.Connection = this.cnn;
            // 
            // oracleUpdateCommand9
            // 
            this.oracleUpdateCommand9.CommandText = resources.GetString("oracleUpdateCommand9.CommandText");
            this.oracleUpdateCommand9.Connection = this.cnn;
            this.oracleUpdateCommand9.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, "RV_DOMAIN"),
            new System.Data.OracleClient.OracleParameter(":RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_LOW_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_HIGH_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, "RV_HIGH_VALUE"),
            new System.Data.OracleClient.OracleParameter(":RV_ABBREVIATION", System.Data.OracleClient.OracleType.VarChar, 20, "RV_ABBREVIATION"),
            new System.Data.OracleClient.OracleParameter(":RV_MEANING", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MEANING"),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC01", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC01", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC02", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC02", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPNC03", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "RV_MPNC03", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC01", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC02", System.Data.OracleClient.OracleType.VarChar, 2000, "RV_MPCC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC03", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC03"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC01", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC01"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC02", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC02"),
            new System.Data.OracleClient.OracleParameter(":RV_MPDC03", System.Data.OracleClient.OracleType.DateTime, 0, "RV_MPDC03"),
            new System.Data.OracleClient.OracleParameter(":RV_CREATED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CREATED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CREATED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CREATED"),
            new System.Data.OracleClient.OracleParameter(":RV_CHANGED_BY", System.Data.OracleClient.OracleType.VarChar, 30, "RV_CHANGED_BY"),
            new System.Data.OracleClient.OracleParameter(":RV_DATE_CHANGED", System.Data.OracleClient.OracleType.DateTime, 0, "RV_DATE_CHANGED"),
            new System.Data.OracleClient.OracleParameter(":RV_TIMES_CHANGED", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "RV_TIMES_CHANGED", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_SEQUENCE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(5)), ((byte)(0)), "RV_SEQUENCE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":RV_DESCRIPTION", System.Data.OracleClient.OracleType.VarChar, 500, "RV_DESCRIPTION"),
            new System.Data.OracleClient.OracleParameter(":RV_MPCC00", System.Data.OracleClient.OracleType.VarChar, 100, "RV_MPCC00"),
            new System.Data.OracleClient.OracleParameter(":Original_RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_RV_LOW_VALUE", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_LOW_VALUE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleSelectCommand21
            // 
            this.oracleSelectCommand21.CommandText = "SELECT     RECIBO, TIPO_DOCUMENTO, DOCUMENTO, SERIE, NO_DOCUMENTO, FECHA_EMISION," +
                " USUARIO1, TOTAL, SALDO, SOCIO, VALOR\r\nFROM         TDA_V_NOTAS_CREDITO\r\nWHERE  " +
                "   (1 = 1)";
            this.oracleSelectCommand21.Connection = this.cnn;
            // 
            // adpNotasCredito
            // 
            this.adpNotasCredito.SelectCommand = this.oracleSelectCommand21;
            this.adpNotasCredito.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_NOTAS_CREDITO", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("RECIBO", "RECIBO"),
                        new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
                        new System.Data.Common.DataColumnMapping("USUARIO1", "USUARIO1"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("VALOR", "VALOR")})});
            // 
            // oracleSelectCommand22
            // 
            this.oracleSelectCommand22.CommandText = resources.GetString("oracleSelectCommand22.CommandText");
            this.oracleSelectCommand22.Connection = this.cnn;
            // 
            // adpnc
            // 
            this.adpnc.SelectCommand = this.oracleSelectCommand22;
            this.adpnc.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_PREIMPRESO_NC", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("CLIENTE", "CLIENTE"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("DIRECCION1", "DIRECCION1"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("CAJERO", "CAJERO"),
                        new System.Data.Common.DataColumnMapping("NOTA_CREDITO", "NOTA_CREDITO"),
                        new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
                        new System.Data.Common.DataColumnMapping("FACTURA", "FACTURA"),
                        new System.Data.Common.DataColumnMapping("ABONO", "ABONO"),
                        new System.Data.Common.DataColumnMapping("MOTIVO", "MOTIVO")})});
            // 
            // cnn1
            // 
            this.cnn1.ConnectionString = "Data Source=xe;Persist Security Info=True;User ID=logistika700;Password=logistika" +
                "700";
            // 
            // General
            // 
            this.Name = "General";
            this.ResumeLayout(false);

		}
		#endregion

		#endregion

		#region Constructor

		public General()
		{
			// This call is required by the Windows Form Designer.
			InitializeComponent();
			OnLoadQueries += new OnLoadQueriesEventHandler(LoadQueries);
			LoadQueries();
		}

		#endregion

		#region LoadQueries

		private void LoadQueries()
		{
			string strCmd = "";

			#region Ejecucion de Stored Procedures

			// cub_p_cubos.todos ( Materializar Cubos de Información )
			QueryMap.Add("cub_p_cubos.todos",@"BEGIN cub_p_cubos.todos; END; ");

			//  wms_p_ranking_clientes ( Calcular Ranking de Clientes )
			QueryMap.Add("wms_p_ranking_clientes",@"BEGIN wms_p_ranking_clientes; END; ");

			//  wms_p_ranking_skus ( Calcular Ranking de Productos )
			QueryMap.Add("wms_p_ranking_skus",@"BEGIN wms_p_ranking_skus; END; ");

			//  wms_p_rotacion_skus ( Calcular Rotacion de Productos )
			QueryMap.Add("wms_p_rotacion_skus",@"BEGIN wms_p_rotacion_skus; END; ");

			//  wms_p_replicacion_tablas.sincronizar_tablas ( Replicar Base de datos )
			QueryMap.Add("ReplicarBDD",@"BEGIN wms_p_replicacion_tablas.sincronizar_tablas; wms_p_replicacion_tablas_ru.sincronizar_tablas;END; ");

			//  wms_p_replicacion.sincronizar_documentos ( Replicar Documentos )
			QueryMap.Add("ReplicarDoctos",@"BEGIN wms_p_replicacion_docs.sincronizar_documentos; END; ");

			//  wms_p_estadisticas_skus ( Calcular Situacion del Inventario )
			QueryMap.Add("wms_p_estadisticas_skus",@"BEGIN wms_p_estadisticas_skus; END; ");

			//  wms_p_replicacion_tablas.leer_estadisticas_skus ( Leer Situacion del Inventario de Tiendas )
			QueryMap.Add("SituacionInventarioTiendas",@"BEGIN wms_p_replicacion_tablas_ru.leer_estadisticas_skus; END; ");

			//  doc_p_generar.compras([usuario]) ( Generar Compras Automaticas )
			QueryMap.Add("doc_p_generar.compras",@"BEGIN doc_p_generar.compras('&&USUARIO&&'); END; ");

			//  doc_p_generar.traslados_de_central([usuario]) ( Generar Traslados Automaticos )
			QueryMap.Add("GenerarTrasladosCentral",@"BEGIN doc_p_generar.traslados_de_central('&&USUARIO&&'); END; ");

			//  Traslados para Balancear Inventario ( doc_p_generar.traslados_entre_tiendas([usuario logeado])
			QueryMap.Add("TrasladosEntreTiendas",@"BEGIN doc_p_generar.traslados_entre_tiendas('&&USUARIO&&'); END; ");

			QueryMap.Add("ComprasConsignacion",@"BEGIN doc_p_generar.compras_consignacion('&&USUARIO&&'); END; ");

			//  cg_p_analyze_objects ( Calcular Estadisticas de Tablas e Indices )
			QueryMap.Add("cg_p_analyze_objects",@"BEGIN cg_p_analyze_objects; END; ");

			QueryMap.Add("ProcesarIngresos",@"Begin wms_p_documentos.procesar_ingresos; end;");

			QueryMap.Add("ProcesarEgresos",@"Begin wms_p_documentos.procesar_egresos; end;");

			QueryMap.Add("EstadisticasCentral",@"begin wms_p_estadisticas_central; end;");
			#endregion

			#region Secuencias

			//-- Secuencias internas
			//-- Nota: Usar juntas en una transaccion
			QueryMap.Add("internal_sequence", "SELECT cc_next_value FROM cg_code_controls WHERE cc_domain = upper(&&CODIGO&&) FOR UPDATE OF cc_next_value");
			QueryMap.Add("upd_internal_sequence", "UPDATE cg_code_controls SET cc_next_value = cc_next_value + nvl(cc_increment,1) WHERE cc_domain = upper(&&CODIGO&&)");

			// Devuelve el siguiente valor de una secuencia
			QueryMap.Add("SECUENCIA",@"
			   SELECT &&SECUENCIA&&.NEXTVAL FROM dual");

			#endregion

			#region Seguridad
  
			// Valida la seguridad al momento de login
			QueryMap.Add("seguridad","SELECT usuario FROM WMS_USUARIOS WHERE PASSWORD = '&&PASSWORD&&'");

            QueryMap.Add("fecha", "SELECT TRUNC(SYSDATE) FROM DUAL");

            QueryMap.Add("DatosUsuario", @"
                select a.socio,  b.nombres || ' ' || b.apellidos nombre
                from wms_socios a, wms_usuarios b
                where a.usuario = b.usuario
                and a.usuario = '&&USUARIO&&'");

            // Valida si un usuario tiene acceso a un módulo específico
			QueryMap.Add("USERINMODULE",@"
				SELECT CG_F_ACCESS('&&USUARIO&&','&&MODULO&&') FROM DUAL ");

            // Valida si un usuario tiene acceso a un módulo específico a traves del password
            QueryMap.Add("USERINMODULEBYPWD", @"
				SELECT CG_F_ACCESS((SELECT MIN(USUARIO) FROM WMS_USUARIOS WHERE PASSWORD = '&&PASSWORD&&'),'&&MODULO&&') FROM DUAL ");

			QueryMap.Add("MODULEEXISTS",@"
				SELECT COUNT(1) FROM CG_MODULES WHERE MODULE = '&&MODULO&&' ");

			QueryMap.Add("HELPDATA",@"
				SELECT HELP_FILENAME, HELP_KEYWORD FROM CG_MODULES WHERE MODULE = '&&MODULO&&' ");

			QueryMap.Add("GetMainModules",@"
				SELECT a.MODULE
				FROM   cg_modules a, cg_module_roles b, cg_user_roles c
				WHERE  a.owner = '&&SOLUTIONMODULE&&'
				AND    a.MODULE = b.MODULE
				AND    b.ROLE = c.ROLE
				AND    c.user_id = '&&USUARIO&&' ");

			QueryMap.Add("InsertModule",@"
				INSERT INTO cg_modules (module, owner, description)
				VALUES ('&&MODULO&&','&&PADRE&&','&&DESCRIPCION&&') ");

			QueryMap.Add("SavePageSize",@"
				UPDATE cg_modules
				SET    paging_size = &&PAGING_SIZE&&
				WHERE  module = '&&MODULE&&' ");
				
			QueryMap.Add("PagingSize",@"
				SELECT  paging_size
				FROM	cg_modules
				WHERE   module = '&&MODULE&&' ");

			//-- Obtiene los datos para los portales de clientes y proveedores
				strCmd = " SELECT C.SOCIO, C.SOCIO_ALTERNO, C.NOMBRE, U.NOMBRES, U.APELLIDOS ";
				strCmd += "  FROM WMS_USUARIOS U, WMS_SOCIOS C ";
				strCmd += " WHERE (U.SOCIO = C.SOCIO OR U.USUARIO = C.USUARIO) ";
				strCmd += Utils.QueryParams.PredefinedTags.AllToolbarsTag;
				QueryMap.Add("Seguridad.Socios", strCmd);

			//-- Obtiene los datos para el portal de tiendas
				strCmd = " SELECT B.BODEGA, C.NOMBRE, U.NOMBRES, U.APELLIDOS ";
				strCmd += "  FROM WMS_USUARIOS_X_BODEGA B, WMS_BODEGAS C, WMS_USUARIOS U ";
				strCmd += " WHERE B.BODEGA = C.BODEGA ";
				strCmd += "   AND B.USUARIO = U.USUARIO ";
				strCmd += Utils.QueryParams.PredefinedTags.AllToolbarsTag;
				QueryMap.Add("Seguridad.Tiendas", strCmd);

			//-- Seguridad standard
				strCmd = " SELECT U.CLASIFICACION_PORTAL, U.SOCIO, cg_f_access(U.USUARIO,&&MODULE&&) PRIVILEGIO ";
				strCmd += "  FROM WMS_USUARIOS U ";
				strCmd += " WHERE U.USUARIO = &&USUARIO&& ";
				strCmd += "	  AND U.PASSWORD = &&PASSWORD&& ";
				QueryMap.Add("Seguridad.Portal", strCmd);

				strCmd  = "SELECT SOCIO_ALTERNO, NOMBRE ";
				strCmd += "	 FROM WMS_SOCIOS ";
				strCmd += " WHERE SOCIO = &&SOCIO&& " ;
				QueryMap.Add("DescSocio",strCmd);

			#endregion

			#region Queries para tablas CG

			QueryMap.Add("GetParam",@"
				SELECT  value 
                FROM    cg_parameters 
                WHERE   parameter = '&&Param&&' ");

            QueryMap.Add("SetParam", @"
				UPDATE  cg_parameters 
                SET     value = '&&Value&&'
                WHERE   parameter = '&&Param&&' ");
            
            // Obtiene los filtros de un modulo para un usuario incluyendo los filtros públicos
			QueryMap.Add("Filters.CG_USER_FILTERS",@"
				SELECT f.FILTER_NAME, f.WHERE_CLAUSE, f.ORDERBY_CLAUSE, f.USER_ID, f.MODULE_NAME, f.PRIVATE_FILTER, f.LAST_USED, f.PIVOT_LAYOUT 
				FROM cg_user_filters f 
				WHERE (f.MODULE_NAME = '&&MODULE_NAME&&' AND f.USER_ID = '&&USER&&' AND f.PRIVATE_FILTER = 'X') OR 
				(f.MODULE_NAME = '&&MODULE_NAME&&' AND f.PRIVATE_FILTER IS NULL)
				ORDER BY f.filter_name ");

			strCmd = "SELECT MIN(FECHA) DEL, MAX(FECHA) AL	FROM CUD_DIAS ";
		    string W0 = "WHERE 1 = 1"; //Todos
			string W1 = "WHERE TRUNC(FECHA) = TRUNC(SYSDATE)"; //Hoy
			string W2 = "WHERE TRUNC(FECHA) = TRUNC(SYSDATE)-1"; //Ayer
			string W3 = "WHERE TO_CHAR(FECHA,'YYYYWW') = TO_CHAR(TRUNC(SYSDATE,'WW'),'YYYYWW')"; //Semana 
			string W4 = "WHERE TO_CHAR(FECHA,'YYYYWW') = TO_CHAR(TRUNC(SYSDATE,'WW')-1,'YYYYWW')"; //Semana Pasada
			string W5 = "WHERE TO_CHAR(FECHA,'YYYYMM') = TO_CHAR(TRUNC(SYSDATE,'MM'),'YYYYMM')"; //Mes
			string W6 = "WHERE TO_CHAR(FECHA,'YYYYMM') = TO_CHAR(TRUNC(SYSDATE,'MM')-1,'YYYYMM')"; //Mes Pasado
			string W7 = "WHERE TO_CHAR(FECHA,'YYYY') = TO_CHAR(TRUNC(SYSDATE,'YYYY'),'YYYY')"; //Año
			string W8 = "WHERE TO_CHAR(FECHA,'YYYY') = TO_CHAR(TRUNC(SYSDATE,'YYYY')-1,'YYYY')"; //Año Pasado

			// Filtros de fecha en base al filtro seleccionado
			QueryMap.Add("Filters.FechasW0",strCmd + W0);
			QueryMap.Add("Filters.FechasW1",strCmd + W1);
			QueryMap.Add("Filters.FechasW2",strCmd + W2);
			QueryMap.Add("Filters.FechasW3",strCmd + W3);
			QueryMap.Add("Filters.FechasW4",strCmd + W4);
			QueryMap.Add("Filters.FechasW5",strCmd + W5);
			QueryMap.Add("Filters.FechasW6",strCmd + W6);
			QueryMap.Add("Filters.FechasW7",strCmd + W7);
			QueryMap.Add("Filters.FechasW8",strCmd + W8);

            QueryMap.Add("DsGeneral.CG_REF_CODES", @"
				SELECT RV_DOMAIN, RV_LOW_VALUE, RV_HIGH_VALUE, RV_ABBREVIATION, RV_MEANING, RV_MPNC01, RV_MPNC02, RV_MPNC03, RV_MPCC01, RV_MPCC02, RV_MPCC03, RV_MPDC01, RV_MPDC02, RV_MPDC03, RV_CREATED_BY, RV_DATE_CREATED, RV_CHANGED_BY, RV_DATE_CHANGED, RV_TIMES_CHANGED, RV_SEQUENCE, RV_DESCRIPTION 
				FROM CG_REF_CODES
				WHERE RV_DOMAIN = '&&RV_DOMAIN&&'");

			QueryMap.Add("CgRefCodes.ALLDOMAINS",@"
				SELECT RV_DOMAIN, RV_LOW_VALUE, RV_HIGH_VALUE, RV_ABBREVIATION, RV_MEANING, RV_MPNC01, RV_MPNC02, RV_MPNC03, RV_MPCC01, RV_MPCC02, RV_MPCC03, RV_MPDC01, RV_MPDC02, RV_MPDC03, RV_CREATED_BY, RV_DATE_CREATED, RV_CHANGED_BY, RV_DATE_CHANGED, RV_TIMES_CHANGED, RV_SEQUENCE, RV_DESCRIPTION, RV_MPCC00 
				FROM CG_REF_CODES
				WHERE 1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag + @"
				ORDER BY RV_DOMAIN ");

            QueryMap.Add("CgRefCodes.DOMAINS", @"
				SELECT RV_DOMAIN, RV_LOW_VALUE, RV_HIGH_VALUE, RV_ABBREVIATION, RV_MEANING, RV_MPNC01, RV_MPNC02, RV_MPNC03, RV_MPCC01, RV_MPCC02, RV_MPCC03, RV_MPDC01, RV_MPDC02, RV_MPDC03, RV_CREATED_BY, RV_DATE_CREATED, RV_CHANGED_BY, RV_DATE_CHANGED, RV_TIMES_CHANGED, RV_SEQUENCE, RV_DESCRIPTION, RV_MPCC00 
				FROM CG_REF_CODES
				WHERE RV_DOMAIN = '&&RV_DOMAIN&&'
                ORDER BY RV_MEANING "
            );

            QueryMap.Add("DomainSortedByLowValue", @"
				SELECT RV_DOMAIN, RV_LOW_VALUE, RV_HIGH_VALUE, RV_ABBREVIATION, RV_MEANING, RV_MPNC01, RV_MPNC02, RV_MPNC03, RV_MPCC01, RV_MPCC02, RV_MPCC03, RV_MPDC01, RV_MPDC02, RV_MPDC03, RV_CREATED_BY, RV_DATE_CREATED, RV_CHANGED_BY, RV_DATE_CHANGED, RV_TIMES_CHANGED, RV_SEQUENCE, RV_DESCRIPTION, RV_MPCC00 
				FROM CG_REF_CODES
				WHERE RV_DOMAIN = '&&RV_DOMAIN&&'
                ORDER BY RV_LOW_VALUE "
            );

            QueryMap.Add("CG_REF_CODES.RV_MPNC01", @"
				SELECT RV_MPNC01
				FROM   CG_REF_CODES
				WHERE  rv_domain = '&&RV_DOMAIN&&'
				AND    rv_low_value = &&RV_LOW_VALUE&&");

			QueryMap.Add("Significado","select cg_f_code_meaning('&&DOMAIN&&', '&&VALUE&&') from dual");


			#endregion

			#region Relacionados con Clasificaciones

			// Obtiene arbol de clasificaciones
			QueryMap.Add("Clasificaciones.WMS_Clasificaciones",@"
				SELECT clasificacion, padre, descripcion 
				FROM wms_clasificaciones
				START WITH PADRE IS NULL
				CONNECT BY PRIOR clasificacion = padre ");
			

			QueryMap.Add("ClasificacionSkus.WMS_CLASIFICACIONES",@"
				SELECT c.CLASIFICACION, lpad(' ',(LEVEL*5) - 5) || c.DESCRIPCION AS DESCRIPCION  FROM wms_clasificaciones c
				CONNECT BY PRIOR c.CLASIFICACION = c.PADRE
				START WITH c.PADRE IS NULL AND c.SKUS = 'S'");

			QueryMap.Add("Clasificaciones.Regiones","SELECT Clasificacion, Padre , Descripcion AS Display, wms_f_ancestros_clasificacion(Clasificacion) region FROM wms_clasificaciones where 1=1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag +
				" CONNECT BY PRIOR CLASIFICACION = PADRE START WITH CLASIFICACION = CG_F_PARAMETER_VALUE('CRG') ");

		
			QueryMap.Add("Clasificaciones.TiendasReabasto",@" SELECT  clasificacion, padre, descripcion
															FROM    wms_clasificaciones
															where 1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag +
				@"START   WITH padre IS NULL AND nvl(bodegas,'N') = 'S'
															CONNECT BY PRIOR clasificacion = padre ");

			QueryMap.Add("ClasificacionesPadreProductos",@"
				SELECT clasificacion, padre, descripcion
				FROM   wms_clasificaciones
				WHERE  padre IS NULL
				AND    skus = 'S' " + Utils.QueryParams.PredefinedTags.AllToolbarsTag);

			#endregion

			#region Relacionados con Bodegas

			// Devuelve la primer licencia de la Bodega que Representa Este Esquema (BREE)
			QueryMap.Add("LicenciaBREE",@"
			    SELECT MIN(NVL(A.UNIDAD_MOVIL,0))
			    FROM   WMS_UNIDADES_MOVILES A, WMS_UBICACIONES B, WMS_BODEGAS C
				WHERE  A.UBICACION = B.UBICACION
				AND    B.BODEGA = C.BODEGA
				AND    C.BODEGA IN (
					   SELECT D.BODEGA
					   FROM   WMS_BODEGAS D
                       CONNECT BY PRIOR D.BODEGA = D.BODEGA_PADRE
					   START WITH D.BODEGA = TO_NUMBER(CG_F_PARAMETER_VALUE('BREE')) )");

			// Devuelve la primer zona de la Bodega que Representa Este Esquema (BREE)
			QueryMap.Add("ZonaBREE",@"
				SELECT  MIN(NVL(D.BODEGA,0)) 
				FROM    WMS_BODEGAS D
				WHERE   BODEGA_PADRE IS NOT NULL
				CONNECT BY PRIOR D.BODEGA = D.BODEGA_PADRE
				START   WITH D.BODEGA = TO_NUMBER(CG_F_PARAMETER_VALUE('BREE'))");

			// Devuelve la Bodega que Representa Este Esquema (BREE)
			QueryMap.Add("BodegaBREE",@"
				SELECT  TO_NUMBER(CG_F_PARAMETER_VALUE('BREE')) FROM DUAL ");

			// Devuelve la Bodega de Actualización Automática (BDAA)
			QueryMap.Add("BodegaBDAA",@"
				SELECT  TO_NUMBER(CG_F_PARAMETER_VALUE('BDAA')) FROM DUAL ");

			QueryMap.Add("ZonasWMS",@"SELECT B.BODEGA, A.NOMBRE || '->' || B.NOMBRE AS NOMBRE FROM WMS_BODEGAS A, WMS_BODEGAS B WHERE A.BODEGA = B.BODEGA_PADRE 
						and Wms_F_Ubicaciones_Zona(b.bodega) >0 ");

			#endregion

			#region Queries de Monedas

			QueryMap.Add("SimboloMoneda","select wms_f_simbolo_moneda(&&MONEDA&&) from dual");
			QueryMap.Add("SimboloMonedaBase","select wms_f_simbolo_moneda(wms_f_moneda_base) from dual");
			QueryMap.Add("SimboloMonedaAlterna","select wms_f_simbolo_moneda(wms_f_moneda_alterna) from dual");

			QueryMap.Add("MonedaBase","select wms_f_moneda_base from dual");
			QueryMap.Add("MonedaAlterna","select wms_f_moneda_alterna from dual");

			#endregion

			#region Relacionados con Clientes

			QueryMap.Add("dsClientes.CUF_V_CXC","select * from cuf_v_cxc where socio in (SELECT SOCIO FROM RET_V_CLIENTES WHERE (1 = 1) " + Utils.QueryParams.PredefinedTags.ToolbarTag + ")" );
		
			QueryMap.Add("dsClientes.RET_V_EC",@" select * from RET_V_EC where 1=1 " + Utils.QueryParams.PredefinedTags.DetailRelationTag );

			QueryMap.Add("dsClientes.Variables",@"
				SELECT * 
				FROM (
					SELECT RV_LOW_VALUE VARIABLE_ID, RV_MEANING VARIABLE, rv_mpcc02 DOCUMENTOS 
					FROM   cg_ref_codes 
					WHERE  rv_domain = 'VARIABLE' 
					AND    (rv_mpcc02 is null or rv_mpcc02 LIKE '%&&DOCUMENTOS&&%') ) 
				WHERE 1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag );

			
            QueryMap.Add("LOVSkus.SkusxSocio",@"SELECT * FROM (
				SELECT A.SKU, A.SKU_ALTERNO, A.DESCRIPCION, A.CODIGO_BARRAS, 
                       DECODE(B.SOCIO, NULL, '', 'X') AS ASOCIADO, NVL(B.PRECIO_NEGOCIADO,0) PRECIO_NEGOCIADO					   
                  FROM WMS_SKUS A, WMS_SKUS_ALTERNOS B 
                 WHERE A.SKU = B.SKU (+)
                   AND NVL(A.LLEVA_INVENTARIO, 'S') = 'S' 
                   AND B.SOCIO (+) = &&PROVEEDOR&& )
                WHERE 1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag 
				+ " ORDER BY ASOCIADO, SKU_ALTERNO");

			#endregion

			#region Relacionados con Proveedores

			QueryMap.Add("dsProveedores.RET_V_ECP",@" select * from RET_V_ECP where 1=1 " + Utils.QueryParams.PredefinedTags.DetailRelationTag );

			#endregion

			#region Calculo de Precios
		
			// Precio SKUS LPP Listado de precios de pedidos 1:Canal 2:Menus 3:Precio Base
			// 3: Precio Base
			QueryMap.Add("LOVPrecioSkus.WMS_SKUS",@"
			SELECT SKU, SKU_ALTERNO, DESCRIPCION, CODIGO_BARRAS, 
               Wms_F_Simbolo_Moneda(NVL(MONEDA_PRECIO_BASE, Wms_F_Moneda_Base)) AS SIMBOLO_MONEDA, 
               ROUND(NVL(PRECIO_BASE, 0), 2) AS PRECIO_BASE, 
               wms_f_precio_moneda_base(PRECIO_BASE, MONEDA_PRECIO_BASE) AS PRECIO_MB 
			FROM   WMS_SKUS 
			WHERE  (1 = 1) 
			AND    (NVL(LLEVA_INVENTARIO, 'S') = 'S') " + Utils.QueryParams.PredefinedTags.AllToolbarsTag);
			
			// 1: Canal
			// 2: Menus
			QueryMap.Add("PrecioSkusXClasificacion",@"
				SELECT a.sku, a.sku_alterno, a.descripcion, a.codigo_barras,
							wms_f_simbolo_moneda (NVL (NVL (b.moneda_precio,a.moneda_precio_base), wms_f_moneda_base)) AS simbolo_moneda,
							ROUND (NVL (B.precio, 0), 2) AS precio_base,
							wms_f_precio_moneda_base (b.precio,a.moneda_precio_base) AS precio_mb
				FROM   WMS_SKUS a, WMS_SKUS_X_CLASIFICACION b
				WHERE  (1 = 1)
				AND    (NVL (a.lleva_inventario, 'S') = 'S')
				AND    a.sku = b.sku
				AND    b.clasificacion = &&CLASIFICACION&& " + Utils.QueryParams.PredefinedTags.AllToolbarsTag );
			
			// Canal de ventas en base a FV Usuario y Cliente
			QueryMap.Add("CanalVenta",@"
				SELECT NVL(MIN(b.clasificacion), 0)
				FROM   WMS_USUARIOS a, WMS_SOCIOS_X_CLASIFICACION b
				WHERE  a.usuario = '&&USUARIO&&'
				AND    a.fuerza_ventas = b.catalogo
				AND    b.socio = &&SOCIO&&");
			
			// Precio Unitario
			QueryMap.Add("PrecioUnitario",@"
				SELECT ROUND(DECODE(NVL(cg_f_parameter_value('IMP'),1),
											0,&&PRECIO_UNITARIO&& * (1 + NVL(cg_f_parameter_value('PIVA'),12)/100), 
											1,&&PRECIO_UNITARIO&& / (1 + NVL(cg_f_parameter_value('PIVA'),12)/100)),2) precio
				FROM   dual");
			
			// Impuesto
			QueryMap.Add("Impuesto",@"
				SELECT ROUND(DECODE(NVL(cg_f_parameter_value('IMP'),1),
											0,&&PRECIO_UNITARIO&& * (NVL(cg_f_parameter_value('PIVA'),12)/100), 
											1,&&PRECIO_UNITARIO&& - (&&PRECIO_UNITARIO&& / (1 + NVL(cg_f_parameter_value('PIVA'),12)/100))),2) impuesto
				FROM   dual");

			#endregion

			#region Relacionados con 3PL

			QueryMap.Add("3PLEstadisticas_Socio","BEGIN WMS_P_3PLESTADISTICAS ('&&Fechai&&' , '&&Fechaf&&', &&Cliente&&) ; END;");

			QueryMap.Add("Borra_3PLEstadisticas_Socio","DELETE FROM MDA_3PLESTADISTICAS_INVENTARIO");

			QueryMap.Add("Ds3PLEstadisticas.MDA_3PLESTADISTICAS_INVENTARIO","SELECT * FROM MDA_3PLESTADISTICAS_INVENTARIO "+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);

			#endregion


			//-- Descripcion del rango de fechas enviado
			//-- Ejemplo:	TIPO = P    FECHA_INICIAL = TO_DATE('01/01/2005', 'dd/mm/yyyy')	  FECHA_FINAL = TO_DATE('31/12/2005', 'dd/mm/yyyy')
			//-- Devuelve:  Fechas del 01/Ene/2005 al 31/Dic/2005
			QueryMap.Add("DescRangoFechas","SELECT Wms_F_Rango_Fechas_Desc('&&TIPO&&', &&FECHA_INICIAL&&, &&FECHA_FINAL&&) FROM DUAL");

			QueryMap.Add("TasaCambio","SELECT ROUND(NVL(wms_f_equivalencia('M', &&MONEDA&&, wms_f_moneda_base, 1), 1), 6) FROM DUAL");

			// Actualizando total del documento
			QueryMap.Add("ActualizarTotal",@"
			UPDATE WMS_DOCUMENTOS
			SET    total = Wms_F_Total_Documento(&&DOCUMENTO&&)
			WHERE  documento = &&DOCUMENTO&&");

			QueryMap.Add("Regimen3PL","select RV_MPNC01 from cg_ref_codes where rv_domain = 'REGIMEN 3PL' AND RV_LOW_VALUE = CG_F_PARAMETER_VALUE('R3PL')");

			QueryMap.Add("DsInventariosBodega.WMS_INVENTARIOS",@"
			SELECT *
			FROM   WMS_INVENTARIOS
			WHERE  UNIDAD_MOVIL IN (
				SELECT UNIDAD_MOVIL
				FROM   WMS_UBICACIONES
				WHERE  UBICACION IN (
	   					SELECT UBICACION
						FROM   WMS_BODEGAS
						WHERE BODEGA = &&BODEGA&&)) ");
			
			QueryMap.Add("dsGeneralRep.DatosGenerales",@"
				SELECT '&&USUARIO&&',TO_DATE('&&FECHA&&','DD/MM/YYYY') FROM DUAL ");

			QueryMap.Add("Filters.Clasificaciones",@"
				SELECT no_clasificacion, clasificacion, descripcion
				FROM   ret_v_clas_cubos_sku
				WHERE  1 = 1 ");

			QueryMap.Add("CgRefCodes.CG_REF_CODES",@"
				SELECT rv_domain, rv_low_value, rv_high_value, rv_abbreviation, rv_meaning,
					rv_mpnc01, rv_mpnc02, rv_mpnc03, rv_mpcc01, rv_mpcc02, rv_mpcc03,
					rv_mpdc01, rv_mpdc02, rv_mpdc03, rv_created_by, rv_date_created,
					rv_changed_by, rv_date_changed, rv_times_changed, rv_sequence,
					rv_description, rv_mpcc00
				FROM cg_ref_codes
				WHERE rv_domain IN (
					SELECT DOMAIN
					FROM   CG_DOMAINS
					WHERE  1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag + @"
				)
			");

			QueryMap.Add("CgRefCodes.CG_DOMAIN_COLUMNS",@"
				SELECT DOMAIN, COLUMNNAME, COLUMNCAPTION, VISIBLE
				FROM   CG_DOMAIN_COLUMNS
				WHERE  DOMAIN IN (
					SELECT DOMAIN
					FROM   CG_DOMAINS
					WHERE  1 = 1 " + Utils.QueryParams.PredefinedTags.AllToolbarsTag + @"
				)			
			");  
        }

		#endregion

	}
}
