1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
|
SELECT
FFPENBEV.NUMBEV as "Numéro BEV",
FFPENBEV.DATBEV as "Date Du BEV",
FFPENBEV.NFOUFO as "N° fournisseur",
FFPENBEV.DACTFA as "Département activité",
FFPENBEV.MHTBEV as "Mnt H.T B.E.V",
FFPENBEV.NUMDOS as "N° dossier",
FFPENBEC.MHTBEV as "Mnt H.T B.E.V",
FFPENBEC.NUMDOS as "N° dossier",
DATDOS as "Date du dossier",
AUTDOS as "Auteur du dossier",
CCPRFA as "Chef produit",
FFPENBEV.AOPEEB as "Année opération",
FFPENBEV.NUMPRO as "NUMPRO",
FFPENBEV.CATPRO as "N° catalogue promo",
FFPENBEV.DEPOTL as "Dépot de livr.",
FFPENBEV.NUMOR as "Numéro O.R",
FFPENBEV.CODRLQ as "Code reliq. O,N",
FFPENBEV.COMOR1 as "COMOR1"
FROM DBLIB.FFPENBEV FFPENBEV,
DBLIB.FFPENBEC FFPENBEC,
DBLIB.FFPDOSSI FFPDOSSI,
DBLIB.DBFDEPL0 DBFDEPL0
WHERE FFPENBEV.NUMBEV = FFPENBEC.NUMBEV
AND FFPENBEC.NUMDOS = FFPDOSSI.NUMDOS
AND FFPENBEV.NFOUFO = DBFDEPL0.NFOUFA
AND FFPDOSSI.DACTFA = DBFDEPL0.DACTFA
AND DATDOS BETWEEN 120801 AND 120901
AND CCPRFA IN
(
'03',
'06',
'17',
'18',
'08',
'12',
'16',
'24',
'01',
'04',
'10',
'07',
'19',
'20',
'21'
)
AND FFPENBEV.MHTBEV > 0
ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9 |
Partager