[Home] [Help]
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
Name |
PRICE_LIST |
DESCRIPTION |
PRICE_LIST_ID |
ROUNDING_FACTOR |
CURRENCY_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |