[Home] [Help]
View: IGW_PRPO_YN_RESPONSES_V
| Product: | IGW - Grants Proposal (Obsolete) |
|---|
| Description: | View displays answers to questions about individuals, the proposal, and the organization |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PROPOSAL_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 'P' APPLIES_TO
, QUESTION_NUMBER
, DECODE(ANSWER
, '1'
, 'Y'
, '2'
, 'N') RESPONSE
, EXPLANATION
, REVIEW_DATE
FROM IGW_PROP_QUESTIONS
WHERE ANSWER <> 3 UNION SELECT P.PROPOSAL_ID
, Q.ORGANIZATION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 'O' APPLIES_TO
, Q.QUESTION_NUMBER
, DECODE(ANSWER
, '1'
, 'Y'
, '2'
, 'N') RESPONSE
, Q.EXPLANATION
, Q.REVIEW_DATE
FROM IGW_ORG_QUESTIONS Q
, IGW_PROPOSALS P
WHERE Q.ORGANIZATION_ID = P.SUBMITTING_ORGANIZATION_ID
AND ANSWER <> 3 UNION SELECT PROPOSAL_ID
, TO_NUMBER(NULL)
, PERSON_ID
, PARTY_ID PERSON_PARTY_ID
, 'I' APPLIES_TO
, QUESTION_NUMBER
, DECODE(ANSWER
, '1'
, 'Y'
, '2'
, 'N') RESPONSE
, EXPLANATION
, REVIEW_DATE
FROM IGW_PROP_PERSON_QUESTIONS
WHERE ANSWER <> 3
Columns
| Name |
| PROPOSAL_ID |
| ORGANIZATION_ID |
| PERSON_ID |
| PERSON_PARTY_ID |
| QUESTION_APPLIES_TO |
| QUESTION_NUMBER |
| RESPONSE |
| EXPLANATION |
| REVIEW_DATE |