VIEW: APPS.IGW_ORG_QUESTIONS_V

Source

View Text - Preformatted

SELECT POQ.ROWID ROW_ID, POQ.ORGANIZATION_ID, POQ.QUESTION_NUMBER, PQT.DESCRIPTION, PQ.EXPLANATION_FOR_YES_FLAG, PQ.EXPLANATION_FOR_NO_FLAG, PQ.DATE_FOR_YES_FLAG, PQ.DATE_FOR_NO_FLAG, POQ.ANSWER, POQ.EXPLANATION, POQ.REVIEW_DATE, POQ.LAST_UPDATE_DATE, POQ.LAST_UPDATED_BY, POQ.CREATION_DATE, POQ.CREATED_BY, POQ.LAST_UPDATE_LOGIN FROM IGW_QUESTIONS PQ, IGW_ORG_QUESTIONS POQ, IGW_QUESTIONS_TL PQT WHERE (POQ.QUESTION_NUMBER = PQ.QUESTION_NUMBER) AND (PQ.APPLIES_TO = 'O') AND (POQ.QUESTION_NUMBER = PQT.QUESTION_NUMBER) AND (PQT.LANGUAGE = userenv('LANG'))

View Text - HTML Formatted

SELECT POQ.ROWID ROW_ID
, POQ.ORGANIZATION_ID
, POQ.QUESTION_NUMBER
, PQT.DESCRIPTION
, PQ.EXPLANATION_FOR_YES_FLAG
, PQ.EXPLANATION_FOR_NO_FLAG
, PQ.DATE_FOR_YES_FLAG
, PQ.DATE_FOR_NO_FLAG
, POQ.ANSWER
, POQ.EXPLANATION
, POQ.REVIEW_DATE
, POQ.LAST_UPDATE_DATE
, POQ.LAST_UPDATED_BY
, POQ.CREATION_DATE
, POQ.CREATED_BY
, POQ.LAST_UPDATE_LOGIN
FROM IGW_QUESTIONS PQ
, IGW_ORG_QUESTIONS POQ
, IGW_QUESTIONS_TL PQT
WHERE (POQ.QUESTION_NUMBER = PQ.QUESTION_NUMBER)
AND (PQ.APPLIES_TO = 'O')
AND (POQ.QUESTION_NUMBER = PQT.QUESTION_NUMBER)
AND (PQT.LANGUAGE = USERENV('LANG'))