Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_PROP_QUESTIONS_V |
SELECT PPQ.ROWID ROW_ID
, PPQ.PROPOSAL_ID
, PPQ.QUESTION_NUMBER
, PQT.DESCRIPTION
, PQ.EXPLANATION_FOR_YES_FLAG
, PQ.EXPLANATION_FOR_NO_FLAG
, PQ.DATE_FOR_YES_FLAG
, PQ.DATE_FOR_NO_FLAG
, PPQ.ANSWER
, PPQ.EXPLANATION
, PPQ.REVIEW_DATE
, PPQ.LAST_UPDATE_DATE
, PPQ.LAST_UPDATED_BY
, PPQ.CREATION_DATE
, PPQ.CREATED_BY
, PPQ.LAST_UPDATE_LOGIN
FROM IGW_QUESTIONS PQ
, IGW_PROP_QUESTIONS PPQ
, IGW_QUESTIONS_TL PQT
WHERE PPQ.QUESTION_NUMBER = PQ.QUESTION_NUMBER
AND PQ.APPLIES_TO = 'P'
AND PPQ.QUESTION_NUMBER = PQT.QUESTION_NUMBER
AND PQT.LANGUAGE = USERENV('LANG')