Product: | FND - Application Object Library |
---|---|
Description: | FND_PROFILE_CAT_OPTIONS_VL |
Implementation/DBA Data: | APPS.FND_PROFILE_CAT_OPTIONS_VL |
SELECT B.ROWID ROW_ID
, B.PROFILE_OPTION_APPLICATION_ID
, B.PROFILE_OPTION_ID
, B.CATEGORY_NAME
, B.DISPLAY_SEQUENCE
, B.DISPLAY_TYPE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION_OVERRIDE
FROM FND_PROFILE_CAT_OPTIONS_TL T
, FND_PROFILE_CAT_OPTIONS B
WHERE B.PROFILE_OPTION_APPLICATION_ID = T.PROFILE_OPTION_APPLICATION_ID
AND B.PROFILE_OPTION_ID = T.PROFILE_OPTION_ID
AND B.CATEGORY_NAME = T.CATEGORY_NAME
AND T.LANGUAGE = USERENV('LANG')