FND Design Data [Home] [Help]

View: SO_PAYMENT_TERMS_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.SO_PAYMENT_TERMS_V
View Text

SELECT NAME PAYMENT_TERM
, DESCRIPTION
, TERM_ID PAYMENT_TERM_ID
FROM RA_TERMS
WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)

Columns

Name
PAYMENT_TERM
DESCRIPTION
PAYMENT_TERM_ID