FND Design Data [Home] [Help]

View: FND_SEGMENT_NAMES_V

Product: FND - Application Object Library
Description: Key flexfield segment names
Implementation/DBA Data: ViewAPPS.FND_SEGMENT_NAMES_V
View Text

SELECT S.ID_FLEX_CODE
, S.ID_FLEX_NUM
, S.SEGMENT_NAME
, S.FLEX_VALUE_SET_ID
, S.APPLICATION_COLUMN_NAME
, S.SEGMENT_NUM
, S.ENABLED_FLAG
, V.VALIDATION_TYPE
FROM FND_ID_FLEX_SEGMENTS S
, FND_FLEX_VALUE_SETS V
WHERE V.FLEX_VALUE_SET_ID = S.FLEX_VALUE_SET_ID

Columns

Name
ID_FLEX_CODE
ID_FLEX_NUM
SEGMENT_NAME
FLEX_VALUE_SET_ID
APPLICATION_COLUMN_NAME
SEGMENT_NUM
ENABLED_FLAG
VALIDATION_TYPE