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
| SELECT T4.CODE_DA CODE_DA
,T4.NO_TRX NO_TRX
,T4.NO_CLIEN NO_CLIEN
,T4.CODE_CLASS_CPTE_CLIEN CODE_CLASS_CPTE_CLIEN
,T4.DATE_SAISI DATE_SAISI
,T4.HMS HMS
,T4.DATE_COMPT DATE_COMPT
,T4.CODE_TYPE_TRX CODE_TYPE_TRX
,TYP_T4.DESCR_ABREG DESCR_ABREG
,T4.NO_NOTE_DT_CT_ENCAI CLE
,NDCE.TYPE_PAIEM TYPE_PAIEM
,NDCE.TYPE_CARTE TYP_CARTE
,DECODE(NDCE.NO_COMMA_COE, NULL,
DECODE(NDCE.NO_PREIM,NULL, 'Gén: '||NDCE.
NO_NOTE_DT_CT_ENCAI,NDCE.NO_PREIM)
, TO_CHAR(NDCE.NO_COMMA_COE)) NUMERO
,DECODE (TYP_T4.CODE_NATUR_CPTE_CLIEN,'C',T4.MNT_TOT*-1
,T4.MNT_TOT),
T4.SOLDE_CLIEN_APRES,
TYP_T4.CODE_NATUR_CPTE_CLIEN,
'REV92091',
'GLOBAL.REV92091_CODE_DA',
'GLOBAL.REV92091_NO_DT_CT_ENCA',
T4.AN_EXERC,
T4.CODE_PERIO,
T4.NO_UAR,
Null,
null,
NDCE.TYPE_CARTE, TYPE_CARTE,
NDCE.NO_COMMA_COE,
T4.CODE_UTILI
FROM REV_TYPE_TRX TYP_T4,
REV_NOTE_DT_CT_ENCAI NDCE,
REV_TRX T4
WHERE T4.CODE_TYPE_TRX NOT IN ('TRDC', 'TRDA', 'TRAC', 'TRAA', 'REMC', 'REMA',
'RADC', 'RADA', 'NDTC', 'NDTA', 'NCTC', 'NCTA',
'FACC', 'FACA', 'ERTC', 'ERTA', 'ENCC', 'ENCA',
'DEPC', 'DEPA', 'INTC')
AND TYP_T4.CODE_TYPE_TRX = T4.CODE_TYPE_TRX
AND NDCE.CODE_DA = T4.CODE_DA
AND NDCE.NO_NOTE_DT_CT_ENCAI = T4.NO_NOTE_DT_CT_ENCAI |
Partager