View: OE_PRICE_LISTS_ACTIVE_V

Product:	QP - Advanced Pricing
Description:	Shows all the price lists that are active as of today (sysdate). Provided for backward compatibility for other applications.
Implementation/DBA Data:	APPS.OE_PRICE_LISTS_ACTIVE_V

View Text

SELECT NAME PRICE_LIST
, DESCRIPTION
, PRICE_LIST_ID
, ROUNDING_FACTOR
, CURRENCY_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM OE_PRICE_LISTS_V
WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)

Columns