FND_DESCR_FLEX_COL_USAGE_TL

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE APPLICATION_COLUMN_NAME LANGUAGE SOURCE_LANG FORM_LEFT_PROMPT FORM_ABOVE_PROMPT DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, B.CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE, FDS.COLUMN_NAME APPLICATION_COLUMN_NAME, B.LANGUAGE LANGUAGE, B.SOURCE_LANG SOURCE_LANG, B.PROMPT FORM_LEFT_PROMPT, B.SHORT_PROMPT FORM_ABOVE_PROMPT, B.DESCRIPTION DESCRIPTION, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM FND_DF_SEGMENTS_TL B, FND_DF_SEGMENTS_B FDS WHERE B.APPLICATION_ID = FDS.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_CODE = FDS.DESCRIPTIVE_FLEXFIELD_CODE AND B.CONTEXT_CODE = FDS.CONTEXT_CODE AND B.SEGMENT_CODE = FDS.SEGMENT_CODE AND B.CONTEXT_CODE <> 'Context Data Element'