FND_ID_FLEX_SEGMENTS_TL
詳細
-
スキーマ: EBS
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 |