配置文件定义
SELECT profile_option_name 配置文件名,
user_profile_option_name 用户配置文件名,
description 说明,
hierarchy_type 层次结构类型,
site_enabled_flag 地点可见,
site_update_allowed_flag 地点可更新,
app_enabled_flag 应用产品可见,
app_update_allowed_flag 应用产品可更新,
resp_enabled_flag 责任可见,
resp_update_allowed_flag 责任可更新,
server_enabled_flag 服务器可见,
server_update_allowed_flag 服务器可更新,
serverresp_enabled_flag 服务器职责可见,
serverresp_update_allowed_flag 服务器职责可更新,
org_enabled_flag 组织可见,
org_update_allowed_flag 组织可更新,
user_enabled_flag 用户可见,
user_update_allowed_flag 用户可更新,
start_date_active 有效起始日期,
end_date_active 有效截止日期,
user_visible_flag 用户访问可查看,
user_changeable_flag 用户访问可更新,
read_allowed_flag 可读,
write_allowed_flag 可写,
sql_validation sql验证,
profile_option_id 配置文件配置情况id
FROM fnd_profile_options_vl
WHERE (user_profile_option_name = 'CUX_用户机台编号')
配置文件设置
SELECT op.profile_option_id,
tl.profile_option_name,
tl.user_profile_option_name,
lv.level_id,
lv.文件安全性,
va.level_value,
CASE
WHEN va.level_id = 10001 THEN
'地点'
WHEN va.level_id = 10002 THEN
(SELECT fav.application_name
FROM fnd_application_vl fav
WHERE fav.application_id = va.level_value)
WHEN va.level_id = 10003 THEN
(SELECT /* $HEADER$ */
t.responsibility_name
FROM fnd_responsibility_tl t, fnd_responsibility b
WHERE t.responsibility_id = va.level_value
AND t.responsibility_id = b.responsibility_id
AND b.application_id = t.application_id
AND nvl(b.end_date, SYSDATE + 1) > SYSDATE
AND nvl(b.start_date, SYSDATE - 1) < SYSDATE
AND t.language = 'ZHS')
WHEN va.level_id = 10004 THEN
(SELECT user_name