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
|
1 SELECT decode(F.fatype, 'F','Fa','A','Av') "Type Fact",
2 lpad(F.fadrec,9,' ') "Date Recep",
3 F.fanfac "Num Fact",
4 nvl(F.famtht,0)-nvl(F.faremi,0)+nvl(F.fatva,0) "Mt TTC",
5 F.factier "Num Fo/Tiers",
6 CASE WHEN F.Fattier = "F"
7 THEN (Select T.fnfo from kfourni T where F.factier=T.fcfo)
8 ELSE (Select Ti.tinom from ktiers Ti where F.factier=Ti.ticod)
9 END as "Four/Tiers",
10 F.fanoeng "NumEng",
11 F.enexe "ExeEngt",
12 decode(F.faceo,'B','BT','O','OS','C','Cde') "TE",
13 C.dest "Dest",
14 KENG.Pecodop "Nom"
15 FROM ksaifac F, ksbsuifa C,
16 (select Pecodop, enno, enexe
17 from KPERSONL K, KVENG ENG
18 where ENG.PEC=K.PEC) KENG
19 WHERE (F.faexe=C.faexe)
20 AND (F.fanfac=C.fanfac)
21 AND (F.fatype=C.fatype)
22 AND (F.fanoeng=KENG.ENNO(+)) AND (F.ENEXE=KENG.ENEXE(+))
23 AND (F.valid is null)
24 AND (C.dest like UPPER('%&&PARAM1%'))
25 AND (F.fadrec >= DECODE('&&PARAM2',null,'01-JAN-00','&&PARAM2'))
26 AND (C.rowid=(SELECT min(C2.rowid)
27 FROM ksbsuifa C2
28 WHERE C.fanfac=C2.fanfac))
29* ORDER BY F.fadrec
CASE WHEN F.Fattier = "F"
*
ERROR à la ligne 6 :
ORA-00904: Nom de colonne non valide |
Partager