SELECT по выгрузке платежей из Журнала утверждения заявок

SELECT CLAIM.R_REQ_PAY_CORRECT_ID,
       CLAIM.R_PAYMENT_CORRECTED,
       TAX_PAYER_BEFORE.IIN_BIN,
       CORRECTED.NAME_TAX_PAYER,
       CORRECTED.DOCUMENT_NUMBER,
       CORRECTED.D_DOCUMENT_DATE,
       CORRECTED.KBK,
       CORRECTED.TAX_ORG_CODE,
       CORRECTED.AMOUNT_DOCUMENT,
       CORRECTED.D_RECEIPT_DATE,
       CLAIM.R_PAYMENT_CORRECTING,
       CORRECTING.IIN_BIN,
       CORRECTING.NAME_TAX_PAYER,
       CLAIM.CREATE_DATE,
       CLAIM.OPERATOR_CREATE
FROM R_REQ_PAY_CORRECT CLAIM
         JOIN R_PAYMENT CORRECTING ON (CLAIM.R_PAYMENT_CORRECTING = CORRECTING.R_PAYMENT_ID)
         JOIN R_PAYMENT CORRECTED ON (CLAIM.R_PAYMENT_CORRECTED = CORRECTED.R_PAYMENT_ID)
         LEFT JOIN R_TAX_PAYER TAX_PAYER ON (CORRECTING.R_TAX_PAYER_ID = TAX_PAYER.R_TAX_PAYER_ID)
         LEFT JOIN R_TAX_PAYER TAX_PAYER_BEFORE ON (CORRECTED.R_TAX_PAYER_ID = TAX_PAYER_BEFORE.R_TAX_PAYER_ID)
         LEFT JOIN V_TP_NAME_INFO TP_NAME ON (CORRECTING.R_TAX_PAYER_ID = TP_NAME.R_TAX_PAYER_ID)
WHERE TRUNC(TO_DATE('02.07.2013'), 'fmdd') <= TRUNC(CLAIM.CREATE_DATE, 'fmdd') -- <---- Дата заявки начало
  AND TRUNC(CLAIM.CREATE_DATE, 'fmdd') <= TRUNC(TO_DATE('30.09.2017'), 'fmdd') -- <---- Дата заявки конец
  AND CLAIM.R_REQ_PAY_CORRECT_STATUS IN (1)
  AND (NVL(CORRECTING.R_TAX_PAYER_ID, '-1') <> NVL(CORRECTED.R_TAX_PAYER_ID, '-1') OR
       NVL(CORRECTING.RNN, '-1') <> NVL(CORRECTED.RNN, '-1') OR
       NVL(CORRECTING.IIN_BIN, '-1') <> NVL(CORRECTED.IIN_BIN, '-1') OR
       NVL(CORRECTING.NAME_TAX_PAYER, '-1') <> NVL(CORRECTED.NAME_TAX_PAYER, '-1') OR
       CORRECTING.D_WRITE_OFF_DATE <> CORRECTED.D_WRITE_OFF_DATE OR
       NVL(CORRECTING.VIN_CODE, '-1') <> NVL(CORRECTED.VIN_CODE, '-1') OR
       NVL(CORRECTING.M_PAYMENT_DOC_TYPE_ID, '-1') <> NVL(CORRECTED.M_PAYMENT_DOC_TYPE_ID, '-1') OR
       NVL(CORRECTING.M_ASSIGNMENT_PAYMENT_ID, '-1') <> NVL(CORRECTED.M_ASSIGNMENT_PAYMENT_ID, '-1'))
  AND ROWNUM <= 101
ORDER BY CLAIM.CREATE_DATE;