[Home] [Help]
View: IGWBV_GRNT_PERS_CERT_ANSWER
Product: | IGW - Grants Proposal (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PR.PROPOSAL_NUMBER
, PE.QUESTION_NUMBER
, T.DESCRIPTION
, PE.ANSWER
, PE.REVIEW_DATE
, PE.PERSON_ID
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.EXPLANATION
FROM IGW_PROP_PERSON_QUESTIONS PE
, IGW_PROPOSALS_ALL PR
, IGW_QUESTIONS_TL T
, IGW_QUESTIONS B
WHERE PR.PROPOSAL_ID = PE.PROPOSAL_ID
AND B.QUESTION_NUMBER = T.QUESTION_NUMBER
AND T.LANGUAGE = USERENV('LANG') WITH READ ONLY
Columns
Name |
PROPOSAL_NUMBER |
QUESTION_NUMBER |
QUESTION |
ANSWER |
REVIEW_DATE |
PERSON_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
EXPLANATION |