[Home] [Help]
View: SO_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 SO_PRICE_LISTS
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 |