DBA Data[Home] [Help]

VIEW: APPS.ENG_SUBJECTS_VL

Source

View Text - Preformatted

SELECT B.SUBJECT_ID , T.SUBJECT_NAME from ENG_SUBJECTS_B B, ENG_SUBJECTS_TL T where B.SUBJECT_ID=T.SUBJECT_ID AND T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.SUBJECT_ID
, T.SUBJECT_NAME
FROM ENG_SUBJECTS_B B
, ENG_SUBJECTS_TL T
WHERE B.SUBJECT_ID=T.SUBJECT_ID
AND T.LANGUAGE = USERENV('LANG')