VIEW: APPS.CSF_M_PROFILES_V

Source

View Text - Preformatted

SELECT acc.access_id as access_id, prof.profile_option_name, acc.profile_option_value , prof.START_DATE_ACTIVE, prof.END_DATE_ACTIVE, tl.USER_PROFILE_OPTION_NAME, tl.description from csm_profile_option_values_acc acc, fnd_profile_options prof, fnd_profile_options_tl tl WHERE acc.user_id = asg_base.get_user_id AND acc.profile_option_id = prof.profile_option_id AND acc.APPLICATION_ID = prof.APPLICATION_ID AND prof.profile_option_name = tl.profile_option_name AND tl.language = asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID AS ACCESS_ID
, PROF.PROFILE_OPTION_NAME
, ACC.PROFILE_OPTION_VALUE
, PROF.START_DATE_ACTIVE
, PROF.END_DATE_ACTIVE
, TL.USER_PROFILE_OPTION_NAME
, TL.DESCRIPTION
FROM CSM_PROFILE_OPTION_VALUES_ACC ACC
, FND_PROFILE_OPTIONS PROF
, FND_PROFILE_OPTIONS_TL TL
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.PROFILE_OPTION_ID = PROF.PROFILE_OPTION_ID
AND ACC.APPLICATION_ID = PROF.APPLICATION_ID
AND PROF.PROFILE_OPTION_NAME = TL.PROFILE_OPTION_NAME
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE