[Home] [Help]
View: IGWFV_GRNT_PERS_CERT_ANSWER
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 |
APPS.IGWFV_GRNT_PERS_CERT_ANSWER