1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
select T1."KSTAGE", T1."ASTAGEL", T1."KSESSION", T1."ASESSIONC", T1."KUOGES", T1."AUOGESC",
T1."AETATSESC", T1."DDEBSES", T1."DFINSES", T1."QHRESES", T1."QSMAXSES"-T1."QSINSSES", T1."QSINSSES",
T1."QSATTSES", T2."AORGL", T3."AASSUR", T4."NMAT", T4."ANOM", T4."KSEXE", T5."KMESSAG", T5."ALACC",
T5."ALIEUC", T4."KUOSAL", T4."AENTITEC", T6."KUO4", T6."AUOC4", T6."KUO3", T6."AUOC3", T4."KCLASS", T4."ACLASSC",
T4."KMETRATP", T4."AMETRATPC", T4."KPLAN", T4."EINEXSAL", T4."AETINSSESC", T4."DETINSSES", T4."QDURPRES", T4."IDPFS",
T4."IDIDFS", T4."IDDDS", T4."AFRATPC", T4."KOBJDEP", T4."AOBJDEP", T4."AOBJFIN", T4."AIMFS", T4."KPOINTA", T4."ECCNV",
T4."KDEMANDE", T4."ADEMANDEC", T4."DDEMANDE", T4."NMATID", T4."DVDFSES", T7."ATYPCOUC", T7."DEFFCOU", T7."QMONENGA", T7."KTYPCOU",
T7."QMONBRUT", T1."KETATSES", T7."NVENTIL", T7."NIMPUTA", T4."IDSTR"
from "INFO"."FASSUR" T3, "INFO"."V_UOGES_CSPENT" T8, "INFO"."V_UOSAL_CSPENT" T9, "FSESSION" T1, "FORGSESS" T2,
"FPARSESS" T4, "INFO"."FAGENTS" T5, "TUOH" T6, "FCOUSAL" T7
where T1."KSESSION"=T2."KSESSION"(+) and T1."KSTAGE"=T2."KSTAGE"(+) and T1."KSESSION"=T4."KSESSION"(+) and T1."KSTAGE"=T4."KSTAGE"(+)
and T4."KSOC"=T5."KSOC"(+) and T4."NMAT"=T5."NMAT"(+) and T4."KUOSAL"=T6."KUO"(+) and T4."KSESSION"=T7."KSESSION" and T4."KSTAGE"=T7."KSTAGE"
and T4."NMAT"=T7."NMAT" and T1."EASSUR"=T3."EASSUR" and T1."KUOGES"=T8."KUOGES" and T4."KUOSAL"=T9."KUOSAL"
and T1."DDEBSES">=to_date('1930-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and T1."DFINSES"<=to_date('2999-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
and T1."KSTAGE" like '%' and T8."APERIMCSP"='CSP' and T9."APERIMCSP"='CSP'
order by T1."KUOGES" asc, T1."KSTAGE" asc, T1."KSESSION" asc |
Partager