[Home] [Help]
View: IGW_QUESTIONS_VL
Product: | IGW - Grants Proposal (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.ROWID ROW_ID
, B.QUESTION_NUMBER
, B.APPLIES_TO
, B.EXPLANATION_FOR_YES_FLAG
, B.EXPLANATION_FOR_NO_FLAG
, B.DATE_FOR_YES_FLAG
, B.DATE_FOR_NO_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, T.EXPLANATION
, T.POLICY
, T.REGULATION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION
FROM IGW_QUESTIONS_TL T
, IGW_QUESTIONS B
WHERE B.QUESTION_NUMBER = T.QUESTION_NUMBER
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
QUESTION_NUMBER |
APPLIES_TO |
EXPLANATION_FOR_YES_FLAG |
EXPLANATION_FOR_NO_FLAG |
DATE_FOR_YES_FLAG |
DATE_FOR_NO_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
EXPLANATION |
POLICY |
REGULATION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
DESCRIPTION |