sql_query

gistfile1.txt

SELECT concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) AS nop,
a.STATUS_PEMBAYARAN_SPPT AS st_lunas, b.SUBJEK_PAJAK_ID AS nik, c.NM_WP AS nama
FROM SPPT a, DAT_OBJEK_PAJAK b, DAT_SUBJEK_PAJAK c
WHERE concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) = concat(CONCAT(CONCAT(concat(CONCAT(concat(b.KD_PROPINSI, b.KD_DATI2), b.KD_KECAMATAN), b.KD_KELURAHAN), b.KD_BLOK), a.NO_URUT), b.KD_JNS_OP)
AND b.SUBJEK_PAJAK_ID=c.SUBJEK_PAJAK_ID
AND EXTRACT(YEAR FROM TO_DATE(a.TGL_TERBIT_SPPT, 'DD-MON-RR')) = 2018;