1 2 3 4 5 6 7 8
|
String requete = "SELECT TO_CHAR(DAT_DEBT,'DD/MM/YYYY HH24:MI:SS') AS DAT_DEBT, NUMR_APPELANT, DESC_CERC, CL.NOM AS NOM_APPELE, CL.PRNM AS PRENOM_APPELE, M.ADRS AS ADRS_APPELE, M.COD_POST AS CODPOST_APPELE, M.VILL AS VILL_APPELE, METH.VILL, METH.COD_POST, METH.ADRS, DUR," +
" DURT_FACT, MONT_FACT , OLD_COMM_BALN_CRDT, COMM_BALN_CRDT, "
+ " NUMR_APPELE, ESN_APPELANT, ESN_APPELE, DIRC_APPL, TYP_TRFC, IMSI_APPELANT,ICC_APPELANT, ICC_APPELE, PUK_APPELE, PUK_APPELANT, POS_APPELE, POS_APPELANT, DEAL_APPELE, DEAL_APPELANT, CLI.NOM, CLI.PRNM, D.PAYS_DEST AS PAYS_SOURCE , D.OPRT_DEST AS OPRT_SOURCE, O.PAYS_DEST AS PAYS_DEST , O.OPRT_DEST AS OPRT_DEST FROM TICKETS T LEFT OUTER JOIN OPRT_PAYS_DEST O ON T.ID_NUMR_TELP_DEST=O.ID_NUMR_TELP_DEST LEFT OUTER JOIN OPRT_PAYS_DEST D ON T.ID_NUMR_TELP_ORIG=D.ID_NUMR_TELP_DEST LEFT OUTER JOIN CLIENT CLI ON CLI.IDNT_CLNT=T.IDNT_CLNT_APPELANT LEFT OUTER JOIN CLIENT CL ON T.IDNT_CLNT_APPELE=CL.IDNT_CLNT LEFT OUTER JOIN CERCLE C ON T.IDNT_CERC_APPELANT=C.IDNT_CERC LEFT OUTER JOIN METHODE_CONTACT M ON T.IDNT_METH_CONT_APPELE=M.IDNT_METH_CONT LEFT OUTER JOIN METHODE_CONTACT METH ON T.IDNT_METH_CONT_APPELANT=METH.IDNT_METH_CONT WHERE DAT_DEBT>=TO_DATE('"+periodeDebut+"', 'DD/MM/YYYY HH24:MI:SS') AND DAT_DEBT<=TO_DATE('"+periodeFin+"', 'DD/MM/YYYY HH24:MI:SS')";
|
Partager