select * from cadlic where proclic = '000173/23'
select proclic,numlic from cadlic where proclic in ( '000173/23','000241/23','000256/23')
select * from regpreco where numlic in (select numlic from cadlic where proclic in ( '000173/23','000241/23','000256/23'))
select * from regprecoHIS where numlic in (select numlic from cadlic where proclic in ( '000173/23','000241/23','000256/23'))
select * from regpreco where numlic in (select numlic from cadlic where proclic in ( '000173/23','000241/23','000256/23'))
select * from regprecoHIS where numlic in (select numlic from cadlic where proclic in ( '000173/23','000241/23','000256/23'))
select * from cadorc where numorc ='01639/24'
delete from  icadorc where numorc ='01639/24'
delete from  cadorc where numorc ='01639/24'
select * from mon$attachments
delete  from mon$attachments
select * from cadlic where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadpro where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic_detalhe where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic_detalhe_fic where numlic in (select numlic from cadlic where proclic='000173/23')
select * from regpreco where numlic in (select numlic from cadlic where proclic='000173/23')
select * from regprecohis where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic_detalhe where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadprolic where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadpro_final where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadpro_lance where numlic in (select numlic from cadlic where proclic='000173/23')
update cadped set numlic='3786' where proclic='000173/23' --3786
select * from cadorc where numlic_rp='3786'
select * from icadorc where id_cadorc in(  select id_cadorc from cadorc where numlic_rp='3786')
select * from cadorc where id_cadorc in(  select id_cadorc from cadorc where numlic_rp='3786')
select * from icadorc where id_cadorc in(  select id_cadorc from cadorc where numlic_rp='3786')
select * from cadorc where id_cadorc in(  select id_cadorc from cadorc where numlic_rp='3786')
SELECT * FROM SENHA
SELECT  * FROM SENHA
delete from mon$attachments
select * from cadpro_saldo_ant where numlic in (select numlic from cadlic where proclic='000173/23')
select * from cadpro where numlic=3943
select * from cadpro where numlic=3943 and item=2
select * from regpreco where numlic=3943 and item=2
select * from regpreco where numlic=3943 and item=1
select * from regpreco where numlic=3943 and item=2
select * from regprecohis where numlic=3943 and item=2
select * from regpreco where numlic=3943 and item=2
select * from regprecohis where numlic=3943 and item=2
select * from cadpro where numlic=3943 and item=2
select * from cadpro where numlic=3943 and item=167
select * from regprecohis where numlic=3943 and item=167
select * from regprecohis where numlic=3943 and codatualizacao=1
select * from regprecohis where numlic=3943 and codatualizacao=1 and subem=1
select * from cadpro where numlic=3943  and subem=1
select * from regprecohis where numlic=3943 and codatualizacao=1 and subem=1
select * from regprecohis where numlic=3943 and codatualizacao=1 
select *  from regpreco where numlic=3943 
delete from regpreco where numlic=3943 
select * from regprecohis where numlic=3943 and codatualizacao=1 
select *  from regprecodoc where numlic=3943 
select * from regprecohis where numlic=3943 and codatualizacao=1 
insert into regpreco (cod,dtprazo,codif,cadpro,quan1,vaun1,vato1,qtdent,subem,status,item,motivo,marca,numorc,codccusto,codatualizacao, ultima,numlic,qtdsol,vatoent,vatosol,tpcontrole_saldo) select '0','21.08.2024',codif,cadpro,quan1,vaun1,vato1,'0',subem,status,item,motivo,marca,numorc,codccusto,codatualizacao, ultima,numlic,'0','0','0','Q' from regprecohis where numlic=3943 and codatualizacao=1 
select * from regpreco where numlic=3943 and codatualizacao=1 
select * from ajuste_audesp where nlicitacao in (select nlicitacao from cadlicitacao where numlic=3943 )
update ajuste_audesp set enviou='N' where nlicitacao in (select nlicitacao from cadlicitacao where numlic=3943 )
delete from ajuste_audesp  where nlicitacao in (select nlicitacao from cadlicitacao where numlic=3943 )
select * from icadreq where requi in (select requi from requi where numped in (select numped from cadped where proclic='000173/23'))
select * from REQUI
SELECT * FROM CADPED WHERE PROCLIC='000173/23'
SELECT * FROM ICADPED WHERE NUMPED IN (SELECT NUMPED FROM CADPED WHERE PROCLIC='000173/23')
DELETE FROM ICADPED WHERE NUMPED IN (SELECT NUMPED FROM CADPED WHERE PROCLIC='000173/23')
DELETE FROM CADPED WHERE PROCLIC='000173/23'
select * from cadpro_saldo_ant where numlic in (select numlic from cadlic where proclic='000173/23')
select * from regpreco_saldo_ant where numlic in (select numlic from cadlic where proclic='000173/23')
select 'insert into regpreco (ano,item,cadpro,qtdent,numlic,vatoent) select '||'2023'||','||item||','''||cadpro||''','|| ''''||qtdent||''','||numlic||','''||vatoent||''''||' from cadcli;' from regpreco_saldo_ant where numlic in (select numlic from cadlic where proclic='000173/23')
select * from tabestrutura
select * from tabestrutura where idxtabela = 'NOTA'
select * from tabestrutura where idxtabela = 'PKNOTA'
select * from tabestrutura_PKFKDBT_01
select * from tabestrutura_PKFKDBT_01 where idnome = 'PKNOTA'
select * from tabestrutura_PKFKDBT_02 where idnome_pk = 'PKNOTA'
select * from desfor where codif=40153
select * from despes where tpem not in ('EX','AD','AN','DA') and grupo <> 1 and numlic is not null and enviou_tce is null
select * from despes where tpem not in ('EX','AD','AN','DA') and grupo <> 1 and numlic is not null and enviou_tce is null and contrato is not null
select * from despes where tpem not in ('EX','AD','AN','DA') and grupo <> 1 and numlic is not null and enviou_tce is null and contrato is  null
                                     select * from cadlic where proclic='000012/25'
                                     select numlic,gera_contrato_tce from cadlic where proclic='000012/25'
select numlic,gera_contrato_tce from cadlic where proclic='000012/25'
select * from senha where login like 'maciel%'
select fonte_stn from despes
select fonte_stn from desdis
select fonte_stn from desorc
update desorc set fonte_stn='1.500'
update desdis set fonte_stn='1.500'
select * from TRANSP_PARAMETROS
select * from TRANSP_PARAMETROS where chave like 'ESIC%'