FND Design Data [Home] [Help]

View: SO_PRICE_LISTS_ACTIVE_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.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