FND Design Data [Home] [Help]

View: ENG_SUBJECTS_VL

Product: ENG - Engineering
Description:
Implementation/DBA Data: ViewAPPS.ENG_SUBJECTS_VL
View Text

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')

Columns

Name
SUBJECT_ID
SUBJECT_NAME