FROM TRANSACTIONS T, ADDRESSES AD, ACCOUNT_ACTIVITIES AA
WHERE T.SOFT_CREDIT_TYPE IS NULL
AND T.STS <> 'D'
AND (T.ACCOUNT_ID = AD.ACCOUNT_ID(+) AND T.ADDRESS_ID = AD.ADDRESS_ID(+))
AND (T.ACCOUNT_ID = AA.ACCOUNT_ID(+) AND T.ACTIVITY_TYPE = AA.ACTIVITY_TYPE(+))
AND AD.PREFERRED_ADDRESS(+) = 'Y'
AND ((T.GIFT_DATE BETWEEN TO_DATE('01-DEC-17', 'DD-MON-RR') AND
TO_DATE('31-DEC-17 23:59:59', 'DD-MON-RR HH24:MI:SS')))
GROUP BY AD.STATE
ORDER BY AD.STATE;
In this example, the following fields/parameters were used in the Report job that constructed the query:
Date Column: Gift Date
Date - Range Start: 12/01/17
Date - Range End: 12/31/17
Payments or Pledges: PY
Break Group 1: State