VIEW: APPS.IGW_PRPO_YN_RESPONSES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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