okelah

SELECT
    CASE WHEN ONUS.MERCHANT_ID IS NULL THEN OFUS.MERCHANT_ID
        ELSE ONUS.MERCHANT_ID
        END AS MERCHANT_ID
    CASE WHEN ONUS.MERCHANT_NAME IS NULL THEN OFUS.MERCHANT_NAME
        ELSE ONUS.MERCHANT_NAME
        END AS MERCHANT_NAME
    , ONUS.JUMLAH_TRANSAKSI_ON_US
    , ONUS.AMOUNT_TRANSAKSI_ON_US
    , ONUS.MDR_ON_US
    , ONUS.MDR_TYPE_ON_US
    , OFUS.JUMLAH_TRANSAKSI_ON_US
    , OFUS.AMOUNT_TRANSAKSI_ON_US
    , OFUS.MDR_ON_US
    , OFUS.MDR_TYPE_ON_US
FROM
(
    SELECT A.MERCHANT_ID, A.MERCHANT_NAME,
        COUNT(1) AS JUMLAH_TRANSAKSI_ON_US,
        SUM(A.AMOUNT) AS AMOUNT_TRANSAKSI_ON_US,
        A.MDR AS MDR_ON_US,
        A.MDR_TYPE  AS MDR_TYPE_ON_US
    FROM LOG_REPORT A
    WHERE  A.KODE_ISSUER  = A.KODE_ACQUIRER
        AND A.KODE_ACQUIRER = '000987'
        AND A.INSTITUTION_ID = '000987'
        AND TO_CHAR(A.SETTLEMENT_TIMESTAMP, 'dd-mm-yyyy') = '08-03-2017'
    GROUP BY A.MERCHANT_ID, A.MERCHANT_NAME , A.MDR_TYPE
) ONUS
OUTER JOIN
(
    SELECT A.MERCHANT_ID, A.MERCHANT_NAME,
        COUNT(1) AS JUMLAH_TRANSAKSI_OFF_US,
        SUM(B.AMOUNT) AS AMOUNT_TRANSAKSI_OFF_US,
        B.MDR AS MDR_OFF_US,
        B.MDR_TYPE  AS MDR_TYPE_OFF_US
    FROM LOG_REPORT B
    WHERE  B.KODE_ISSUER  <> A.KODE_ACQUIRER
        AND B.KODE_ACQUIRER = '000987'
        AND B.INSTITUTION_ID = '000987'
        AND TO_CHAR(B.SETTLEMENT_TIMESTAMP, 'dd-mm-yyyy') = '08-03-2017'
    GROUP BY B.MERCHANT_ID, B.MERCHANT_NAME , B.MDR_TYPE
) OFUS
ON ONUS.KODE_ISSUER   = OFUS.KODE_ISSUER
    AND ONUS.INSTITUTION_ID  = OFUS.INSTITUTION_ID