tomlameche a écrit :
:heink: comment ça il ne connait pas rownum ???? Il t'as dit quoi oracle quand t'as essayé ? Quelle requete ?
|
il ma dit nom de colonne inconnu...
je reessaye g des pbs de test
voila la requete
select contrat.numcont_ct NUMCONT,
produit.refer_pr REFPROD,
contrat.prann_ct PRANN,
decode(mvt.cdpos_mvt,1,'En Cours',2,'Mis en Demeure',3,'Suspendu',4,'Résilié','Autre') POSITION
from entcontrat,contrat,tiersct,produit,ssmvt,mvt
where contrat.id_ct = tiersct.id_ct
and contrat.numali_ct = 0
and contrat.id_ect = entcontrat.id_ect
and contrat.cd_smv = ssmvt.cd_smv
and ssmvt.cd_mvt = mvt.cd_mvt
and contrat.cd_pr = produit.cd_pr
and tiersct.cd_tt = 'SO'
and numavt_ct = (select max(numavt_ct)
from contrat
where id_ect = entcontrat.id_ect
and dtef_ct <= to_date(:DS,'DDMMYYYY')
and dtcrec_ct <= to_date(:DS,'DDMMYYYY')
)
and nummvt_ct = (select max(c.nummvt_ct)
from contrat c
where c.id_ect = entcontrat.id_ect
and contrat.numavt_ct = c.numavt_ct
and c.dtef_ct <= to_date(:DS,'DDMMYYYY')
and dtcrec_ct <= to_date(:DS,'DDMMYYYY')
)
and contrat.numcont_ct = NVL(:NC,contrat.numcont_ct)
and 'true' = decode(:NS,'NOT NULL','false','true')
OR tiersct.id_ti = (select id_ti
from tiers
where num_ti= :NS
and cd_tt = 'AS'
and rownum < "2"
)