FND Design Data [Home] [Help]

View: AP_TERMS_BAT_PAY_TERMS_V

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

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

Columns

Name
TERMS
DESCRIPTION
TERM_ID