FND Design Data [Home] [Help]

View: OKL_PAY_TERMS_UV

Product: OKL - Leasing and Finance Management
Description: View for list of values of Funding request Payment Terms
Implementation/DBA Data: ViewAPPS.OKL_PAY_TERMS_UV
View Text

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

Columns

Name
TERM_ID
TERMS
DESCRIPTION