VIEW: APPS.IGWBV_GRNT_PERS_CERT_ANSWER

Source

View Text - Preformatted

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

View Text - HTML Formatted

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