FND_KF_SEGMENTS_VL
詳細
-
スキーマ: KFF
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROW_ID STRUCTURE_ID SEGMENT_CODE SEGMENT_IDENTIFIER COLUMN_NAME SEQUENCE_NUMBER ENABLED_FLAG DEFAULT_VALUE_SET_ID DISPLAY_WIDTH RANGE_TYPE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN NAME DESCRIPTION PROMPT SHORT_PROMPT |
問合せ
| SQL_Statement |
|---|
|
SELECT B.ROWID ROW_ID, B.STRUCTURE_ID, B.SEGMENT_CODE, B.SEGMENT_IDENTIFIER, B.COLUMN_NAME, B.SEQUENCE_NUMBER, B.ENABLED_FLAG, B.DEFAULT_VALUE_SET_ID, B.DISPLAY_WIDTH, B.RANGE_TYPE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.NAME, T.DESCRIPTION, T.PROMPT, T.SHORT_PROMPT FROM FND_KF_SEGMENTS_B B, FND_KF_SEGMENTS_TL T WHERE B.STRUCTURE_ID = T.STRUCTURE_ID AND B.SEGMENT_CODE = T.SEGMENT_CODE AND T.LANGUAGE = USERENV('LANG') |