VIEW: APPS.IGWBV_GRNT_PRPSL_CERT_QUESTION

Source

View Text - Preformatted

SELECT QUE.QUESTION_NUMBER, QTL.DESCRIPTION, QTL.EXPLANATION, QTL.POLICY, QTL.REGULATION, QUE.APPLIES_TO, QUE.EXPLANATION_FOR_YES_FLAG, QUE.EXPLANATION_FOR_NO_FLAG, QUE.DATE_FOR_YES_FLAG, QUE.DATE_FOR_NO_FLAG, QUE.START_DATE_ACTIVE, QUE.END_DATE_ACTIVE, QUE.LAST_UPDATE_DATE, QUE.LAST_UPDATED_BY, QUE.CREATION_DATE, QUE.CREATED_BY from IGW_QUESTIONS QUE, IGW_QUESTIONS_TL QTL WHERE QUE.QUESTION_NUMBER = QTL.QUESTION_NUMBER and QTL.LANGUAGE = userenv('LANG') with read only

View Text - HTML Formatted

SELECT QUE.QUESTION_NUMBER
, QTL.DESCRIPTION
, QTL.EXPLANATION
, QTL.POLICY
, QTL.REGULATION
, QUE.APPLIES_TO
, QUE.EXPLANATION_FOR_YES_FLAG
, QUE.EXPLANATION_FOR_NO_FLAG
, QUE.DATE_FOR_YES_FLAG
, QUE.DATE_FOR_NO_FLAG
, QUE.START_DATE_ACTIVE
, QUE.END_DATE_ACTIVE
, QUE.LAST_UPDATE_DATE
, QUE.LAST_UPDATED_BY
, QUE.CREATION_DATE
, QUE.CREATED_BY
FROM IGW_QUESTIONS QUE
, IGW_QUESTIONS_TL QTL
WHERE QUE.QUESTION_NUMBER = QTL.QUESTION_NUMBER
AND QTL.LANGUAGE = USERENV('LANG') WITH READ ONLY