VIEW: APPS.ECE_PROFILE_OPTIONS

Source

View Text - Preformatted

SELECT fpo.profile_option_id, fpo.application_id, fpo.profile_option_name, fpo.user_profile_option_name, fpo.description, fpo.sql_validation, fpov.profile_option_value, fpo.creation_date, fpo.created_by, fpo.last_update_date, fpo.last_updated_by, fpo.last_update_login, fpo.start_date_active, fpo.end_date_active, fpo.write_allowed_flag, fpo.read_allowed_flag, fpo.user_changeable_flag, fpo.user_visible_flag, fpo.site_enabled_flag, fpo.site_update_allowed_flag, fpo.app_enabled_flag, fpo.app_update_allowed_flag, fpo.resp_enabled_flag, fpo.resp_update_allowed_flag, fpo.user_enabled_flag, fpo.user_update_allowed_flag FROM fnd_profile_options_vl fpo, fnd_profile_option_values fpov WHERE fpo.profile_option_name like 'ECE_%' AND fpo.profile_option_id = fpov.profile_option_id (+) AND fpov.level_id (+) = 10001 AND fpov.application_id=175

View Text - HTML Formatted

SELECT FPO.PROFILE_OPTION_ID
, FPO.APPLICATION_ID
, FPO.PROFILE_OPTION_NAME
, FPO.USER_PROFILE_OPTION_NAME
, FPO.DESCRIPTION
, FPO.SQL_VALIDATION
, FPOV.PROFILE_OPTION_VALUE
, FPO.CREATION_DATE
, FPO.CREATED_BY
, FPO.LAST_UPDATE_DATE
, FPO.LAST_UPDATED_BY
, FPO.LAST_UPDATE_LOGIN
, FPO.START_DATE_ACTIVE
, FPO.END_DATE_ACTIVE
, FPO.WRITE_ALLOWED_FLAG
, FPO.READ_ALLOWED_FLAG
, FPO.USER_CHANGEABLE_FLAG
, FPO.USER_VISIBLE_FLAG
, FPO.SITE_ENABLED_FLAG
, FPO.SITE_UPDATE_ALLOWED_FLAG
, FPO.APP_ENABLED_FLAG
, FPO.APP_UPDATE_ALLOWED_FLAG
, FPO.RESP_ENABLED_FLAG
, FPO.RESP_UPDATE_ALLOWED_FLAG
, FPO.USER_ENABLED_FLAG
, FPO.USER_UPDATE_ALLOWED_FLAG
FROM FND_PROFILE_OPTIONS_VL FPO
, FND_PROFILE_OPTION_VALUES FPOV
WHERE FPO.PROFILE_OPTION_NAME LIKE 'ECE_%'
AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID (+)
AND FPOV.LEVEL_ID (+) = 10001
AND FPOV.APPLICATION_ID=175