View: IGW_PRPO_YN_RESPONSES_V

Product:	IGW - Grants Proposal
Description:	View displays answers to questions about individuals, the proposal, and the organization
Implementation/DBA Data:	APPS.IGW_PRPO_YN_RESPONSES_V

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