FND_DF_SEGMENTS_VL

Details

• Schema: DFF

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_CODE CONTEXT_CODE SEGMENT_CODE SEGMENT_IDENTIFIER COLUMN_NAME SEQUENCE_NUMBER ENABLED_FLAG REQUIRED_FLAG VALUE_SET_ID DEFAULT_TYPE DEFAULT_VALUE DEFAULT_VALUE_NUMBER DEFAULT_VALUE_DATE DEFAULT_VALUE_TIMESTAMP DERIVATION_VALUE RANGE_TYPE READ_ONLY_FLAG DISPLAY_TYPE DISPLAY_WIDTH DISPLAY_HEIGHT CHECKBOX_CHECKED_VALUE CHECKBOX_UNCHECKED_VALUE DYNAMIC_URL UOM_CLASS INDEXED_FLAG MULTIROW_UNIQUE_KEY_FLAG BI_ENABLED_FLAG BI_EQUALIZATION_TAG SHOW_VALUE_DESCRIPTION C_EXT_ATTRIBUTE1 C_EXT_ATTRIBUTE2 C_EXT_ATTRIBUTE3 C_EXT_ATTRIBUTE4 C_EXT_ATTRIBUTE5 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN NAME DESCRIPTION PROMPT SHORT_PROMPT TERMINOLOGY_HELP_TEXT IN_FIELD_HELP_TEXT

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE, B.CONTEXT_CODE, B.SEGMENT_CODE, B.SEGMENT_IDENTIFIER, B.COLUMN_NAME, B.SEQUENCE_NUMBER, B.ENABLED_FLAG, B.REQUIRED_FLAG, B.VALUE_SET_ID, B.DEFAULT_TYPE, B.DEFAULT_VALUE, B.DEFAULT_VALUE_NUMBER, B.DEFAULT_VALUE_DATE, B.DEFAULT_VALUE_TIMESTAMP, B.DERIVATION_VALUE, B.RANGE_TYPE, B.READ_ONLY_FLAG, B.DISPLAY_TYPE, B.DISPLAY_WIDTH, B.DISPLAY_HEIGHT, B.CHECKBOX_CHECKED_VALUE, B.CHECKBOX_UNCHECKED_VALUE, B.DYNAMIC_URL, B.UOM_CLASS, B.INDEXED_FLAG, B.MULTIROW_UNIQUE_KEY_FLAG, B.BI_ENABLED_FLAG, B.BI_EQUALIZATION_TAG, B.SHOW_VALUE_DESCRIPTION, B.C_EXT_ATTRIBUTE1, B.C_EXT_ATTRIBUTE2, B.C_EXT_ATTRIBUTE3, B.C_EXT_ATTRIBUTE4, B.C_EXT_ATTRIBUTE5, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.NAME, T.DESCRIPTION, T.PROMPT, T.SHORT_PROMPT, T.TERMINOLOGY_HELP_TEXT, T.IN_FIELD_HELP_TEXT FROM FND_DF_SEGMENTS_B B, FND_DF_SEGMENTS_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_CODE = T.DESCRIPTIVE_FLEXFIELD_CODE AND B.CONTEXT_CODE = T.CONTEXT_CODE AND B.SEGMENT_CODE = T.SEGMENT_CODE AND T.LANGUAGE = USERENV('LANG')