FND_DESCR_FLEX_CONTEXTS_TL
詳細
-
スキーマ: EBS
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE LANGUAGE SOURCE_LANG DESCRIPTIVE_FLEX_CONTEXT_NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, B.CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE, B.LANGUAGE LANGUAGE, B.SOURCE_LANG SOURCE_LANG, B.NAME DESCRIPTIVE_FLEX_CONTEXT_NAME, 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_DF_CONTEXTS_TL B UNION SELECT B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 30), 'Global Data Elements') DESCRIPTIVE_FLEX_CONTEXT_CODE, B.LANGUAGE LANGUAGE, B.SOURCE_LANG SOURCE_LANG, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 80), 'Global Data Elements') DESCRIPTIVE_FLEX_CONTEXT_NAME, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 240), 'Global Data Elements') 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_DF_FLEXFIELDS_TL B |