View: OE_DEMAND_CLASSES_V

Product:	ONT - Order Management
Description:	This is view is used for the Demand Class LOV in Sales Orders form.
Implementation/DBA Data:	APPS.OE_DEMAND_CLASSES_V

View Text

SELECT MEANING DEMAND_CLASS
, DESCRIPTION
, LOOKUP_CODE DEMAND_CLASS_CODE
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE = 'DEMAND_CLASS'
AND APPLICATION_ID = 700
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns