FND_ID_FLEX_SEGMENTS

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME SEGMENT_NAME SEGMENT_NUM ENABLED_FLAG REQUIRED_FLAG FLEX_VALUE_SET_ID SECURITY_ENABLED_FLAG RANGE_CODE DEFAULT_TYPE DEFAULT_VALUE DISPLAY_FLAG DISPLAY_SIZE MAXIMUM_DESCRIPTION_LEN CONCATENATION_DESCRIPTION_LEN RUNTIME_PROPERTY_FUNCTION ADDITIONAL_WHERE_CLAUSE APPLICATION_COLUMN_INDEX_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID, SI.APPLICATION_ID APPLICATION_ID, SI.KEY_FLEXFIELD_CODE ID_FLEX_CODE, SI.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM, SG.COLUMN_NAME APPLICATION_COLUMN_NAME, SG.SEGMENT_CODE SEGMENT_NAME, SG.SEQUENCE_NUMBER SEGMENT_NUM, SG.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(SG.RANGE_TYPE,'LOW','L','HIGH','H',null),1,1) RANGE_CODE, SUBSTR(DECODE(B.DEFAULT_TYPE,'CONSTANT','C',null),1,1) DEFAULT_TYPE, B.DEFAULT_VALUE DEFAULT_VALUE, B.DISPLAY_FLAG DISPLAY_FLAG, SG.DISPLAY_WIDTH DISPLAY_SIZE, 50 MAXIMUM_DESCRIPTION_LEN, 25 CONCATENATION_DESCRIPTION_LEN, DECODE(SI.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 2000), NULL) RUNTIME_PROPERTY_FUNCTION, DECODE(SI.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 2000), NULL) ADDITIONAL_WHERE_CLAUSE, SUBSTR('N', 1, 1) APPLICATION_COLUMN_INDEX_FLAG, 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_KF_SEGMENT_INSTANCES B, FND_KF_STR_INSTANCES_B SI, FND_KF_SEGMENTS_B SG WHERE SI.STRUCTURE_INSTANCE_ID = B.STRUCTURE_INSTANCE_ID AND SG.STRUCTURE_ID = SI.STRUCTURE_ID AND SG.SEGMENT_CODE = B.SEGMENT_CODE