POQ_QUESTNAIRE_SECTIONS_VL

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
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

Query

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')