VIEW: APPS.FND_SEGMENT_NAMES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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