VIEW: APPS.OKL_PAY_TERMS_UV

Source

View Text - Preformatted

SELECT APT.TERM_ID TERM_ID , APT.NAME TERMS, apt.description FROM AP_TERMS_V APT WHERE enabled_flag = 'Y' and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate)) order by terms

View Text - HTML Formatted

SELECT APT.TERM_ID TERM_ID
, APT.NAME TERMS
, APT.DESCRIPTION
FROM AP_TERMS_V APT
WHERE ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE)) ORDER BY TERMS