fork download 
  1. select
  2. c.DETAYID,
  3. CASE
  4.    WHEN harekettevar is not null THEN 'DOVIZ'
  5.    WHEN fiktifdevar is not null THEN 'FIKTIF'
  6.    ELSE null  END AS DABTIPI,
  7.    CASE
  8.    WHEN harekettevar is not null THEN (select h.alissatisno from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24 ) and rownum=1 AND ISTATISTIKKODU IN
  9. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  10.    WHEN fiktifdevar is not null THEN (select f.alissatisno from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  11.    ELSE null END AS alissatisno,
  12.       CASE
  13.    WHEN harekettevar is not null THEN (select h.musterino from dvz_hareket h where h.transactionobjectid = c.trxnum  and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  14. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  15.    WHEN fiktifdevar is not null THEN (select f.musterino from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  16.    ELSE null END AS musterino,
  17.        CASE
  18.    WHEN harekettevar is not null THEN (select h.transactioncode from dvz_hareket h where h.transactionobjectid = c.trxnum  and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  19. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  20.    WHEN fiktifdevar is not null THEN (select f.TRANSACTIONCODE from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  21.    ELSE null END AS transactioncode,
  22.        CASE
  23.    WHEN harekettevar is not null THEN (select h.islemtarihi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24)  and rownum=1 AND ISTATISTIKKODU IN
  24. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  25.    WHEN fiktifdevar is not null THEN (select f.islemtarihi from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  26.    ELSE recorddate END AS islemtarihi,
  27.      CASE
  28.    WHEN harekettevar is not null THEN (select h.DOVIZISLEMTIPI from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  29. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  30.    WHEN fiktifdevar is not null THEN (select f.DOVIZISLEMTIPI from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  31.    ELSE null END AS dovizislemtipi,
  32.       CASE
  33.    WHEN harekettevar is not null THEN (select h.KURTIPI from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  34. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  35.    ELSE null END AS kurtipi,
  36.        CASE
  37.    WHEN harekettevar is not null THEN (select h.KURBULTENNO from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  38. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  39.    ELSE null END AS kurbultenno,
  40.   CASE
  41.    WHEN harekettevar is not null THEN (select h.KURBULTENTARIHI from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  42. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  43.    ELSE null END AS kurbultentarihi ,
  44.    dovizcinsi as kaynakdovizcinsi,
  45.    tutar  as kaynaktutar,
  46.        CASE
  47.    WHEN harekettevar is not null THEN (select h.kaynakislemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  48. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  49.    ELSE null END AS kaynakislemkuru,
  50.      CASE
  51.    WHEN harekettevar is not null THEN (select h.kaynaksistemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  52. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  53.    ELSE null END AS kaynaksistemkuru,
  54.       CASE
  55.    WHEN harekettevar is not null THEN (select h.kaynakdovizefektifkodu from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  56. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  57.    WHEN fiktifdevar is not null THEN (select f.kaynakdovizefektifkodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  58.    ELSE null END AS kaynakdovizefektifkodu,
  59.      CASE
  60.    WHEN harekettevar is not null THEN (select h.hedefdovizcinsi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  61. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  62.    WHEN fiktifdevar is not null THEN (select f.hedefdovizcinsi from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  63.    ELSE null END AS hedefdovizcinsi,
  64.     CASE
  65.    WHEN harekettevar is not null THEN TRUNC(tutar * (select h.kaynakislemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  66. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay')),2)
  67.    WHEN fiktifdevar is not null THEN tutar
  68.    ELSE null END AS hedeftutar,
  69.       CASE
  70.    WHEN harekettevar is not null THEN (select h.hedefislemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  71. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  72.    ELSE null END AS hedefislemkuru,
  73.      CASE
  74.    WHEN harekettevar is not null THEN (select h.hedefsistemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  75. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  76.    ELSE null END AS hedefsistemkuru,
  77.       CASE
  78.    WHEN harekettevar is not null THEN (select h.hedefdovizefektifkodu from dvz_hareket h where h.transactionobjectid =c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  79. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  80.    WHEN fiktifdevar is not null THEN (select f.hedefdovizefektifkodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  81.    ELSE null END AS hedefdovizefektifkodu,
  82.         CASE
  83.    WHEN harekettevar is not null THEN (select h.sistemparitesi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  84. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  85.    ELSE null END AS sistemparitesi,
  86.       CASE
  87.    WHEN harekettevar is not null THEN (select h.islemparitesi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  88. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  89.    ELSE null END AS islemparitesi,
  90.       CASE
  91.    WHEN harekettevar is not null THEN TRUNC(tutar * (select h.kaynakislemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  92. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay')),2)
  93.    WHEN fiktifdevar is not null THEN tutar
  94.    ELSE null END AS kaynaktltutari,
  95.       CASE
  96.    WHEN harekettevar is not null THEN TRUNC(tutar * (select h.kaynakislemkuru from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  97. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay')),2)
  98.    WHEN fiktifdevar is not null THEN tutar
  99.    ELSE null END AS hedeftltutari,
  100.       CASE
  101.    WHEN harekettevar is not null THEN (select h.karzarartutari from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  102. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  103.    ELSE null END AS karzarartutari,
  104.       CASE
  105.    WHEN harekettevar is not null THEN (select h.hareketaciklamasi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  106. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  107.    WHEN fiktifdevar is not null THEN (select f.hareketaciklamasi from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  108.    ELSE null END AS hareketaciklamasi,
  109.       CASE
  110.    WHEN harekettevar is not null THEN (select h.yetkinumarasi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  111. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  112.    ELSE null END AS yetkinumarasi,
  113.       CASE
  114.    WHEN harekettevar is not null THEN (select h.kullanicikodu from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  115. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  116.    WHEN fiktifdevar is not null THEN (select f.kullanicikodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  117.    ELSE null END AS kullanicikodu,
  118.       CASE
  119.    WHEN harekettevar is not null THEN (select h.subekodu from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  120. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  121.    WHEN fiktifdevar is not null THEN (select f.subekodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  122.    ELSE null END AS subekodu,
  123.       CASE
  124.    WHEN harekettevar is not null THEN (select h.kanalkodu from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  125. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  126.    WHEN fiktifdevar is not null THEN (select f.kanalkodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  127.    ELSE null END AS kanalkodu,
  128.   c.trxnum    AS transactionobjectid,
  129.   c.istatistikkodu         AS istatistikkodu,
  130.    CASE
  131.    WHEN harekettevar is not null THEN (select h.istatistikkodu2 from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  132. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  133.    WHEN fiktifdevar is not null THEN (select f.istatistikkodu2 from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  134.    ELSE null END AS istatistikkodu2,
  135.       CASE
  136.    WHEN harekettevar is not null THEN (select h.adsoyadunvan from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  137. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  138.    WHEN fiktifdevar is not null THEN (select f.adsoyadunvan from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  139.    ELSE null END AS adsoyadunvan,
  140.       CASE
  141.    WHEN harekettevar is not null THEN (select h.tcknvkn from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  142. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  143.    WHEN fiktifdevar is not null THEN (select f.tcknvkn from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  144.    ELSE null END AS tcknvkn,
  145.       CASE
  146.    WHEN harekettevar is not null THEN (select h.uyruk from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  147. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  148.    WHEN fiktifdevar is not null THEN (select f.uyruk from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  149.    ELSE null END AS uyruk,
  150.      CASE
  151.    WHEN harekettevar is not null THEN (select h.adres from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  152. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  153.    WHEN fiktifdevar is not null THEN (select f.adres from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  154.    ELSE null END AS adres,
  155. CASE
  156.    WHEN harekettevar is not null THEN (select h.iptalkodu from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  157. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  158.    WHEN fiktifdevar is not null THEN (select f.iptalkodu from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  159.    ELSE null END AS iptalkodu,
  160. CASE
  161.    WHEN harekettevar is not null THEN 'v'
  162.    WHEN fiktifdevar is not null THEN 'h'
  163.    ELSE null END AS hostvit,
  164.      CASE
  165.    WHEN harekettevar is not null THEN (select h.makasmarji from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  166. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  167.    ELSE null END AS makasmarji,
  168. CASE
  169.    WHEN harekettevar is not null THEN (select h.IPTALTRANSACTIONOBJECTID from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  170. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  171.    WHEN fiktifdevar is not null THEN (select f.IPTALTRANSACTIONOBJECTID from dvz_fiktifhareket f where f.transactionobjectid = c.trxnum and f.transactioncode='DITTLDAB' and rownum=1)
  172.    ELSE null END AS IPTALTRANSACTIONOBJECTID,
  173. CASE
  174.    WHEN harekettevar is not null THEN (select h.kurunalindigitarih from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  175. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  176.    ELSE null END AS kurunalindigitarih,
  177.       CASE
  178.    WHEN harekettevar is not null THEN (select h.pozisyonizlemekurtipi from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  179. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  180.    ELSE null END AS pozisyonizlemekurtipi,
  181. CASE
  182.    WHEN harekettevar is not null THEN (select h.MUHASEBESELKUR from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  183. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  184.    ELSE null END AS MUHASEBESELKUR,
  185. CASE
  186.    WHEN harekettevar is not null THEN (select h.MUHASEBETARIHI from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  187. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  188.    ELSE null END AS MUHASEBETARIHI,
  189. CASE
  190.    WHEN harekettevar is not null THEN (select h.MAKASDOKUMANTUTARI from dvz_hareket h where h.transactionobjectid = c.trxnum and h.dovizislemtipi=1  AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24) and rownum=1 AND ISTATISTIKKODU IN
  191. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay'))
  192.    ELSE null END AS MAKASDOKUMANTUTARI,
  193.   c.dabmusterino,
  194.   c.dabdurumkodu,
  195.   c.recorddate,
  196.   c.recordusercode,
  197.   c.recordbranchcode,
  198.   c.recordscreencode,
  199.   c.recordrequestobjectid,
  200.   c.recordchannelcode,
  201.   c.digermusteri,
  202.   c. ISLEMAMACI,
  203.   c.TCMBDABUSDKARSILIK,
  204.   c.ISLEMAMACIUYRUK
  205.  
  206. from (
  207. SELECT
  208. h.transactionobjectid as harekettevar,
  209. f.transactionobjectid as fiktifdevar,
  210. h.alissatisno as h_alissatisno,
  211. f.alissatisno as f_alissatisno,
  212.  
  213. x.transactionobjectidnum as trxnum,
  214. x.istatistikkodu as istatistikkodu,
  215. x.tutar as tutar,
  216. x.dovizcinsi,
  217.   DETAYID as DETAYID,
  218.  
  219.   x.musterino             as dabmusterino,
  220.   x.DURUMKODU             AS dabdurumkodu,
  221.   x.recorddate             AS recorddate,
  222.   x.recordusercode         AS recordusercode,
  223.   x.recordbranchcode       AS recordbranchcode,
  224.   x.recordscreencode       AS recordscreencode,
  225.   x.recordrequestobjectid  AS recordrequestobjectid,
  226.   x.recordchannelcode      AS recordchannelcode,
  227.   null AS digermusteri,
  228.   null                   AS ISLEMAMACI,
  229.   null                   as TCMBDABUSDKARSILIK,
  230.   null                   as ISLEMAMACIUYRUK
  231. from vitprod.dvz_dabhareket x  
  232. left join vitprod.dvz_hareket h on h.transactionobjectid = x.transactionobjectidnum
  233. and  h.dovizislemtipi=1 AND NOT (TRANSACTIONCODE='DVZMAKAS' AND KURTIPI=24 ) and rownum=1 
  234. AND x.ISTATISTIKKODU IN
  235. (select R.DESCRIPTION from VITPROD.PAR_V_PARAMETER R where groupcode = 'DVZIstatikKodDetay')
  236.  
  237. left join vitprod.dvz_fiktifhareket f on f.transactionobjectid = x.transactionobjectidnum
  238. and  f.transactioncode='DITTLDAB' and rownum=1
  239. where x.durumkodu=1)  c
  240.  
  241.  
  242. union all
  243. SELECT
  244.   null                   AS DETAYID,
  245.    'FIKTIF'              AS DABTIPI,
  246.   alissatisno            AS alissatisno,
  247.   musterino              AS musterino,
  248.   transactioncode        AS transactioncode,
  249.   islemtarihi            AS islemtarihi,
  250.   dovizislemtipi         AS dovizislemtipi,
  251.   null                   AS kurtipi,
  252.   null                   AS kurbultenno,
  253.   null                   AS kurbultentarihi,
  254.   kaynakdovizcinsi       AS kaynakdovizcinsi,
  255.   kaynaktutar            AS kaynaktutar,
  256.   null                   AS kaynakislemkuru,
  257.   null                   AS kaynaksistemkuru,
  258.   kaynakdovizefektifkodu AS kaynakdovizefektifkodu,
  259.   hedefdovizcinsi        AS hedefdovizcinsi,
  260.   hedeftutar             AS hedeftutar,
  261.   null                   AS hedefislemkuru,
  262.   null                   AS hedefsistemkuru,
  263.   hedefdovizefektifkodu  AS hedefdovizefektifkodu,
  264.   null                   AS sistemparitesi,
  265.   null                   AS islemparitesi,
  266.   kaynaktltutari         AS kaynaktltutari,
  267.   hedeftltutari          AS hedeftltutari,
  268.   null                   AS karzarartutari,
  269.   hareketaciklamasi      AS hareketaciklamasi,
  270.   null                   AS yetkinumarasi,
  271.   kullanicikodu          AS kullanicikodu,
  272.   subekodu               AS subekodu,
  273.   kanalkodu              AS kanalkodu,
  274.   transactionobjectid    AS transactionobjectid,
  275.   istatistikkodu         AS istatistikkodu,
  276.   istatistikkodu2        AS istatistikkodu2,
  277.   adsoyadunvan           AS adsoyadunvan,
  278.   tcknvkn                AS tcknvkn,
  279.   uyruk                  AS uyruk,
  280.   adres                  AS adres,
  281.   iptalkodu              AS iptalkodu,
  282.   'h'                    AS hostvit,
  283.   null                   AS makasmarji,
  284.   IPTALTRANSACTIONOBJECTID as IPTALTRANSACTIONOBJECTID,
  285.   null                   as kurunalindigitarih,
  286.   null                   as pozisyonizlemekurtipi,
  287.   null                   as MUHASEBESELKUR,
  288.   null                   as MUHASEBETARIHI,
  289.   null                   AS MAKASDOKUMANTUTARI,
  290.   dabmusterino           as dabmusterino,
  291.    CASE
  292.    WHEN dabdurumkodu is null THEN
  293.     1
  294.    ELSE
  295.     dabdurumkodu
  296.   END AS dabdurumkodu,
  297.   recorddate             AS recorddate,
  298.   recordusercode         AS recordusercode,
  299.   recordbranchcode       AS recordbranchcode,
  300.   recordscreencode       AS recordscreencode,
  301.   recordrequestobjectid  AS recordrequestobjectid,
  302.   recordchannelcode      AS recordchannelcode,
  303.   (select min(fk.musterino) from DVZ_FIKTIFHAREKET fk where fk.transactionobjectid = DVZ_FIKTIFHAREKET.transactionobjectid and fk.musterino <> DVZ_FIKTIFHAREKET.musterino) AS digermusteri,
  304.   null                   AS ISLEMAMACI,
  305.   null                   as TCMBDABUSDKARSILIK,
  306.   null                   as ISLEMAMACIUYRUK
  307. FROM DVZ_FIKTIFHAREKET  where dabdurumkodu=1 or dabdurumkodu is null
  308. UNION ALL
  309. SELECT
  310.   null                   AS DETAYID,
  311.    'DOVIZ'                 AS DABTIPI,
  312.   alissatisno            AS alissatisno,
  313.   musterino              AS musterino,
  314.   transactioncode        AS transactioncode,
  315.   islemtarihi            AS islemtarihi,
  316.   dovizislemtipi         AS dovizislemtipi,
  317.   kurtipi                AS kurtipi,
  318.   kurbultenno            AS kurbultenno,
  319.   kurbultentarihi        AS kurbultentarihi,
  320.   kaynakdovizcinsi       AS kaynakdovizcinsi,
  321.   kaynaktutar            AS kaynaktutar,
  322.   kaynakislemkuru        AS kaynakislemkuru,
  323.   kaynaksistemkuru       AS kaynaksistemkuru,
  324.   kaynakdovizefektifkodu AS kaynakdovizefektifkodu,
  325.   hedefdovizcinsi        AS hedefdovizcinsi,
  326.   hedeftutar             AS hedeftutar,
  327.   hedefislemkuru         AS hedefislemkuru,
  328.   hedefsistemkuru        AS hedefsistemkuru,
  329.   hedefdovizefektifkodu  AS hedefdovizefektifkodu,
  330.   sistemparitesi         AS sistemparitesi,
  331.   islemparitesi          AS islemparitesi,
  332.   kaynaktltutari         AS kaynaktltutari,
  333.   hedeftltutari          AS hedeftltutari,
  334.   karzarartutari         AS karzarartutari,
  335.   hareketaciklamasi      AS hareketaciklamasi,
  336.   yetkinumarasi          AS yetkinumarasi,
  337.   kullanicikodu          AS kullanicikodu,
  338.   subekodu               AS subekodu,
  339.   kanalkodu              AS kanalkodu,
  340.   transactionobjectid    AS transactionobjectid,
  341.   istatistikkodu         AS istatistikkodu,
  342.   istatistikkodu2        AS istatistikkodu2,
  343.   adsoyadunvan           AS adsoyadunvan,
  344.   tcknvkn                AS tcknvkn,
  345.   uyruk                  AS uyruk,
  346.   adres                  AS adres,
  347.   iptalkodu              AS iptalkodu,
  348.   'v'                      AS hostvit,
  349.   makasmarji             AS makasmarji,
  350.   IPTALTRANSACTIONOBJECTID as IPTALTRANSACTIONOBJECTID,
  351.   kurunalindigitarih     as kurunalindigitarih,
  352.   pozisyonizlemekurtipi as pozisyonizlemekurtipi,
  353.   MUHASEBESELKUR        as MUHASEBESELKUR,
  354.   MUHASEBETARIHI        AS MUHASEBETARIHI,
  355.   MAKASDOKUMANTUTARI    AS MAKASDOKUMANTUTARI,
  356.   dabmusterino          as dabmusterino,
  357.    CASE
  358.    WHEN dabdurumkodu is null THEN
  359.     1
  360.    ELSE
  361.     dabdurumkodu
  362.   END AS dabdurumkodu,
  363.   recorddate             AS recorddate,
  364.   recordusercode         AS recordusercode,
  365.   recordbranchcode       AS recordbranchcode,
  366.   recordscreencode       AS recordscreencode,
  367.   recordrequestobjectid  AS recordrequestobjectid,
  368.   recordchannelcode      AS recordchannelcode,
  369.   null AS digermusteri,
  370.   ISLEMAMACI             AS ISLEMAMACI,
  371.   TCMBDABUSDKARSILIK     as TCMBDABUSDKARSILIK,
  372.   ISLEMAMACIUYRUK        as ISLEMAMACIUYRUK
  373. FROM DVZ_HAREKET where dabdurumkodu=1 or dabdurumkodu is null;
Success #stdin #stdout #stderr 0.01s 5300KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
Error: near line 1: no such table: DVZ_HAREKET
https://ideone.com/PGNboX
language:
SQLite (sqlite 3.27.2)
created:
2 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!