Oracle profile query, oracleprofile
Definition of zookeeper configuration file
SELECT profile_option_name configuration file name, user_profile_option_name user configuration file name, description, hierarchy_type hierarchical structure type, site_enabled_flag location visible, Region location updatable, app_enabled_flag application product visible, Region application product updatable, resp_enabled_flag is visible, worker responsibility can be updated, server_enabled_flag server can be seen, server_update_allowed_flag server can be updated, worker Server responsibility can be seen, org_enabled_flag organization can be seen, worker organization can be updated, visible to users in the region, users in the region can update, start_date_active effective start date, end_date_active effective end date, users in the region can view access, user_changeable_flag user access can be updated, read_allowed_flag readable, write_allowed_flag, SQL _validation SQL verification, profile_option_id configuration file id FROM fnd_profile_options_vl WHERE (user_profile_option_name = 'cux _ User station number ')
Configuration File Settings
SELECT op. profile_option_id, tl. profile_option_name, tl. user_profile_option_name, lv. level_id, lv. file security, va. level_value, case when va. level_id = 10001 THEN 'location '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 FROM fnd_user WHERE user_name not in ('* ANONYMOS *', 'version', 'initial SETUP ', 'feeder system', 'concurrent Manager ', 'standalone BATCH Process') AND user_id = va. level_value AND nvl (end_date, SYSDATE + 1)> sysdate and nvl (start_date, SYSDATE-1) <SYSDATE) WHEN va. level_id = 10005 THEN (SELECT node_name FROM fnd_nodes WHERE node_id = va. level_value) WHEN va. level_id = 10006 THEN (select name from hr_operating_units WHERE organization_id = va. level_value) ELSE ''end AS profile_level_value, va. profile_option_value FROM fnd_profile_options_tl tl, fnd_profile_options op, fnd_profile_option_values va, (SELECT 10001 level_id, 'location' file security FROM dual union select 10002 level_id, 'application product' file security FROM dual union select 10003 level_id, 'response' file security FROM dual union select 10004 level_id, 'users' file security FROM dual union select 10005 level_id, 'server' file security FROM dual union select 10006 level_id, 'org 'file security FROM dual) lv WHERE tl. language = 'zhs 'AND tl. profile_option_name = op. profile_option_name AND va. profile_option_id = op. profile_option_id AND va. level_id = lv. level_id -- and tl. PROFILE_OPTION_NAME like '%' AND tl. user_profile_option_name = 'cux _ User station number'