View: OE_FRGHT_TERMS_ACTIVE_V

Product:	ONT - Order Management
Description:	This view is used for freight terms.
Implementation/DBA Data:	APPS.OE_FRGHT_TERMS_ACTIVE_V

View Text

SELECT MEANING FREIGHT_TERMS
, LOOKUP_CODE FREIGHT_TERMS_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, DESCRIPTION
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'FREIGHT_TERMS'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns