FND_DESCR_FLEX_COL_USAGE_VL

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE APPLICATION_COLUMN_NAME END_USER_COLUMN_NAME COLUMN_SEQ_NUM ENABLED_FLAG REQUIRED_FLAG FLEX_VALUE_SET_ID SECURITY_ENABLED_FLAG DEFAULT_TYPE DEFAULT_VALUE RANGE_CODE DISPLAY_FLAG DISPLAY_SIZE MAXIMUM_DESCRIPTION_LEN CONCATENATION_DESCRIPTION_LEN SRW_PARAM RUNTIME_PROPERTY_FUNCTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN FORM_LEFT_PROMPT FORM_ABOVE_PROMPT DESCRIPTION

Query

SQL_Statement

SELECT B.ROW_ID ROW_ID, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_NAME, B.DESCRIPTIVE_FLEX_CONTEXT_CODE, B.APPLICATION_COLUMN_NAME, B.END_USER_COLUMN_NAME, B.COLUMN_SEQ_NUM, B.ENABLED_FLAG, B.REQUIRED_FLAG, B.FLEX_VALUE_SET_ID, B.SECURITY_ENABLED_FLAG, B.DEFAULT_TYPE, B.DEFAULT_VALUE, B.RANGE_CODE, B.DISPLAY_FLAG, B.DISPLAY_SIZE, B.MAXIMUM_DESCRIPTION_LEN, B.CONCATENATION_DESCRIPTION_LEN, B.SRW_PARAM, B.RUNTIME_PROPERTY_FUNCTION, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.FORM_LEFT_PROMPT, T.FORM_ABOVE_PROMPT, T.DESCRIPTION FROM FND_DESCR_FLEX_COLUMN_USAGES B, FND_DESCR_FLEX_COL_USAGE_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME AND B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE AND B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME AND T.LANGUAGE = USERENV('LANG')