ZDDS3 Les conditionnements

Par AMO

Code

select trim(a.cdcode) "Code", trim(b.liblon) "Libellé", trim (c.licon) "Texte"
from zd00 a, zd01 b, zddx c
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.cdregl = 'VPR'
and a.cdstco = 'DS3'
and a.cdcode = '&Code' ;

Liste

select a.cdregl, trim(a.cdcode) "Code", trim(b.liblon) "Libellé", trim (c.licon) "Texte"
from zd00 a, zd01 b, zddx c, zdef d
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.nudoss = d.nudoss
and a.cdstco = 'DS3' 
and d.dafin = to_date('31/12/2999','DD/MM/YYYY')
order by a.cdcode;

Liste avec EFC actifs

select a.cdregl, trim(a.cdcode) "Code", trim(b.liblon) "Libellé", trim (c.licon) "Texte"
from zd00 a, zd01 b, zddx c
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.nudoss in (select distinct(d.nudoss) from zdef d where d.dafin = to_date('31/12/2999','DD/MM/YYYY'))
and a.cdstco = 'DS3' 
order by a.cdcode;

Liste (Windows)

select a.CDREGL, rtrim(a.CDCODE) "Code", rtrim(b.LIBLON) "Libellé", rtrim (c.LICON) "Texte"
from HR.ZD00 a, HR.ZD01 b, HR.ZDDX c
where a.NUDOSS = b.NUDOSS
and a.NUDOSS = c.NUDOSS
and a.CDSTCO = 'DS3' 
order by a.CDCODE

Texte des conditionnements actifs

select a.cdregl, trim(a.cdcode) "Code", trim(b.liblon) "Libellé", trim (c.licon) "Texte"
from zd00 a, zd01 b, zddx c
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.nudoss in (select distinct(d.nudoss) from zdef d where d.dafin = to_date('31/12/2999','DD/MM/YYYY'))
and a.cdstco = 'DS3' 
order by a.cdcode;