select * from despes where nempg in(6330,3678) 
select * from dessub_retencao 
SELECT * FROM DESSUB_RETENCAO 
SELECT  * FROM DESPES_RETENCAO_SALDO 
SELECT * FROM DESSUB_RETENCAO 
SELECT  * FROM DESPES_RETENCAO_SALDO 
SELET * FROM DESCON_DETALHE 
SELECT * FROM DESCON_DETALHE 
SELECT * FROM DESCON_DETALHE WHERE CONTA=3127 
SELECT * FROM DESCON_DETALHE WHERE BALCO_SCPI=311201 
SELECT * FROM DESCON_DETALHE WHERE BALCO_SCPI=311201 AND CONTA=3127 
DELETE FROM DESCON_DETALHE WHERE BALCO_SCPI=311201 AND CONTA=3127 
SELECT * FROM DESCON_DETALHE WHERE CONTA=3127 
select * from recorc 
select * from despes where nempg in(3143,6417,6418,2928,2929,3677,3678,6331,7174,7175,7176,7422,7423) 
select * from despes where nempg in(8432,3143,6417,6418,2928,2929,3677,3678,6331,7174,7175,7176,7422,7423) 
select * from despes where nempg in(8432,3143,6418,2928,2929,3677) 
select * from PREREC 
select * from despes 
select * from despes  where datae < '01.01.2023' 
SELECT FIRST 1 * FROM ADP_CCR_BANCARIO 
SELECT  * FROM ADP_CCR_BANCARIO 
select * from condia_tce 
select * from condia_tce  where evento='CONTRATO' 
DELETE from condia_tce  where evento='CONTRATO' 
select * from condia_tce where ie='1' 
select * from condia_tce where ie='1'  and fonte_stn='1.001.0000' 
update condia_tce set fonte_stn='1.500' where ie='1'  and fonte_stn='1.001.0000' 
select * from condia_tce where ie='1'  and fonte_stn='1.001.0000' 
select * from condia_tce where ie='1'  and fonte_stn='0' 
select * from condia_tce 
select * from condia_tce   where balco='121110401' 
select * from condia_tce   where balco='832310100' 
SELECT * FROM ADP_CCR_IDENTRECEITA 
select * from icadreq where requi = '000000/23' 
UPDATE CENTROCUSTO SET FK_TABORGAO = '2' 
select * from centrocusto 
select * from cadlic where proclic = '000077/22' 
SELECT FIRST 1 * FROM ADP_CCR_IDENTRECEITA 
SELECT  * FROM ADP_CCR_IDENTRECEITA 
select * from condia_tce 
select * from condia_tce where fonte_stn='0' 
select * from condia_tce where fonte_stn='1001' 
select * from condia_tce where fonte_stn='1002' 
select * from despes where nempg_xml=1100038400 
select * from despes where nempg_xml=001100038400 
SELECT  * FROM DESSUB_RETENCAO 
SELECT FIRST 1 * FROM DESPES_RETENCAO_SALDO 
SELECT * FROM DESPES_RETENCAO_SALDO 
SELECT * FROM DESPES_RETENCAO_SALDO where ficha_extra IN(9010,9011) 
SELECT * FROM DESPES_RETENCAO_SALDO 
SELECT * FROM DESPES_RETENCAO_SALDO where ficha_extra IN(9010,9011) 
SELECT * FROM DESPES_RETENCAO_SALDO where ficha_extra IN(9001,9010,9011) 
SELECT * FROM DESPES_RETENCAO_SALDO where nempg=1470029520 
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA IN(273186,273185) 
SELECT * FROM DESPES_RETENCAO_SALDO where ficha_extra IN(9001,9010,9011) 
SELECT FIRST 1 * FROM ADP_CCR_RECEBCONVENIO 
SELECT FIRST 1 * FROM ADP_CCR_CONCESSAOCONVENIO 
SELECT * FROM DESPES_RETENCAO_SALDO where ficha_extra IN(9001,9010,9011) 
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA IN(295551,295552) 
SELECT * FROM DESPES WHERE NEMPG=3677 
SELECT * FROM DESPES WHERE FICHA IN(8001,8002) AND DATAE < '31.12.2022' 
SELECT * FROM DESPES WHERE FICHA IN(8001,8002) AND DATAE < '31.12.2021' 
SELECT * FROM DESPES WHERE NEMPG=3677 
SELECT * FROM DESPES WHERE NEMPG=6330 
SELECT * FROM DESPES WHERE NEMPG IN(6330, 1666) 
SELECT * FROM DESPES WHERE NEMPG IN(1666,6330) 
SELECT * FROM DESPES WHERE NEMPG IN(2928) 
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA IN(340283,340284) 
SELECT * FROM CONDIA_TCE WHERE IE=16 
DELETE FROM CONDIA_TCE WHERE IE=16 
SELECT * FROM CONDIA_TCE WHERE LICIT=3 
SELECT * FROM CONDIA_TCE WHERE LICIT=3  AND IE=1 
SELECT * FROM CONDIA_TCE WHERE LICIT=3  AND IE=1   AND BALCO=896220100 
SELECT * FROM CONDIA_TCE WHERE LICIT=3  AND IE=1   AND BALCO IN(531700000, 532100000 ) 
SELECT * FROM CONDIA_TCE WHERE LICIT=3  AND IE=1 
SELECT * FROM CONDIA_TCE WHERE LICIT=3  AND IE=1 AND BALCO IN(531700000, 531200000 ) 
SELECT * FROM DESPES WHERE NEMPG_XML=901600641700 
SELECT * FROM DESPES WHERE LICIT='MAT / SERV - TOMADA'  AND DATAE < '01.01.2023' 
SELECT * FROM DESPES WHERE NEMPG_XML=901600641700 
SELECT * FROM CONDIA_TCE 
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA=227331 
SELECT * FROM CONDIA_TCE WHERE NDOC='901600641700' 
SELECT * FROM CONDIA_TCE WHERE NDOC='901600641800' 
SELECT * FROM DESPES WHERE NEMPG_XML=901600641800 
SELECT * FROM TABEMPRESA 
SELECT * FROM CONDIA_TCE 
SELECT * FROM CONDIA_TCE WHERE ANO_CONTRATO=22 
SELECT * FROM TABEMPRESA 
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA=335052 
select * from crodes 
select nempg, nempg_xml, forn_ident_xml, forn_tipo_xml, uo_audesp, ue_audesp, proclic_xml, contrato_tipo, convenio_tipo from despes where ano_resto is not null 
select * from condia_tce 
select * from condia_tce where datae > '31.01.2023' 
select * from condia_tce where datae > '31.01.2023'  and evento='CONTRATO' 
DELETE from condia_tce where datae > '31.01.2023'  and evento='CONTRATO' 
SELECT FIRST 1* FROM CONDIA_TCE 
SELECT FIRST 1* FROM CONDIA_TCE WHERE NDOC IN('014700295200','1470029520') 
SELECT * FROM CONDIA_TCE WHERE NDOC IN('014700295200','1470029520') 
SELECT * FROM CONDIA_TCE WHERE NDOC IN('00110038400','0110003840') 
SELECT * FROM CONDIA_TCE WHERE NDOC IN('110038400','0110003840') 
SELECT * FROM CONDIA_TCE WHERE NDOC IN('1100038400','0110003840') 
SELECT * FROM CONDIA_TCE WHERE NDOC IN('1100038400','001100038400') 
select * from condia_tce where ndoc='206' 
select * from condia_tce where ndoc='206'  and numcontrato=0031 
select * from condia_tce where ndoc='206'  and contrato='0031/18' 
select * from condia_tce where  contrato='0031/18' 
select * from condia_tce where  contrato='0031/18' and ano_contrato='2018' 
select * from desorc 
select * from desdis 
select * from desorc 
select * from desorc where empresa=2 
select * from desdis where empresa=2 
SELECT FIRST 1 * FROM PPACADREC 
SELECT FIRST 1 * FROM PPA_CADREC 
SELECT * FROM PPA_CADREC 
SELECT  * FROM PPA_RECEITA 
select * from  tabempresa 
delete from pt_movbem    where codigo_cpl_mov='237110301' 
update pt_cadpat set dt_contabil=datae_pat   where dt_contabil is null 
update pt_movbem set dt_contabil=data_mov 
select * from  tabempresa 
select * from descon 
select * from pt_cadpat where chapa_pat=001261 
select * from pt_cadpat where codigo_pat=789 
SELECT FIRST 1 * FROM PT_MOVBEM 
SELECT FIRST 1 * FROM PT_MOVBEM  where codigo_pat_mov=789 
select * from pt_cadpat where codigo_pat=789 
SELECT FIRST 1 * FROM PT_MOVBEM  where codigo_pat_mov=789 
select * from pt_cadpat where codigo_pat=789 
SELECT FIRST 1 * FROM PT_MOVBEM  where codigo_pat_mov=789 
select * from pt_cadpat where codigo_pat=789 
SELECT FIRST 1 * FROM PT_MOVBEM  where codigo_pat_mov=789 
SELECT PT_CADPAT.* FROM PT_CADPAT WHERE (COALESCE(PT_CADPAT.FK_CODIGO_SET_PAT, -1) <> (SELECT FIRST 1 COALESCE(PT_MOVBEM.FK_PT_CADPATS, -1)                                                      FROM PT_MOVBEM                                                      WHERE PT_MOVBEM.FK_PT_CADPAT = PT_CADPAT.PK_PT_CADPAT                                                      AND PT_MOVBEM.TIPO_MOV = 'A')) 
select * from senha 
select * from desorc 
delete  from desorc 
select * from despes where nempg=4611 
select * from viewliq where pkemp=5213 
select * from condia_tce where balco like '8123109' 
select * from condia_tce where balco like '8123109%' 
select * from condia_tce where balco like '8123109%' and contrato='0005/23' 
select * from condia_tce where sequencia in(1262023,1262024) 
select * from condia_tce where balco in (812310901,812310902,812310903) 
select * from condia_tce where balco in (812310901,812310902,812310903) and contrato='0005/23' 
select * from condia_tce where balco in (812310901,812310902,812310903) and contrato_tipo='10' 
select * from condia_tce where balco in (712310900,812310901,812310902,812310903) and contrato_tipo='10' 
select * from condia_tce where sequencia in(1262033,1262034) 
select * from condia_tce where sequencia in(1262035,1262034) 
select * from condia_tce where sequencia in(1262037,1262038) 
select * from condia_tce where sequencia in(1262039,1262040) 
select * from condia_tce where balco like '8123109%' 
select * from condia_tce where balco like '8123109%' and contrato_tipo=10 
select * from dessub_retencao
select * from despes where nempg=827
select * from dessub_retencao
select * from dessub_retencao where pkemp=936
select * from despes where nempg=827
select * from dessub_retencao
SELECT A.* FROM DESSUB_RETENCAO A INNER JOIN RECEIT B ON B.NLANC = A.RECEIT INNER JOIN DESPES C ON C.PKEMP = B.PKEMP WHERE C.PKEMP IN (936,10826) 
select * from despes where nempg_xml='901600391700'
select * from despes where nempg=3917
SELECT * FROM TABEMPRESA
select * from despes where nempg=3917
SELECT * FROM TABEMPRESA
select * from despes where nempg=406
select * from despes where nempg in(406,404)
select * from despes where pkemp in(452,454)
select * from dessub where pkemp in(452,454)
select * from dessub
select * from dessub where pkemp=390
select * from viewliq where pkemp=390
select * from recdis where ficha in (358,359,361)
select * from recdis
select * from recdis where ficha = 358
select * from desdis where ficha = 358
select * from desdis where ficha in (358, 359, 361)
select * from pt_cadpat
select * from pt_cadpat where dt_contabil ='20.04.1984'
select * from pt_cadpat where dt_contabil ='01.01.2024'
select * from tabempresa
select pkemp, contrato, fk_contratos from despes where nempg=4789 and ano_resto = 2023
select pkemp, contrato, fk_contratos from despes where  ano_resto = 2023
select a.* from despes a where a.contrato is not null and a.fk_contratos is null
select codigo, pk_contratos from contratos where codigo = '0051/22'
select a.* from despes a where a.contrato is not null and a.fk_contratos is null
select codigo, pk_contratos from contratos where codigo = '0051/22'
select pkemp, contrato, fk_contratos from despes where nempg=4789 and ano_resto = 2023 
select * from despes where nempg=4789 and ano_resto = 2023 
select a.* from despes a where a.contrato is not null and a.fk_contratos is null 
select codigo, pk_contratos from contratos where codigo = '0034/23'
select * from despes where contrato='0034/23' and ano_resto = 2023 
select codigo, pk_contratos from contratos where codigo = '0034/23'
select * from despes where contrato='0034/23' and ano_resto = 2023 
select a.* from despes a where a.contrato is not null and a.fk_contratos is null
select contrato from despes a where a.contrato is not null and a.fk_contratos is null
select codigo, pk_contratos from contratos where codigo = '0046/23'
select * from despes where contrato='0046/23' and ano_resto = 2023 
select codigo, pk_contratos from contratos where codigo = '0103/23'
select * from despes where contrato='0103/23' and ano_resto = 2023 
select codigo, pk_contratos from contratos where codigo = '0105/23'
select * from despes where contrato='0105/23' and ano_resto = 2023 
select a.* from despes a where a.contrato is not null and a.fk_contratos is null
select contrato, fk_contratos from despes where contrato in('0034/23','0046/23','0103/23','0105/23')
select codigo, pk_contratos from contratos where codigo in('0034/23','0046/23','0103/23','0105/23')
select * from tabempresa
select * from despes where nempg=7175
select * from despes where nempg=7176
select * from senha
select * from despes where nempg=7174
select * from condia_tce where sequencia in(62380,539078)
select * from despes where nempg=7174
SELECT * FROM PCASP_LOG WHERE REF = '06'
select * from despes where nempg=7174
SELECT  * FROM DIARIA_PRESTDOC
SELECT  * FROM DIARIA_PRESTACAO
SELECT  * FROM AD_TABELA_DIARIA
SELECT * FROM DIARIA_PRESTACAO
SELECT * FROM TS_REFER
select * from condia_tce where sequencia=845606
SELECT RDB$TRIGGER_NAME, RDB$RELATION_NAME, RDB$TRIGGER_INACTIVE FROM RDB$TRIGGERS WHERE RDB$TRIGGER_INACTIVE = 1;
select * from despes where nempg in (8952,9182)
select * from condia_tce where sequencia=1286931
SELECT * FROM CALCULA_LIQ_APAGAR('31.12.2024') 
SELECT * FROM CALCULA_LIQ_APAGAR('31.12.2024') WHERE NEMPG=386
SELECT * FROM DESPES WHERE NEMPG=386
SELECT * FROM DESPES WHERE PKEMP=433
SELECT * FROM DESCSUB WHERE PKEMP=433
select * from despes where nempg=310
SELECT * FROM DESCSUB WHERE PKEMP=344
SELECT * FROM CALCULA_LIQ_APAGAR('31.12.2024') 
SELECT * FROM CALCULA_LIQ_APAGAR('31.12.2024') WHERE NEMPG=386
select * from despes where nempg=307
SELECT * FROM DESCSUB WHERE PKEMP=341
select * from condia_tce where sequencia in(62379, 1717000, 1417001, 1417002, 1417003, 1417004, 1417005, 1417006, 1417007)
select * from condia_tce where sequencia in(62379, 1417000, 1417001, 1417002, 1417003, 1417004, 1417005, 1417006, 1417007)
select * from condia_tce where sequencia in(62379, 1427810, 1427811, 1427812, 1427813, 1427814, 1427815, 1427816, 1427817)
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA IN(1438644,1438645,1438646,1438647,1438648,1438649,1438650,1438651)
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S';
select * from receit
select * from receit where ficha=5
update receit set BALCO_PATRIM='112510105' where ficha=5
update receit set BALCO_PATRIM='112510105' where ficha=16
select * from receit where ficha=16
select * from receit where ficha=17
SELECT DISTINCT v.pkemp,                 v.numsub,                 b.nempg,                 a.idsolic,                 c.empresa,                 coalesce(b.ano_resto, extract(YEAR                                               FROM b.datae)) ano_emp,                 coalesce(b.codlo_ant, c.codlo) codlo,                 coalesce(b.cfpro_ant, c.cfpro) cfpro,                 coalesce(b.catec_ant, b.catec) catec,                 b.codif,                 d.nome,                 d.insmf,                 a.datasolic,                 a.horasolic,                 cast((v.vadem-v.anula) AS numeric(14, 2)) AS valorliberado,                 cast(substring(a.finalidade                                FROM 1                                FOR 5000) AS varchar(5000)) AS finalidade FROM adiant_solicitacao a INNER JOIN viewliq v ON v.idsolic = a.idsolic INNER JOIN despes b ON b.pkemp = v.pkemp INNER JOIN desdis c ON c.ficha = b.ficha INNER JOIN desfor d ON d .codif = b.codif WHERE c.empresa = '1'   AND v.vadem > 0   AND a.TipoSolic in ('DM',                           'DS')   AND b.tpem <> 'AD'   AND ((v.vadem - v.anula) > 0)   AND v.vapag <> 0   AND COALESCE(SUBSTRING(b.CATEC_ANT                          FROM 8                          FOR 2), b.ELEMENTO) IN ('14',                                                      '33') 
SELECT * FROM DESPES WHERE NEMPG IN (2941, 2865)
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)
SELECT * FROM ADIANT_SOLICITACAO
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)
SELECT * FROM ADIANT_SOLICITACAO
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)
SELECT * FROM ADIANT_SOLICITACAO
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)
 SE
SELECT * FROM DESPES WHERE NEMPG IN (2941, 2865) 
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)
SELECT * FROM ADIANT_SOLICITACAO
SELECT * FROM ADIANT_SOLIC_VIAGEM
SELECT * FROM DESPES WHERE NEMPG IN (2941, 2865)
SELECT * FROM VIEWLIQ WHERE PKEMP IN (3210, 3297)