FND_ID_FLEX_STRUCTURES_TL
詳細
-
スキーマ: EBS
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM LANGUAGE SOURCE_LANG ID_FLEX_STRUCTURE_NAME DESCRIPTION SHORTHAND_PROMPT CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT B.APPLICATION_ID APPLICATION_ID, B.KEY_FLEXFIELD_CODE ID_FLEX_CODE, S.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM, B.LANGUAGE LANGUAGE, B.SOURCE_LANG SOURCE_LANG, B.NAME ID_FLEX_STRUCTURE_NAME, B.DESCRIPTION DESCRIPTION, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 80), 'Shorthand Alias Prompt') SHORTHAND_PROMPT, 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_STR_INSTANCES_TL B, FND_KF_STR_INSTANCES_B S WHERE S.APPLICATION_ID = B.APPLICATION_ID AND S.KEY_FLEXFIELD_CODE = B.KEY_FLEXFIELD_CODE AND S.STRUCTURE_INSTANCE_CODE = B.STRUCTURE_INSTANCE_CODE |