1)ALTEREI O RECORD GROUP DE ALGUMAS TELAS E DEPOIS DE COMPILAR O FORM , não SEI SE GEREI UM EXECUTAVEL CORRETAMENTE(CTRL+T)
A PARTIR DAI QUANDO EU RODO O FORM ELE não CARREGA OS VALORES NA LOV
ESTOU FAZENDO TUDO EM UM AMBIENTE DE TESTE(não DE PRODUÇÃO)
SEGUE ABAIXO O CODIGO DOS SQLS DAS LOVS ALTERADAS(NO SQL PLUS ELE TRAZ AS INFORMACOES NORMALMENTE. NA LOV NÃO)
lov de destino -
-----------------sql antes da modificacao -
select unt2.cdunt cdunt_destino ,
unt2.nmUNT dsp_nmunt ,
unt2.sgUNT dsp_sgunt ,
DECODE (unt2.idativaunt, 'S', 'Ativo', 'Inativo') dsp_ativo
from centro_custo_v unt2
where cdunt between 53200 and 53299
order by unt2.cdunt
select unt2.cdunt cdunt_destino ,
unt2.nmUNT dsp_nmunt ,
unt2.sgUNT dsp_sgunt ,
DECODE (unt2.idativaunt, 'S', 'Ativo', 'Inativo') dsp_ativo
from centro_custo_v unt2
where cdunt between 53200 and 53299
or(cdunt between 56650 and 56653)
order by unt2.cdunt
select unt3.cdunt cdunt_solicitacao ,
unt3.nmunt dsp_nmunt2 ,
unt3.sgunt dsp_sgunt2 ,
DECODE (unt3.idativaunt, 'S', 'Ativo', 'Inativo') dsp_ativo2
from centro_custo_v unt3
where (unt3.cdunt between 53000 and 53990)/*GMT*/
or (unt3.cdunt between 56600 and 56640)/*OPT*/
or (unt3.cdunt in (56700, 56701, 56710, 56730, 56740, 56750, 56760))/*OPT*/
or (unt3.cdunt between 56100 and 56120)/*OPC*/
or (unt3.cdunt between 11000 and 11990)/*MKI*/
or (unt3.cdunt between 75000 and 75990)/*GPS*/
or (unt3.cdunt between 37000 and 37990)/*GSA*/
or (unt3.cdunt = 43000 )/*GSA*/
or (unt3.cdunt between 32000 and 32990)/*GRH*/
or (unt3.cdunt = 56440 )/*CTV*/
or (unt3.cdunt = 12000 )/*GRH*/
or (unt3.cdunt = 16000 )/*GIT*/
or (unt3.cdunt = 14000 )/*GJU*/
or (unt3.cdunt = 11000 )/*GMK*/
or (unt3.cdunt = 13000 )/*GAD*/
or (unt3.cdunt = 36000 )/*GCP*/
or (unt3.cdunt = 47000 )/*GCP*/
or (unt3.cdunt = 87000 )/*GCC*/
or (unt3.cdunt = 84000 )/*GCC*/
or (unt3.cdunt = 88000 )/*GMO*/
or (unt3.cdunt = 86000 )/*GPC*/
or (unt3.cdunt = 74000 )/*GPE*/
or (unt3.cdunt = 76000 )/*GTC*/
or (unt3.cdunt = 45000 )/*GCT*/
or (unt3.cdunt = 46000 )/*GOC*/
or (unt3.cdunt = 41000 )/*GOF*/
or (unt3.cdunt = 39000 )/*GCN*/
or (unt3.cdunt = 44000 )/*GCN*/
or (unt3.cdunt = 10400 )/*DMK*/
or (unt3.cdunt = 70400 )/*DMK*/
or (unt3.cdunt = 10000 )/*PRESIDENCIA*/
or (unt3.cdunt in (44200,44210,44220,44100) )/*NKN-CVE-CGV*/
or (unt3.cdunt between 55000 and 55999)/*GLG*/
and unt3.idativaunt = 'S'
order by unt3.cdunt
sql apos a modificacao - lov solicitante
select unt3.cdunt cdunt_solicitacao ,
unt3.nmunt dsp_nmunt2 ,
unt3.sgunt dsp_sgunt2 ,
DECODE (unt3.idativaunt, 'S', 'Ativo', 'Inativo') dsp_ativo2
from centro_custo_v unt3
where (unt3.cdunt between 53000 and 53990)/*GMT*/
or (unt3.cdunt between 56600 and 56640)/*OPT*/
or (unt3.cdunt in (56700, 56701, 56710, 56730, 56740, 56750, 56760))/*OPT*/
or (unt3.cdunt between 56100 and 56120)/*OPC*/
or (unt3.cdunt between 11000 and 11990)/*MKI*/
or (unt3.cdunt between 75000 and 75990)/*GPS*/
or (unt3.cdunt between 37000 and 37990)/*GSA*/
or (unt3.cdunt = 43000 )/*GSA*/
or (unt3.cdunt between 32000 and 32990)/*GRH*/
or (unt3.cdunt = 56440 )/*CTV*/
or (unt3.cdunt = 12000 )/*GRH*/
or (unt3.cdunt = 16000 )/*GIT*/
or (unt3.cdunt = 14000 )/*GJU*/
or (unt3.cdunt = 11000 )/*GMK*/
or (unt3.cdunt = 13000 )/*GAD*/
or (unt3.cdunt = 36000 )/*GCP*/
or (unt3.cdunt = 47000 )/*GCP*/
or (unt3.cdunt = 87000 )/*GCC*/
or (unt3.cdunt = 84000 )/*GCC*/
or (unt3.cdunt = 88000 )/*GMO*/
or (unt3.cdunt = 86000 )/*GPC*/
or (unt3.cdunt = 74000 )/*GPE*/
or (unt3.cdunt = 76000 )/*GTC*/
or (unt3.cdunt = 45000 )/*GCT*/
or (unt3.cdunt = 46000 )/*GOC*/
or (unt3.cdunt = 41000 )/*GOF*/
or (unt3.cdunt = 39000 )/*GCN*/
or (unt3.cdunt = 44000 )/*GCN*/
or (unt3.cdunt = 10400 )/*DMK*/
or (unt3.cdunt = 70400 )/*DMK*/
or (unt3.cdunt = 10000 )/*PRESIDENCIA*/
or (unt3.cdunt in (44200,44210,44220,44100) )/*NKN-CVE-CGV*/
or (unt3.cdunt between 55000 and 55999)/*GLG*/
or (unt3.cdunt between 56650 and 56653)
and unt3.idativaunt = 'S'
order by unt3.cdunt
3) É OBRIGATORIAMENTE NESSA ORDEM QUE EU EXECUTO ESSES COMANDOS OU O ULTIMO não É NECESSARIO
A - CTRL+ K - COMPILAR FORM
B - CTRL + T - GERAR EXECUTAVEL
C - CTRL + R - EXECUTAR (É OBRIGATORIO? OU SOMENTE COM OS DOIS ACIMA ELE já CARREGA OS VALORES ALTERADOS NUMA LOV?)
AGUARDO UMA LUZ SE POSSIVEL
TENHAM PACIENCIA POR FAVOR ...IM A BEGGINER OK!
ABS
CARLOS