查询系统中配置文件的配置情况

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
             FROM FND_USER
            WHERE USER_NAME NOT IN
                  ('*ANONYMOS*',
                   'CONVERSION',
                   '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, '地点' 文件安全性
          FROM DUAL
        UNION
        SELECT 10002 LEVEL_ID, '应用产品' 文件安全性
          FROM DUAL
        UNION
        SELECT 10003 LEVEL_ID, '责任' 文件安全性
          FROM DUAL
        UNION
        SELECT 10004 LEVEL_ID, '用户' 文件安全性
          FROM DUAL
        UNION
        SELECT 10005 LEVEL_ID, '服务器' 文件安全性
          FROM DUAL
        UNION
        SELECT 10006 LEVEL_ID, '组织' 文件安全性
          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 like '%'