FND Design Data [Home] [Help]

View: AP_TERMS_VAL_V

Product: AP - Payables
Description: (Release 10SC Only)
Implementation/DBA Data: ViewAPPS.AP_TERMS_VAL_V
View Text

SELECT AT.NAME NAME
, AT.DESCRIPTION DESCRIPTION
, AT.TERM_ID TERM_ID
FROM AP_TERMS AT
WHERE SYSDATE BETWEEN NVL(AT.START_DATE_ACTIVE
, SYSDATE - 1)
AND NVL(AT.END_DATE_ACTIVE
, SYSDATE + 1)

Columns

Name
NAME
DESCRIPTION
TERM_ID