SQL Query to fetch the payment terms setups in Oracle cloud fusion

Here is the SQL Query to fetch the payment terms setups in Oracle cloud.


SELECT 'PAYMENT TERM' "SETUP_NAME",
          rt.name VALUE
  FROM ra_terms rt
 WHERE TRUNC (SYSDATE) BETWEEN NVL (start_date_active, TRUNC(SYSDATE) - 1)  AND NVL (end_date_active, TRUNC(SYSDATE) + 1) ;