AP Terms Query -Oracle Fusion

The below Query will be handy for fetching AP terms.

SELECT A. TERM_ID, B.NAME,

TO_CHAR(TRUNC(A.START_DATE_ACTIVE), 'MM/DD/YYYY') "START_DATE_ACTIVE",

A.END_DATE_ACTIVE, A.ENABLED_FLAG

FROM AP_TERMS_B A, AP_TERMS_TL B

WHERE A.TERM_ID = B.TERM_ID

--AND A.ENABLED_FLAG = 'Y'

--AND A.END_DATE_ACTIVE IS NULL

ORDER BY B.NAME desc;