1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT QUAI_NUM,
PCH_EXP,
PCH_MAG,
MAG_NOM,
PCH_CODE,
(SELECT COUNT(1) FROM BAC WHERE BAC_PCHC = PCH_CODE) NB_BAC,
NVL((SELECT SUM(CP_QTEC) FROM CP WHERE CP_PCHC = PCH_CODE),0) NB_CC,
NVL((SELECT COUNT(1) FROM CA WHERE CA_PCHC = PCH_CODE),0) NB_CA,
NVL((SELECT COUNT(1) FROM CS WHERE CS_PCHC = CS_CODE),0) NB_CS,
TO_CHAR(PCH_DATE,'DD/MM/YY')
DATE_PREP,
//résultat de la requete précédente greffé ici,
MAG_VAGUEM VAG
FROM PCH, MAGASIN, QUAI
WHERE PCH_ETAT = 20
AND PCH_MAG = MAG_CODE
AND MAG_QUAI = QUAI_CODE
AND TRUNC(PCH_DATE)<trunc(sysdate)
AND MAG_VAGUEM IN (1,2,3,4)
AND MAG_ADR1 != 'DEBORD'
ORDER BY VAG,DATE_PREP,QUAI_NUM,PCH_MAG,PCH_CODE |
Partager