Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1st)(?) conseguir el mop codigo
- select * from o800_mtra_origen_pred --.mop_codigo
- where mop_descripcion in ('SAN LUIS','CORDOBA','SANTA FE','ENTRE RIOS','SANTIAGO DEL ESTERO','CORRIENTES','MISIONES');
- --2nd) buscar los cpd
- SELECT ltrim(rtrim(translate(Cpd_Codigo,'*',' '))) cpd_cod
- FROM O800_CLI_PREDEF_DETALLE
- WHERE Mop_Codigo in
- (
- 'CD',
- 'CR',
- 'ER',
- 'MS',
- 'SE',
- 'SF',
- 'SL',
- 'CD-V01' ) ;
- --3rd) validar los cpd dentro del servicio
- SELECT * --ltrim(rtrim(translate(cd.cd_descripcion,'*',' '))) cd_des
- FROM O800_CLI_DETALLE cd
- ,O800_ENRT_ORIGEN eo
- WHERE cd.eo_id = eo.eo_id
- AND eo.srv_codigo = 29866
- and cd.cd_descripcion
- -- and cd.cd_id
- in ( SELECT ltrim(rtrim(translate(Cpd_Codigo,'*',' '))) cpd_cod
- FROM O800_CLI_PREDEF_DETALLE
- WHERE Mop_Codigo in
- (
- 'CD',
- 'CR',
- 'ER',
- 'MS',
- 'SE',
- 'SF',
- 'SL',
- 'CD-V01' )
- );
- 4th) hacer update de los cosos estos.
- SELECT * FROM
- -- update
- o800_cli_detalle
- -- set cd_descripcion='99999999', usuario_ult_mod='APPLTAZA'
- WHERE cd_descripcion IN
- ('2336',
- '3385',
- '3387',
- '3463',
- '3467',
- '3468',
- '3472',
- '351',
- '3521',
- '3522',
- '3524',
- '3525',
- '3541',
- '3542',
- '3543',
- '3544',
- '3546',
- '3547',
- '3548',
- '3549',
- '358',
- '385',
- '3382',
- '341',
- '342',
- '3460',
- '3462',
- '3464',
- '3465',
- '3466',
- '3469',
- '3471',
- '3476',
- '3482',
- '3483',
- '3491',
- '3493',
- '3496',
- '3497',
- '3498',
- '3492',
- '343',
- '345',
- '2336',
- '3385',
- '3387',
- '3463',
- '3467',
- '3468',
- '3472',
- '351',
- '3521',
- '3522',
- '3524',
- '3525',
- '3541',
- '3542',
- '3543',
- '3544',
- '3546',
- '3547',
- '3548',
- '3549',
- '358',
- '385',
- '3382',
- '341',
- '342',
- '3460',
- '3462',
- '3464',
- '3465',
- '3466',
- '3469',
- '3471',
- '3476',
- '3482',
- '3483',
- '3491',
- '3493',
- '3496',
- '3497',
- '3498',
- '3492',
- '343',
- '345',
- '2336',
- '2652',
- '2336',
- '2652',
- '2336',
- '2652'
- )
- AND sol_nro_solic IN (347180, 396773, 984629, 1017189, 1017162)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement