DBA Data[Home] [Help]

VIEW: APPS.SO_PAYMENT_TERMS_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)