Prueba
Páginas: 2 (347 palabras)
Publicado: 13 de marzo de 2013
Canton 113
select param.codigo as codigo, param.descripcion as descripcion from Parametro param where upper(param.codigo) like upper(coalesce(cast(:codigo as string), cast(param.codigo asstring), cast(:codigo as string))) and UPPER(param.descripcion) like UPPER(coalesce(cast(:descripcion as string), cast(param.descripcion as string), cast(:descripcion as string))) andparam.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9014' and upper(Vll_Inicial) = upper(coalesce(${atrib109}, substring(param.codigo, 0, 1)))
select param.codigo as codigo,param.descripcion as descripcion from Parametro param where ((upper(param.codigo) like upper(coalesce(cast(:codigoRelacionado as string), cast(param.codigo as string), cast(:codigoRelacionado asstring)))) and (upper(param.codigo) like upper(coalesce(cast(:codigo as string), cast(param.codigo as string), cast(:codigo as string))))) and UPPER like UPPER, cast(param.descripcion as string),cast(:descripcion as string))) and param.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9014' and upper(substring(param.codigo, 0, 3)) = upper(coalesce(${atrib109},substring(param.codigo, 0, 3)))
Distrito 113
select param.codigo as codigo, param.descripcion as descripcion from Parametro param where upper(param.codigo) like upper(coalesce(cast(:codigo asstring), cast(param.codigo as string), cast(:codigo as string))) and UPPER(param.descripcion) like UPPER(coalesce(cast(:descripcion as string), cast(param.descripcion as string), cast(:descripcion asstring))) and param.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9015' and upper(Vll_Inicial) = upper(coalesce(${atrib110}, substring(param.codigo, 0, 3)))select param.codigo as codigo, param.descripcion as descripcion from Parametro param where ((upper(param.codigo) like upper(coalesce(cast(:codigoRelacionado as string), cast(param.codigo as string),...
select param.codigo as codigo, param.descripcion as descripcion from Parametro param where upper(param.codigo) like upper(coalesce(cast(:codigo as string), cast(param.codigo asstring), cast(:codigo as string))) and UPPER(param.descripcion) like UPPER(coalesce(cast(:descripcion as string), cast(param.descripcion as string), cast(:descripcion as string))) andparam.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9014' and upper(Vll_Inicial) = upper(coalesce(${atrib109}, substring(param.codigo, 0, 1)))
select param.codigo as codigo,param.descripcion as descripcion from Parametro param where ((upper(param.codigo) like upper(coalesce(cast(:codigoRelacionado as string), cast(param.codigo as string), cast(:codigoRelacionado asstring)))) and (upper(param.codigo) like upper(coalesce(cast(:codigo as string), cast(param.codigo as string), cast(:codigo as string))))) and UPPER like UPPER, cast(param.descripcion as string),cast(:descripcion as string))) and param.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9014' and upper(substring(param.codigo, 0, 3)) = upper(coalesce(${atrib109},substring(param.codigo, 0, 3)))
Distrito 113
select param.codigo as codigo, param.descripcion as descripcion from Parametro param where upper(param.codigo) like upper(coalesce(cast(:codigo asstring), cast(param.codigo as string), cast(:codigo as string))) and UPPER(param.descripcion) like UPPER(coalesce(cast(:descripcion as string), cast(param.descripcion as string), cast(:descripcion asstring))) and param.empresa.id=${empresaActual.id} and param.estado = true and param.codigoGrupo = 'ADM9015' and upper(Vll_Inicial) = upper(coalesce(${atrib110}, substring(param.codigo, 0, 3)))select param.codigo as codigo, param.descripcion as descripcion from Parametro param where ((upper(param.codigo) like upper(coalesce(cast(:codigoRelacionado as string), cast(param.codigo as string),...
Leer documento completo
Regístrate para leer el documento completo.