1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
select L.NUM_TOUR ,
L.NUM_LIG_TOUR ,
C.EMP EMP,
C.NUM_CONT NUM_CONT,
C.NUM_ART NUM_ART,
C.NUM_LOT NUM_LOT,
C.DLUO DLUO,
nvl(to_number(CR.NUM_ORDRE_PREP)+1, 1) COMPTAGE
from LIG_TOUR L, CONTENANT C, CR_STOCK CR
where L.NUM_LIG_TOUR = C.NUM_LIG_TOUR_INV
and L.TYP_TOUR = 'INV'
and L.TYP_REAL = 'PAPI'
and L.STYP_TOUR = 'ACON'
and L.ETAT_LIG_TOUR = 'LANC'
and CR.NUM_LIG_TOUR (+)= C.NUM_LIG_TOUR_INV
and CR.EMP (+)= C.EMP
and CR.NUM_CONT (+)= C.NUM_CONT
and ( CR.ETAT_CR_STOCK = 'ENCO' or
(CR.ETAT_CR_STOCK is null and CR.NUM_CR_STOCK is null)
)
order by 1, 2, 3, 4, 5; |
Partager