DBA Data[Home] [Help]

VIEW: APPS.MSC_QUESTIONS_VL

Source

View Text - Preformatted

SELECT b.question_id, b.question_code, b.question_type, tl.user_question_name from msc_questions_tl tl, msc_questions_b b WHERE b.question_id = tl.question_id and tl.language = userenv('LANG')
View Text - HTML Formatted

SELECT B.QUESTION_ID
, B.QUESTION_CODE
, B.QUESTION_TYPE
, TL.USER_QUESTION_NAME
FROM MSC_QUESTIONS_TL TL
, MSC_QUESTIONS_B B
WHERE B.QUESTION_ID = TL.QUESTION_ID
AND TL.LANGUAGE = USERENV('LANG')