Advertisement
Guest User

Untitled

a guest
Oct 17th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. SELECT Kontakt,Status,Datum_DT,BeaId,TeilnehmerIds,Privat,Zweck,ID,ID_FI,Betreff,Endedatum_DT,Serie,ID_IB,ID_KM FROM CRM_MA WHERE LosKZ='00' AND (((((Endedatum_DT>=20170817220000000) OR (((Endedatum_DT>=20170816220000000 AND Endedatum_DT<20170817220000000)) AND ((MOD(Endedatum_DT,1000000000)>100000000 AND MOD(Endedatum_DT,1000000000)<=215900000)))) AND ((Datum_DT<20170817220000000) OR (((Datum_DT>=20170817220000000 AND Datum_DT<20170818220000000)) AND ((MOD(Datum_DT,1000000000)>=220000000 OR MOD(Datum_DT,1000000000)<220000000))))) OR (((Datum_DT>=20170817220000000) OR (((Datum_DT>=20170816220000000 AND Datum_DT<20170817220000000)) AND ((MOD(Datum_DT,1000000000)>100000000 AND MOD(Datum_DT,1000000000)<=215900000)))) AND ((Datum_DT<20170817220000000) OR (((Datum_DT>=20170817220000000 AND Datum_DT<20170818220000000)) AND ((MOD(Datum_DT,1000000000)>=220000000 OR MOD(Datum_DT,1000000000)<220000000)))) AND (Endedatum_DT<1000000000))) AND ((BeaId=102310) OR (UPPER(TeilnehmerIds) LIKE UPPER('%%102310%%')) OR (BeaId=102490) OR (UPPER(TeilnehmerIds) LIKE UPPER('%%102490%%')) OR (BeaId=103150) OR (UPPER(TeilnehmerIds) LIKE UPPER('%%103150%%')) OR (BeaId=106750) OR (UPPER(TeilnehmerIds) LIKE UPPER('%%106750%%')) OR (BeaId=107691) OR (UPPER(TeilnehmerIds) LIKE UPPER('%%107691%%')))) AND (MandNr IN(0,1,9000)) AND ((CRM_MA.ID_FI=0 OR (CRM_MA.ID_FI<>0 AND EXISTS(SELECT ID FROM CRM_FI WHERE CRM_MA.ID_FI=ID AND (CRM_FI.LosKZ='00' AND (CRM_FI.MandNr IN(0,1,9000)))))) AND (CRM_MA.ID_FI=0 OR (CRM_MA.ID_PE=0 OR EXISTS(SELECT ID FROM CRM_CPPE WHERE CRM_MA.ID_PE=ID_PE AND CRM_MA.ID_FI=ID_FI AND (CRM_CPPE.LosKZ='00' AND (CRM_CPPE.MandNr IN(0,1,9000)))))) AND (CRM_MA.ID_FI=0 OR CRM_MA.ID_PE=0 OR EXISTS(SELECT ID FROM CRM_CP WHERE CRM_MA.ID_PE=ID_PE AND CRM_MA.ID_FI=ID_FI AND (CRM_CP.LosKZ='00' AND (CRM_CP.MandNr IN(0,1,9000))))) AND (CRM_MA.ID_PE=0 OR EXISTS(SELECT ID FROM CRM_PE WHERE CRM_MA.ID_PE=ID AND (CRM_PE.LosKZ='00' AND (CRM_PE.MandNr IN(0,1,9000)))))) AND ROWNUM<5002
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement