Forum Utilisateurs Oracle-JD Edwards

oracle.jdedwards · Site Admin Inscrit le: 15 Jan 2008 Messages: 68

Voici un exemple de requête :

select rpdoc, rpdct, rpkco, rpsfx, rpglc, rpan8, rpag, case rpdct when 'RU' then coalesce( SUM( RZPAAP + rzadsa + rzaaaJ + rzecba + rzdda + rzagl),rpag ) when 'R5' then rpaap else coalesce( rpag + SUM(RZPAAP + rzadsa + rzaaaJ + rzecba + rzdda + rzagl), rpag ) end AS RPPAAPfrom proddta.F03B11 left join proddta.F03B14 on ( rpdoc = rzdoc and rpdct = rzdct and rpkco = rzkco and rpsfx = rzsfx and ( rzdgj <= 108366 OR rzdgj is null ) ) where rpglc <> 'AC' and rpco = '00012' and rpdgj <= 108366 and rpan8=13709929 and rpddj<=108366group by rpdoc, rpdct, rpkco, rpsfx, rpglc, rpan8, rpag, rpaap having case rpdct when 'RU' then coalesce( SUM( RZPAAP + rzadsa + rzaaaJ + rzecba + rzdda + rzagl), rpag ) when 'R5' then RPAAP else coalesce(rpag + SUM( RZPAAP + rzadsa + rzaaaJ + rzecba + rzdda + rzagl), rpag ) end <> 0 for read only with ur;