[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 |