1. Tables and Views for Procurement
  2. POQ_RULE_SETS_VL

POQ_RULE_SETS_VL

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: VIEW

Columns

Name

RULE_SET_ID

QUESTIONNAIRE_INSTRUCTIONS

SUPP_QSTNAIRE_INSTRUCTIONS

INT_QSTNAIRE_INSTRUCTIONS

RULE_SET_NAME

RULE_SET_DESCRIPTION

AUTO_CREATE_QUAL_FLAG

RULE_SET_STATUS

USE_QUESTION_BRANCH_FLAG

ACTIVATION_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

B.RULE_SET_ID RULE_SET_ID,

T.QUESTIONNAIRE_INSTRUCTIONS QUESTIONNAIRE_INSTRUCTIONS,

T.SUPP_QSTNAIRE_INSTRUCTIONS SUPP_QSTNAIRE_INSTRUCTIONS,

T.INT_QSTNAIRE_INSTRUCTIONS INT_QSTNAIRE_INSTRUCTIONS,

B.RULE_SET_NAME RULE_SET_NAME,

B.RULE_SET_DESCRIPTION RULE_SET_DESCRIPTION,

B.AUTO_CREATE_QUAL_FLAG AUTO_CREATE_QUAL_FLAG,

B.RULE_SET_STATUS RULE_SET_STATUS,

B.USE_QUESTION_BRANCH_FLAG USE_QUESTION_BRANCH_FLAG,

B.ACTIVATION_DATE ACTIVATION_DATE,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

POQ_RULE_SETS_B B,

POQ_RULE_SETS_TL T

WHERE

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