FND Design Data [Home] [Help]

View: BIL_DIMV_TOP_BOTTOM

Product: BIL - Sales Intelligence (Obsolete)
Description: List of values view
Implementation/DBA Data: Not implemented in this database
View Text

SELECT TO_NUMBER(FVV.FLEX_VALUE_MEANING) ID
, FVV.DESCRIPTION VALUE
FROM FND_FLEX_VALUES_VL FVV
, FND_FLEX_VALUE_SETS FVS
WHERE FVV.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
AND FVS.FLEX_VALUE_SET_NAME = 'BIL_TOP_BOTTOM'
AND FVV.ENABLED_FLAG = 'Y'

Columns

Name
ID
VALUE