機械翻訳について

POQ_QUESTNAIRE_SECTIONS_VL

詳細

  • スキーマ: FUSION

  • オブジェクト所有者: POQ

  • オブジェクト・タイプ: VIEW

名前

QUESTNAIRE_SECTION_ID

SECTION_NAME

INSTRUCTIONS

OBJECT_VERSION_NUMBER

QUESTNAIRE_ID

DISPLAY_SEQUENCE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

問合せ

SQL_Statement

SELECT

B.QUESTNAIRE_SECTION_ID QUESTNAIRE_SECTION_ID,

T.SECTION_NAME SECTION_NAME,

T.INSTRUCTIONS INSTRUCTIONS,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.QUESTNAIRE_ID QUESTNAIRE_ID,

B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE,

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

POQ_QUESTNAIRE_SECTIONS_B B,

POQ_QUESTNAIRE_SECTIONS_TL T

WHERE

B.QUESTNAIRE_SECTION_ID = T.QUESTNAIRE_SECTION_ID

AND T.LANGUAGE = USERENV('LANG')