FND_ID_FLEX_SEGMENTS_TL

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM 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 SIB.APPLICATION_ID APPLICATION_ID, SIB.KEY_FLEXFIELD_CODE ID_FLEX_CODE, SIB.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM, SGB.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_KF_SEGMENT_INSTANCES SGI, FND_KF_STR_INSTANCES_B SIB, FND_KF_SEGMENTS_B SGB, FND_KF_SEGMENTS_TL B WHERE SIB.STRUCTURE_INSTANCE_ID = SGI.STRUCTURE_INSTANCE_ID AND SGB.STRUCTURE_ID = SIB.STRUCTURE_ID AND SGB.SEGMENT_CODE = SGI.SEGMENT_CODE AND B.STRUCTURE_ID = SGB.STRUCTURE_ID AND B.SEGMENT_CODE = SGB.SEGMENT_CODE