POQ_QUESTNAIRES

Details

Schema: FUSION
Object owner: POQ
Object type: VIEW

Columns

Name
QUESTNAIRE_ID QUESTNAIRE_TITLE INTRODUCTION OBJECT_VERSION_NUMBER INITIATIVE_ID SUPPLIER_REG_ID QUESTNAIRE_TYPE QUESTNAIRE_USAGE_CODE PRC_BU_ID QUESTNAIRE_STATUS DUE_DATE USE_QUESTION_BRANCH_FLAG QUESTNAIRE_CUSTOM AUTO_CREATE_QUAL_FLAG REMIND_DAYS_BEFORE_DUE_FIRST REMIND_DAYS_BEFORE_DUE_SECOND REMIND_DAYS_PAST_DUE AUTO_CLOSE_DATE AUTO_CLOSE_THRESHOLD_PERCENT REMINDER_FIRST_SENT_DATE REMINDER_SECOND_SENT_DATE REMINDER_PAST_DUE_SENT_DATE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Name

QUESTNAIRE_ID

QUESTNAIRE_TITLE

INTRODUCTION

OBJECT_VERSION_NUMBER

INITIATIVE_ID

SUPPLIER_REG_ID

QUESTNAIRE_TYPE

QUESTNAIRE_USAGE_CODE

PRC_BU_ID

QUESTNAIRE_STATUS

DUE_DATE

USE_QUESTION_BRANCH_FLAG

QUESTNAIRE_CUSTOM

AUTO_CREATE_QUAL_FLAG

REMIND_DAYS_BEFORE_DUE_FIRST

REMIND_DAYS_BEFORE_DUE_SECOND

REMIND_DAYS_PAST_DUE

AUTO_CLOSE_DATE

AUTO_CLOSE_THRESHOLD_PERCENT

REMINDER_FIRST_SENT_DATE

REMINDER_SECOND_SENT_DATE

REMINDER_PAST_DUE_SENT_DATE

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.QUESTNAIRE_ID QUESTNAIRE_ID, T.QUESTNAIRE_TITLE QUESTNAIRE_TITLE, T.INTRODUCTION INTRODUCTION, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.INITIATIVE_ID INITIATIVE_ID, B.SUPPLIER_REG_ID SUPPLIER_REG_ID, B.QUESTNAIRE_TYPE QUESTNAIRE_TYPE, B.QUESTNAIRE_USAGE_CODE QUESTNAIRE_USAGE_CODE, B.PRC_BU_ID PRC_BU_ID, B.QUESTNAIRE_STATUS QUESTNAIRE_STATUS, B.DUE_DATE DUE_DATE, B.USE_QUESTION_BRANCH_FLAG USE_QUESTION_BRANCH_FLAG, B.QUESTNAIRE_CUSTOM QUESTNAIRE_CUSTOM, B.AUTO_CREATE_QUAL_FLAG AUTO_CREATE_QUAL_FLAG, B.REMIND_DAYS_BEFORE_DUE_FIRST REMIND_DAYS_BEFORE_DUE_FIRST, B.REMIND_DAYS_BEFORE_DUE_SECOND REMIND_DAYS_BEFORE_DUE_SECOND, B.REMIND_DAYS_PAST_DUE REMIND_DAYS_PAST_DUE, B.AUTO_CLOSE_DATE AUTO_CLOSE_DATE, B.AUTO_CLOSE_THRESHOLD_PERCENT AUTO_CLOSE_THRESHOLD_PERCENT, B.REMINDER_FIRST_SENT_DATE REMINDER_FIRST_SENT_DATE, B.REMINDER_SECOND_SENT_DATE REMINDER_SECOND_SENT_DATE, B.REMINDER_PAST_DUE_SENT_DATE REMINDER_PAST_DUE_SENT_DATE, B.REQUEST_ID REQUEST_ID, B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, 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_QUESTNAIRES_B B, POQ_QUESTNAIRES_TL T WHERE B.QUESTNAIRE_ID = T.QUESTNAIRE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.QUESTNAIRE_ID QUESTNAIRE_ID,

T.QUESTNAIRE_TITLE QUESTNAIRE_TITLE,

T.INTRODUCTION INTRODUCTION,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.INITIATIVE_ID INITIATIVE_ID,

B.SUPPLIER_REG_ID SUPPLIER_REG_ID,

B.QUESTNAIRE_TYPE QUESTNAIRE_TYPE,

B.QUESTNAIRE_USAGE_CODE QUESTNAIRE_USAGE_CODE,

B.PRC_BU_ID PRC_BU_ID,

B.QUESTNAIRE_STATUS QUESTNAIRE_STATUS,

B.DUE_DATE DUE_DATE,

B.USE_QUESTION_BRANCH_FLAG USE_QUESTION_BRANCH_FLAG,

B.QUESTNAIRE_CUSTOM QUESTNAIRE_CUSTOM,

B.AUTO_CREATE_QUAL_FLAG AUTO_CREATE_QUAL_FLAG,

B.REMIND_DAYS_BEFORE_DUE_FIRST REMIND_DAYS_BEFORE_DUE_FIRST,

B.REMIND_DAYS_BEFORE_DUE_SECOND REMIND_DAYS_BEFORE_DUE_SECOND,

B.REMIND_DAYS_PAST_DUE REMIND_DAYS_PAST_DUE,

B.AUTO_CLOSE_DATE AUTO_CLOSE_DATE,

B.AUTO_CLOSE_THRESHOLD_PERCENT AUTO_CLOSE_THRESHOLD_PERCENT,

B.REMINDER_FIRST_SENT_DATE REMINDER_FIRST_SENT_DATE,

B.REMINDER_SECOND_SENT_DATE REMINDER_SECOND_SENT_DATE,

B.REMINDER_PAST_DUE_SENT_DATE REMINDER_PAST_DUE_SENT_DATE,

B.REQUEST_ID REQUEST_ID,

B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

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_QUESTNAIRES_B B,

POQ_QUESTNAIRES_TL T

WHERE

B.QUESTNAIRE_ID = T.QUESTNAIRE_ID AND T.LANGUAGE = USERENV('LANG')