FND_DESCR_FLEX_COLUMN_USAGES

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE END_USER_COLUMN_NAME APPLICATION_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

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, B.CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE, B.SEGMENT_CODE END_USER_COLUMN_NAME, B.COLUMN_NAME APPLICATION_COLUMN_NAME, B.SEQUENCE_NUMBER COLUMN_SEQ_NUM, B.ENABLED_FLAG ENABLED_FLAG, B.REQUIRED_FLAG REQUIRED_FLAG, B.VALUE_SET_ID FLEX_VALUE_SET_ID, SUBSTR('N', 1, 1) SECURITY_ENABLED_FLAG, SUBSTR(DECODE(B.DEFAULT_TYPE,'CONSTANT','C',null),1,1) DEFAULT_TYPE, B.DEFAULT_VALUE DEFAULT_VALUE, SUBSTR(DECODE(B.RANGE_TYPE,'LOW','L','HIGH','H',null),1,1) RANGE_CODE, SUBSTR(DECODE(B.DISPLAY_TYPE,'HIDDEN','N','Y'),1,1) DISPLAY_FLAG, B.DISPLAY_WIDTH DISPLAY_SIZE, 50 MAXIMUM_DESCRIPTION_LEN, 25 CONCATENATION_DESCRIPTION_LEN, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 30), NULL) SRW_PARAM, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 2000), NULL) RUNTIME_PROPERTY_FUNCTION, 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_B B WHERE B.CONTEXT_CODE <> 'Context Data Element'