EBS: 系统配置文件查询
EBS R12.1 系统配置文件查询
路径: SYSTEM ADMINISTRATOR>> 配置文件>>系统。
SYSTEM ADMINISTRATOR>> PROFILE>>SYSTEM.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 | -- FND-配置文件查询.sql -- 地点层,共 4175 笔 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10001' , '地点' ) as level_code, fpv.level_id, fpv.level_value, '' AS "应用产品" , '' AS "责任" , '' as "用户" , '' AS "服务器" , '' AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10001 -- 10001: 地点层 -- and fpo.PROFILE_OPTION_NAME = 'FND_SOA_AUDIT_ENABLED' UNION ALL -- 应用产品 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10002' , '应用产品' ) as level_code, fpv.level_id, fpv.level_value, ( SELECT FA.APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10002 AND ROWNUM = 1 ) AS "应用产品" , '' AS "责任" , '' as "用户" , '' AS "服务器" , '' AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10002 -- 10002: 应用产品 -- and fpo.PROFILE_OPTION_NAME = 'HELP_TREE_ROOT=' UNION ALL -- 责任 ,共 1138笔 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10003' , '责任' ) as level_code, fpv.level_id, fpv.level_value, ( SELECT FA.APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10002 AND ROWNUM = 1 ) AS "应用产品" , ( SELECT fr.RESPONSIBILITY_NAME from fnd_responsibility_vl FR where fr.APPLICATION_ID = fpv.level_value_application_id and to_char(fr.RESPONSIBILITY_ID) = fpv.level_value AND fpv.LEVEL_ID = 10003 AND ROWNUM = 1) AS "责任" , '' as "用户" , '' AS "服务器" , '' AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10003 -- 10003: 责任 -- AND fpo.profile_option_name = 'DIAGNOSTICS' UNION ALL -- 用户 ,共 294 笔 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10004' , '用户' ) as level_code, fpv.level_id, fpv.level_value, ( SELECT FA.APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10002 AND ROWNUM = 1 ) AS "应用产品" , ( SELECT fr.RESPONSIBILITY_NAME from fnd_responsibility_vl FR where fr.APPLICATION_ID = fpv.level_value_application_id and to_char(fr.RESPONSIBILITY_ID) = fpv.level_value AND fpv.LEVEL_ID = 10003 AND ROWNUM = 1) AS "责任" , ( SELECT FU.USER_NAME FROM FND_USER FU WHERE TO_CHAR(FU.USER_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10004 AND ROWNUM = 1 ) as "用户" , '' AS "服务器" , '' AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10004 -- 10004: 用户 -- and fpv.level_value = 21084 -- AND fpo.profile_option_name = 'DIAGNOSTICS' UNION ALL -- 服务器 ,共 1 笔 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10005' , '服务器' ) as level_code, fpv.level_id, fpv.level_value, ( SELECT FA.APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = FPV.LEVEL_VALUE AND ROWNUM = 1 ) AS "应用产品" , ( SELECT fr.RESPONSIBILITY_NAME from fnd_responsibility_vl FR where fr.APPLICATION_ID = fpv.level_value_application_id and to_char(fr.RESPONSIBILITY_ID) = fpv.level_value AND ROWNUM = 1) AS "责任" , ( SELECT FU.USER_NAME FROM FND_USER FU WHERE TO_CHAR(FU.USER_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10004 AND ROWNUM = 1 ) as "用户" , ( SELECT NODE_NAME FROM FND_NODES FN WHERE TO_CHAR(FN.NODE_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10005 AND ROWNUM = 1 ) AS "服务器" , '' AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10005 -- 10005: 服务器 -- and fpv.level_value = 21084 -- AND fpo.profile_option_name = 'DIAGNOSTICS' UNION ALL -- 组织 ,共 4 笔 SELECT --fpo.application_id, --fpo.PROFILE_OPTION_ID, fpo.profile_option_name , fpo.USER_PROFILE_OPTION_NAME, fpv.profile_option_value, decode(fpv.level_id, '10006' , '组织' ) as level_code, fpv.level_id, fpv.level_value, ( SELECT FA.APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = FPV.LEVEL_VALUE AND ROWNUM = 1 ) AS "应用产品" , ( SELECT fr.RESPONSIBILITY_NAME from fnd_responsibility_vl FR where fr.APPLICATION_ID = fpv.level_value_application_id and to_char(fr.RESPONSIBILITY_ID) = fpv.level_value AND ROWNUM = 1) AS "责任" , ( SELECT FU.USER_NAME FROM FND_USER FU WHERE TO_CHAR(FU.USER_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10004 AND ROWNUM = 1 ) as "用户" , ( SELECT NODE_NAME FROM FND_NODES FN WHERE TO_CHAR(FN.NODE_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10005 AND ROWNUM = 1 ) AS "服务器" , ( SELECT HOU. NAME FROM HR_ORGANIZATION_UNITS HOU WHERE TO_CHAR(HOU.ORGANIZATION_ID) = FPV.LEVEL_VALUE AND fpv.LEVEL_ID = 10006 AND ROWNUM = 1 ) AS "组织" , fpv.level_value2, fpv.level_value_application_id, fpv.creation_date, fpv.last_update_date -- ,fpv.* FROM FND_PROFILE_OPTIONS_VL fpo, fnd_profile_option_values fpv WHERE 1=1 -- AND fpv.APPLICATION_ID = 0 and fpo.APPLICATION_ID= fpv.application_id and fpo.PROFILE_OPTION_ID = fpv.profile_option_id AND fpv.LEVEL_ID = 10006 -- 10006: 组织 -- and fpv.level_value = 21084 -- AND fpo.profile_option_name = 'DIAGNOSTICS' |
全部查询大约1.1万行记录。
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了