[Home] [Help]
View: IGWBV_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 |