EMPIEZA EL PROCESO DE ADMISION
formulas
substancias
***********UPDATE ctg_substancias SET
ctg_sus_desc = 'AMPICILINA SODICA',
ctg_sus_sta = '2',
ctg_sus_usr = '24123488',
ctg_sus_dt = now()
WHERE
ctg_tpr_id = '02' AND
ctg_sus_id = '5972'
[]
[Datos han sido GUARDADOS correctamente]
***********UPDATE ctg_substancias SET
ctg_sus_desc = 'SULBACTAM SODICA',
ctg_sus_sta = '2',
ctg_sus_usr = '24123488',
ctg_sus_dt = now()
WHERE
ctg_tpr_id = '02' AND
ctg_sus_id = '8942'
[]
[Datos han sido GUARDADOS correctamente]
SELECT * FROM "vus_tramites_ef1_MUESTRAS" WHERE "vus_efMUE_numsol" = '202500868' AND "vus_efMUE_tpt_id" = 'SREF-0005' AND "vus_efMUE_tpr_id" = '02' AND "vus_efMUE_tipo" = 1
INSERT INTO ctg_muestras_inven (
ctg_numsol_id,
ctg_tpr_id,
ctg_tpt_id,
ctg_arm_id,
ctg_ari_crea,
ctg_ari_desc,
ctg_ari_cant_ent,
ctg_ari_cant_sal,
ctg_ari_cant_saldo,
ctg_ari_sta,
ctg_ari_usr,
ctg_ari_dt
) VALUES (
'202500868',
'02',
'SREF-0005',
'01',
now(),
'Caja contentiva de 10 frascos ampolla de vidrio incoloro, transparente, con sello de aluminio color plateado y tapa flip-off de color verde.',
'1',
'0',
'1',
'1',
'24123488',
now());linea 200
[]
[Datos han sido GUARDADOS correctamente]
SELECT * FROM ctg_muestras_transac WHERE
ctg_numsol_id = '202500868' AND
ctg_tpr_id = '02' AND
ctg_tpt_id = 'SREF-0005' AND
ctg_arm_id = '01' AND
ctg_esa_id = '010602'
INSERT INTO ctg_muestras_transac (
ctg_numsol_id,
ctg_tpr_id,
ctg_tpt_id,
ctg_arm_id,
ctg_esa_id,
ctg_art_id,
ctg_art_opeusr,
ctg_art_opedt,
ctg_art_tpoope,
ctg_art_motivo,
ctg_art_cant_ent,
ctg_art_cant_sal,
ctg_art_sta,
ctg_art_usr,
ctg_art_dt
) VALUES (
'202500868',
'02',
'SREF-0005',
'01',
'010602',
'1',
'24123488',
now(),
'1',
'Quantity of sample received',
'1',
'0',
'1',
'24123488',
now());
[]
[Datos han sido GUARDADOS correctamente]
productos
SQL ADMITIR (SELECT vus_ef_tpc_id, vus_ef_numadmi, vus_ef_dispen
FROM vus_tramites_ef1
WHERE vus_ef_numsol = '202500868'
contol
***********INSERT INTO adm_control_ef (
adm_con_numsol,
adm_con_tpt_id,
adm_con_tpr_id,
adm_con_esa_id,
adm_con_staens,
adm_con_asignado,
adm_con_dura,
adm_con_final,
adm_con_final_espe,
adm_con_estatus,
adm_con_obs,
adm_con_sta,
adm_con_usr,
adm_con_dt,
adm_con_etapa,
adm_con_nomprod,
adm_con_numadmi,
adm_con_usr_id,
adm_con_jun,
adm_con_com,
adm_con_tpt_action,
adm_con_dispen
) VALUES (
'202500868',
'SREF-0005',
'02',
'0102',
'1',
now(),
'0',
'1900-01-01 00:00:00',
'1900-01-01',
'0',
'',
'1',
'24123488',
now(),
'',
'AMPICILINA – SULBACTAM 1 g – 0,5 g POLVO PARA SOLUCIÓN INYECTABLE',
'SREF-202500547',
'529',
'0',
'0',
'1',
'01'
);
error
[]
[Datos han sido GUARDADOS correctamente]
******* COPIAR INGREDIENTES ******
SELECT "vus_efFOR_sus_nom", "vus_efFOR_sus_id" FROM vus_tramites_ef1_formula WHERE
"vus_efFOR_numsol"='202500868' AND "vus_efFOR_tpt_id"='SREF-0005' AND "vus_efFOR_tpr_id"='02'
******* COPIAR EMPRESAS ******
SELECT * FROM vus_usuarios WHERE vus_usr_id = '24123488'
empresas SELECT * FROM "vus_tramites_ef1_EMPRESAS" WHERE "vus_efEMP_numsol"='202500868'
AND "vus_efEMP_tpt_id"='SREF-0005' AND "vus_efEMP_tpr_id"='02'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='NO APLICA'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='NO APLICA', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='-', ctg_emp_dir_c='',
ctg_emp_tels='NO APLICA',
ctg_emp_fax='NO APLICA',
ctg_emp_email1='NO APLICA',
ctg_emp_email2='NO APLICA',
ctg_emp_pweb='NOAPLICA',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_enva=1, ctg_emp_impo=1, ctg_emp_dist=1, ctg_emp_repr=1, ctg_emp_acon=1, ctg_emp_alma=1, ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='NO APLICA'
UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='NO APLICA', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='-', ctg_emp_dir_c='',
ctg_emp_tels='NO APLICA',
ctg_emp_fax='NO APLICA',
ctg_emp_email1='NO APLICA',
ctg_emp_email2='NO APLICA',
ctg_emp_pweb='NOAPLICA',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_enva=1, ctg_emp_impo=1, ctg_emp_dist=1, ctg_emp_repr=1, ctg_emp_acon=1, ctg_emp_alma=1, ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='NO APLICA'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='J-00000000'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABADI'
AND "vus_efEMP_nombre"='NO APLICA'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='J-00000000'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABADI'
AND "vus_efEMP_nombre"='NO APLICA'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='NO APLICA'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='NO APLICA', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='-', ctg_emp_dir_c='',
ctg_emp_tels='NO APLICA',
ctg_emp_fax='NO APLICA',
ctg_emp_email1='NO APLICA',
ctg_emp_email2='NO APLICA',
ctg_emp_pweb='NOAPLICA',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_enva=1, ctg_emp_impo=1, ctg_emp_dist=1, ctg_emp_repr=1, ctg_emp_acon=1, ctg_emp_alma=1, ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='NO APLICA'
UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='NO APLICA', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='-', ctg_emp_dir_c='',
ctg_emp_tels='NO APLICA',
ctg_emp_fax='NO APLICA',
ctg_emp_email1='NO APLICA',
ctg_emp_email2='NO APLICA',
ctg_emp_pweb='NOAPLICA',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_enva=1, ctg_emp_impo=1, ctg_emp_dist=1, ctg_emp_repr=1, ctg_emp_acon=1, ctg_emp_alma=1, ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='NO APLICA'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='J-00000000'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABENVADI'
AND "vus_efEMP_nombre"='NO APLICA'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='J-00000000'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABENVADI'
AND "vus_efEMP_nombre"='NO APLICA'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_rif='J-409187179'
UPDATE ctg_empresas SET
ctg_emp_tpoper='0', ctg_emp_origen='1',
ctg_emp_nombre='VECTE LOGISTIC, C.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='V151717', ctg_emp_urb='ZONA INDUSTRIAL DEL ESTE',
ctg_emp_ave='SEGUNDA AVENIDA ENTRE CALLES C Y D', ctg_emp_edi='DROGUERIA NENA',
ctg_emp_piso='PB', ctg_emp_codpos='1220',
ctg_emp_punref='A MEDIA CUADRA DE LABORATORIOS LETI', ctg_emp_ciudad='0',
ctg_emp_dir='', ctg_emp_dir_c='',
ctg_emp_tels='0212-219-4245', ctg_emp_fax='',
ctg_emp_email1='servicios@vectelogistics.com', ctg_emp_email2='mroca.ve@vectelogistics.com',
ctg_emp_pweb='www.vectelogistic.com',
ctg_emp_fabr='0', ctg_emp_dist='1', ctg_emp_alma='1', ctg_emp_farm_id='21413581',
ctg_emp_sta='1', ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_rif='J-409187179'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='21413581'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='1', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='Maria', ctg_farm_nme2='Fernanda',
ctg_farm_ape1='Roca', ctg_farm_ape2='',
ctg_farm_nombre='Maria Fernanda Roca ', ctg_farm_telpar='0212-219-4235',
ctg_farm_telcel='0414-204-4069', ctg_farm_email1='mroca.ve@vectelogistics.com',
ctg_farm_email2='admonvectelogistic@gmail.com', ctg_geo_id='V151717',
ctg_farm_urb='Zona Industrial del Este Guarenas', ctg_farm_ave='Segunda Avenida entre calles C y D',
ctg_farm_edi='Droguería Nena', ctg_farm_piso='PB',
ctg_farm_codpos='1220', ctg_farm_punref='a media cuadra de Laboratorios Leti',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='21413581'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_rif='J-506306972'
UPDATE ctg_empresas SET
ctg_emp_tpoper='0', ctg_emp_origen='1',
ctg_emp_nombre='FARMADOSIS CASA DE REPRESENTACION, C.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='V15', ctg_emp_urb='URB LA CARLOTA',
ctg_emp_ave='AVENIDA LA CARLOTA', ctg_emp_edi='QUINTA FERAL',
ctg_emp_piso='NRO.2', ctg_emp_codpos='1071',
ctg_emp_punref='CARACAS', ctg_emp_ciudad='0',
ctg_emp_dir='', ctg_emp_dir_c='',
ctg_emp_tels='0000-000-0000', ctg_emp_fax='',
ctg_emp_email1='-', ctg_emp_email2='-',
ctg_emp_pweb='-',
ctg_emp_fabr='0', ctg_emp_tit='1', ctg_emp_impo='1', ctg_emp_dist='1', ctg_emp_repr='1', ctg_emp_alma='1', ctg_emp_farm_id='23950540',
ctg_emp_sta='1', ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_rif='J-506306972'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='23950540'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='REBECA', ctg_farm_nme2='LANDAETA',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre='REBECA LANDAETA ', ctg_farm_telpar='0412-010-4687',
ctg_farm_telcel='0412-010-4687', ctg_farm_email1='farmadosiscasaderepresentacion@gmail.com',
ctg_farm_email2='', ctg_geo_id='V1503',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='1080', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='23950540'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_rif='J-506306972'
UPDATE ctg_empresas SET
ctg_emp_tpoper='1', ctg_emp_origen='1',
ctg_emp_nombre='FARMADOSIS CASA DE REPRESENTACION, C.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='V15', ctg_emp_urb='URB LA CARLOTA',
ctg_emp_ave='AVENIDA LA CARLOTA', ctg_emp_edi='QUINTA FERAL',
ctg_emp_piso='NRO.2', ctg_emp_codpos='1071',
ctg_emp_punref='CARACAS', ctg_emp_ciudad='',
ctg_emp_dir='', ctg_emp_dir_c='',
ctg_emp_tels='0000-000-0000', ctg_emp_fax='',
ctg_emp_email1='-', ctg_emp_email2='-',
ctg_emp_pweb='-',
ctg_emp_fabr='0', ctg_emp_tit='1', ctg_emp_farm_id='23950540',
ctg_emp_sta='1', ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_rif='J-506306972'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='23950540'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='REBECA', ctg_farm_nme2='LANDAETA',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre='REBECA LANDAETA ARCAS', ctg_farm_telpar='0412-010-4687',
ctg_farm_telcel='0412-010-4687', ctg_farm_email1='farmadosiscasaderepresentacion@gmail.com',
ctg_farm_email2='', ctg_geo_id='V1503',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='1080', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='23950540'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='FARMALOGICA S.A.'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FAB'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FAB'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='FARMALOGICA S.A.'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABENV'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABENV'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='FARMALOGICA S.A.'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='1', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE ctg_empresas
SET ctg_emp_tpoper='1', ctg_emp_origen='2',
ctg_emp_nombre='FARMALOGICA S.A.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='COL', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='CARRERA 44 N 20 38', ctg_emp_dir_c='',
ctg_emp_tels='+5712693999',
ctg_emp_fax='',
ctg_emp_email1='alv@farmalógica.com',
ctg_emp_email2='-',
ctg_emp_pweb='www.farmalogica.com.co',
ctg_emp_farm_id='0', ctg_emp_prop=1, ctg_emp_fabr1=1, ctg_emp_fabr3=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='FARMALOGICA S.A.'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='PRO'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1526'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='PRO'
AND "vus_efEMP_nombre"='FARMALOGICA S.A.'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
tabla emp ctg_empresas
SELECT ctg_emp_rif FROM ctg_empresas WHERE ctg_emp_nombre='HEBEI UNION FARMACEUTICA CO., LTD.'ACTUALIZO EMPRESA UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='HEBEI UNION FARMACEUTICA CO., LTD.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='No.58 Canfeng Road, ciudad de Shijiazhuang, provincia de Hebe', ctg_emp_dir_c='',
ctg_emp_tels='0',
ctg_emp_fax='',
ctg_emp_email1='-',
ctg_emp_email2='-',
ctg_emp_pweb='-',
ctg_emp_farm_id='0', ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='HEBEI UNION FARMACEUTICA CO., LTD.'
UPDATE ctg_empresas
SET ctg_emp_tpoper='0', ctg_emp_origen='2',
ctg_emp_nombre='HEBEI UNION FARMACEUTICA CO., LTD.', ctg_emp_nit='',
ctg_emp_ci='', ctg_emp_ci_tpo='0',
ctg_geo_id='CHN', ctg_emp_urb='0',
ctg_emp_ave='0', ctg_emp_edi='0',
ctg_emp_piso='0', ctg_emp_codpos='0',
ctg_emp_punref='0', ctg_emp_ciudad='0',
ctg_emp_dir='No.58 Canfeng Road, ciudad de Shijiazhuang, provincia de Hebe', ctg_emp_dir_c='',
ctg_emp_tels='0',
ctg_emp_fax='',
ctg_emp_email1='-',
ctg_emp_email2='-',
ctg_emp_pweb='-',
ctg_emp_farm_id='0', ctg_emp_fabr1=1, ctg_emp_fabr2=1, ctg_emp_fabr3=1, ctg_emp_fabr4=1, ctg_emp_fabr5=1, ctg_emp_fabr6=1, ctg_emp_fabr7=1, ctg_emp_fabr=1, ctg_emp_sta='1',
ctg_emp_usr='24123488', ctg_emp_dt=now()
WHERE ctg_emp_nombre='HEBEI UNION FARMACEUTICA CO., LTD.'
UPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1756'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABPRA'
AND "vus_efEMP_nombre"='HEBEI UNION FARMACEUTICA CO., LTD.'
ACTUALIZO CODIGO EN TABLA VUS TRAMITES EMPRESASUPDATE "vus_tramites_ef1_EMPRESAS"
SET "vus_efEMP_rif"='e1756'
WHERE "vus_efEMP_numsol"='202500868' AND "vus_efEMP_tpt_id"='SREF-0005'
AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_rol_id"='FABPRA'
AND "vus_efEMP_nombre"='HEBEI UNION FARMACEUTICA CO., LTD.'
******* COPIAR REGENTE ******
SELECT ctg_farm_ci FROM ctg_farmaceuticos WHERE ctg_farm_ci='0'
UPDATE ctg_farmaceuticos
SET ctg_farm_citpo='', ctg_farm_colfar='',
ctg_farm_msds='', ctg_farm_inprefar='',
ctg_farm_nme1='', ctg_farm_nme2='',
ctg_farm_ape1='', ctg_farm_ape2='',
ctg_farm_nombre=' ', ctg_farm_telpar='',
ctg_farm_telcel='', ctg_farm_email1='',
ctg_farm_email2='', ctg_geo_id='',
ctg_farm_urb='', ctg_farm_ave='',
ctg_farm_edi='', ctg_farm_piso='',
ctg_farm_codpos='', ctg_farm_punref='',
ctg_farm_dir='', ctg_farm_patro='0', ctg_farm_rege='1',
ctg_farm_sta='1', ctg_farm_usr='24123488', ctg_farm_dt=now()
WHERE ctg_farm_ci='0'
abogado SELECT * FROM "vus_tramites_ef1_EMPRESAS" WHERE "vus_efEMP_numsol"='202500868'
AND "vus_efEMP_tpt_id"='SREF-0005' AND "vus_efEMP_tpr_id"='02' AND "vus_efEMP_abog"='1'
ENTRE AL LOCAL DOWNLOAD
SELECT vus_ef_fec_cre, vus_ef_est_id FROM vus_tramites_ef1 WHERE vus_ef_numsol='202500868'
/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef
/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025
/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09
/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868
ef_SREF-0005_202500868_QFPA_QFPA02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_QFPA_QFPA02_1.pdf'
ef_SREF-0005_202500868_EST_EST04_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST04_1.pdf'
ef_SREF-0005_202500868_CPF_CPF01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_CPF_CPF01_1.pdf'
ef_SREF-0005_202500868_EST_EST07_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST07_1.pdf'
ef_SREF-0005_202500868_LE_LE09_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE09_1.pdf'
IMG_IMGef_SREF-0005_202500868_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'IMG_IMGef_SREF-0005_202500868_1.pdf'
ef_SREF-0005_202500868_MA_MA03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_MA_MA03_1.pdf'
IMG_IMGef_SREF-0005_202500868_4.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'IMG_IMGef_SREF-0005_202500868_4.pdf'
ef_SREF-0005_202500868_EST_EST02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST02_1.pdf'
ef_SREF-0005_202500868_LE_LE12_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE12_1.pdf'
ef_SREF-0005_202500868_CA_CA02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_CA_CA02_1.pdf'
ef_SREF-0005_202500868_A_A02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_A_A02_1.pdf'
ef_SREF-0005_202500868_LE_LE15_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE15_1.pdf'
ef_SREF-0005_202500868_LE_LE16_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE16_1.pdf'
ef_SREF-0005_202500868_QFPT_QFPT01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_QFPT_QFPT01_1.pdf'
ef_SREF-0005_202500868_LE_LE07_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE07_1.pdf'
ef_SREF-0005_202500868_LE_LE11_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE11_1.pdf'
ef_SREF-0005_202500868_QFPT_QFPT03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_QFPT_QFPT03_1.pdf'
ef_SREF-0005_202500868_A_A01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_A_A01_1.pdf'
ef_SREF-0005_202500868_EST_EST06_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST06_1.pdf'
ef_SREF-0005_202500868_F_F01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_F_F01_1.pdf'
ef_SREF-0005_202500868_BF_BF05_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_BF_BF05_1.pdf'
ef_SREF-0005_202500868_EST_EST05_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST05_1.pdf'
ef_SREF-0005_202500868_LE_LE14_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE14_1.pdf'
ef_SREF-0005_202500868_LE_LE01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE01_1.pdf'
ef_SREF-0005_202500868_QFPA_QFPA03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_QFPA_QFPA03_1.pdf'
IMG_IMGef_SREF-0005_202500868_3.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'IMG_IMGef_SREF-0005_202500868_3.pdf'
payment_reference_20446545567.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'payment_reference_20446545567.pdf'
ef_SREF-0005_202500868_EST_EST03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_EST_EST03_1.pdf'
ef_SREF-0005_202500868_LE_LE05_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE05_1.pdf'
ef_SREF-0005_202500868_LE_LE04_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE04_1.pdf'
ef_SREF-0005_202500868_LE_LE02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE02_1.pdf'
IMG_IMGef_SREF-0005_202500868_5.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'IMG_IMGef_SREF-0005_202500868_5.pdf'
ef_SREF-0005_202500868_IG_IG01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_IG_IG01_1.pdf'
ef_SREF-0005_202500868_A_A03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_A_A03_1.pdf'
IMG_IMGef_SREF-0005_202500868_2.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'IMG_IMGef_SREF-0005_202500868_2.pdf'
ef_SREF-0005_202500868_MA_MA02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_MA_MA02_1.pdf'
ef_SREF-0005_202500868_LE_LE03_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE03_1.pdf'
ef_SREF-0005_202500868_LE_LE08_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_LE_LE08_1.pdf'
ef_SREF-0005_202500868_QFPT_QFPT02_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_QFPT_QFPT02_1.pdf'
ef_SREF-0005_202500868_CA_CA01_1.pdf
hago update UPDATE "vus_tramites_ef1_DOCs" SET "vus_efDOC_docubi" = '/var/www/html/siverc/adm/docsserver/prodmed/docs_tramites/ef/2025/09/SREF-0005_202500868' WHERE "vus_efDOC_numsol" = '202500868' AND "vus_efDOC_tpt_id" = 'SREF-0005' AND "vus_efDOC_tpr_id" = '02' AND "vus_efDOC_doc_name" = 'ef_SREF-0005_202500868_CA_CA01_1.pdf'
(41)(41)
rm -rf /var/www/html/siverc/user/docs/ef/2025/09/SREF-0005_202500868