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