vaidasi_migrate_kas_bon

WITH duplicate_data AS (
        SELECT A.ou_code, A.doc_no, A.doc_date
        FROM temp_migarate_kas_bon_karyawan A
        GROUP BY A.ou_code, A.doc_no, A.doc_date
        HAVING COUNT(1) > 1
    )
SELECT pSessionId, A.ou_code, A.partner_code, A.doc_no, A.doc_date, A.remark, A.amount
    FROM temp_migarate_kas_bon_karyawan A
    WHERE doc_no <> '' AND doc_date <> '' AND partner_code <> ''
    AND A.amount > 0
    AND NOT EXISTS (
      SELECT 1 FROM cb_payment_order B WHERE A.doc_no = B.doc_no AND A.doc_date = B.doc_date
    ) AND EXISTS (
      SELECT 1 FROM m_partner C WHERE A.partner_code = C.partner_code AND C.tenant_id = pTenantId
    ) AND EXISTS (
      SELECT 1 FROM t_ou D WHERE A.ou_code = D.ou_code AND D.tenant_id = pTenantId
    ) AND NOT EXISTS (
    SELECT 1 FROM duplicate_data E
    WHERE A.ou_code = E.ou_code AND A.doc_no = E.ou_code AND LEFT(A.doc_date, 6) = LEFT(E.doc_date, 6)
    );