VIEW: APPS.JTM_FND_PROFILE_OPTIONS_V

Source

View Text - Preformatted

SELECT acc.access_id, bas.APPLICATION_ID, bas.PROFILE_OPTION_ID, bas.PROFILE_OPTION_NAME, bas.LAST_UPDATE_DATE, bas.LAST_UPDATED_BY, bas.CREATION_DATE, bas.CREATED_BY, bas.LAST_UPDATE_LOGIN, bas.WRITE_ALLOWED_FLAG, bas.READ_ALLOWED_FLAG, bas.USER_CHANGEABLE_FLAG, bas.USER_VISIBLE_FLAG, bas.SITE_ENABLED_FLAG, bas.SITE_UPDATE_ALLOWED_FLAG, bas.APP_ENABLED_FLAG, bas.APP_UPDATE_ALLOWED_FLAG, bas.RESP_ENABLED_FLAG, bas.RESP_UPDATE_ALLOWED_FLAG, bas.USER_ENABLED_FLAG, bas.USER_UPDATE_ALLOWED_FLAG, bas.START_DATE_ACTIVE, bas.SQL_VALIDATION, bas.END_DATE_ACTIVE, bastl.language, bastl.source_lang, bastl.USER_PROFILE_OPTION_NAME, bastl.description FROM fnd_profile_options bas , fnd_profile_options_tl bastl , jtm_fnd_prof_options_acc acc WHERE bas.profile_option_name = bastl.profile_option_name AND bastl.language = asg_base.get_language AND bas.profile_option_name = acc.profile_option_name

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, BAS.APPLICATION_ID
, BAS.PROFILE_OPTION_ID
, BAS.PROFILE_OPTION_NAME
, BAS.LAST_UPDATE_DATE
, BAS.LAST_UPDATED_BY
, BAS.CREATION_DATE
, BAS.CREATED_BY
, BAS.LAST_UPDATE_LOGIN
, BAS.WRITE_ALLOWED_FLAG
, BAS.READ_ALLOWED_FLAG
, BAS.USER_CHANGEABLE_FLAG
, BAS.USER_VISIBLE_FLAG
, BAS.SITE_ENABLED_FLAG
, BAS.SITE_UPDATE_ALLOWED_FLAG
, BAS.APP_ENABLED_FLAG
, BAS.APP_UPDATE_ALLOWED_FLAG
, BAS.RESP_ENABLED_FLAG
, BAS.RESP_UPDATE_ALLOWED_FLAG
, BAS.USER_ENABLED_FLAG
, BAS.USER_UPDATE_ALLOWED_FLAG
, BAS.START_DATE_ACTIVE
, BAS.SQL_VALIDATION
, BAS.END_DATE_ACTIVE
, BASTL.LANGUAGE
, BASTL.SOURCE_LANG
, BASTL.USER_PROFILE_OPTION_NAME
, BASTL.DESCRIPTION
FROM FND_PROFILE_OPTIONS BAS
, FND_PROFILE_OPTIONS_TL BASTL
, JTM_FND_PROF_OPTIONS_ACC ACC
WHERE BAS.PROFILE_OPTION_NAME = BASTL.PROFILE_OPTION_NAME
AND BASTL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND BAS.PROFILE_OPTION_NAME = ACC.PROFILE_OPTION_NAME