🔁 Cross-Service Similarity Report

Operación Insert CIW500 realizada con éxito

SELECT * FROM [Hoja1$]

SELECT 1 EXISTE FROM EC.EC0100 WHERE EC01NUMENSAYO_FUN = :numEnsayoFun

SELECT EC12ID_PROCEDIMIENTO_FUN FROM EC1200, EC0100

Ejecutando consulta INSERT INTO CIW500

SELECT NVL(MAX(CI10.CI10NUMDIRECCI), 0) + 1 CI10NUMDIRECCI FROM CI1000 CI10 WHERE CI10.CI21CODPERSONA = :codigoPersona

SELECT 1 EXISTE FROM CI1000 WHERE CI21CODPERSONA = :codigoPersonaCUN AND CI10NUMDIRECCI = :numDireccion

,(SELECT CI2200.CI21CODPERSONA FROM CI2200 WHERE CI2200.CI22NUMHISTORIA = :numHis)

SELECT EC0900.EC01NUMENSAYO, EC0900.EC07NUMCICLO, EC0900.EC08NUMVISITA, EC0900.PR01CODACTUACION FROM EC0900,

SELECT EC03COD from EC0300 where sg02cod = :codStakeholder

SELECT CI21CODPERSONA, CI10NUMDIRECCI FROM CI1000 WHERE CI10CAMPOID_SF = :idDireccionSalesforce

SELECT ci2200.ci22numhistoria Historia, ci2200.ci22priapel, ci2200.ci22segapel,ci2200.ci22nombre, ci2200.CI22FECNACIM,

SELECT 1 EXISTE FROM FAL900 WHERE FAL9CAMPOID_SF = :idRecadoSalesforce

UPDATE CA1200 SET CA12ESTADO = :estado WHERE CA12NUMREG = :numReg

select ad07codproceso from ad0500 where ad01codasistenci = :codAsistencia AND ad02coddpto = :codDepartamento

+(SELECT COUNT(*) FROM PR9400, PR9200, PR9300 WHERE

SELECT 1 FROM CI0100 WHERE PR04NUMACTPLAN = :numActPlan AND CI01SITCITA = 3

UPDATE PR0400 SET PR04FECIMG = SYSDATE WHERE PR04NUMACTPLAN = :numActPlan

SELECT 1 EXISTE FROM EC.ECB800 WHERE ECB8CODRAMA = :codigoRama

DELETE FROM EC.EC0700 WHERE EC01NUMENSAYO = :numEnsayo

UPDATE IM0100 SET IM08CODESTDOC = :estado, IM01FECFINMECA = :fecFinMeca,  SG02COD_FINMECA = :finMeca, IM01INDVNA = -1

SELECT 1 EXISTE FROM CI3100 WHERE CI21CODPERSONA = :codigoPersonaCUN AND CI31TFNO = :telefono

(select PR04NUMACTPLAN_PP from prc100 where pr04numactplan_aso = pr04numactplan) PR04NUMACTPLAN_PP

UPDATE CA1000 SET CA10FECHABAJA = SYSDATE WHERE CA10CODCURSO = :codCurso

SELECT CA10CODCURSO FROM CA1000 WHERE CA10CODCURSO != :codCurso AND CA25CODORGANIZADOR = 1 AND CA10NOMCURSO = :nomCurso AND CA10FECHABAJA IS NULL

UPDATE CA1100 SET CA11FECHABAJA = SYSDATE WHERE CA10CODCURSO = :codCurso AND CA11NUMEDICION = :numEdicion

SELECT CA12NUMREG FROM CA1200 WHERE CA10CODCURSO = :codCurso AND CA11NUMEDICION = :numEdicion AND CA12DNI = :dni AND CA12ESTADO = 2

select ad74codcentro from pr0400, ad0200 where pr0400.AD02CODDPTO = ad0200.AD02CODDPTO and pr0400.PR04NUMACTPLAN =  :numActPlan

SELECT 1 FROM PR0400,PR0100 WHERE PR04NUMACTPLAN = :numActPlan AND PR0400.PR01CODACTUACION = PR0100.PR01CODACTUACION AND pr0100.PR12CODACTIVIDAD= 215

SELECT 1 EXISTE FROM ADF300 WHERE ADF3NUMCASO_SF = :idSalesforce

SELECT MIN(CI0100.CI01FECCONCERT) KEEP (DENSE_RANK FIRST ORDER BY CI01FECCONCERT) FECHA_CITA,

UPDATE CA1200 SET CA12ESTADO = :estado

SELECT CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,CI2200.CI22SEGAPEL,CI2200.CI30CODSEXO,PR0400.PR04NUMACTPLAN,CI2200.CI22FECNACIM,CI0100.CI01FECCONCERT,PR0400.AD02CODDPTO

select DECODE(PR0400.AD02CODDPTO, PR0900.AD02CODDPTO, 'E', DECODE(AD12CODTIPOASIST, 1, 'H', 'A')) TIPO

SELECT AD7400.AD74DESCENTRO FROM AD0200, AD7400 WHERE

SELECT 1 FROM ci0100 where PR04NUMACTPLAN = :numactplan AND ci0100.ci01sitcita = '1'

insert into im1600 (im01numdoc,pr04numactplan) values (:numDoc,:numActPlan)

INSERT INTO preq00(PREQNUMREG, PR04NUMACTPLAN, PREQINDREALIZADO,

(SELECT fr66codpeticion FROM frad00 WHERE fraecodtipevento = :codTipoEvento AND fradfecha_reg = to_date(:fechaReg, 'YYYY-MM-DD HH24:MI:SS')) AND

select AD01CODASISTENCI from ad0100 where ad01fecfin is null and ci22numhistoria = :numHistoria