EBS:个性化活动查询

-- 
-- FND-个性化活动.sql
SELECT FFCR.ID,
       FFCR.FUNCTION_NAME,
       FFCR.DESCRIPTION,
       FFCR.TRIGGER_EVENT,
       FFCR.TRIGGER_OBJECT,
       FFCR.CONDITION,
       FFCR.SEQUENCE,
       FFCR.FORM_NAME,
       DECODE(FFCR.RULE_TYPE,'A','Function','F','Form',
         FFCR.RULE_TYPE) AS "LEVEL",
       FFCR.ENABLED,
       DECODE(FFCR.FIRE_IN_ENTER_QUERY,'Y','Both','N','Not in Enter-Query Mode',
            'O','Only in Enter-Query Mode',
            FFCR.FIRE_IN_ENTER_QUERY) AS "PROCESSING_MODE",
       FFCR.RULE_KEY ,
       FFCA.ACTION_ID, 
       FFCA.SEQUENCE AS "ACTION_SEQ",
       DECODE(FFCA.ACTION_TYPE,'P','Property','M','Message', 
              'B','Builtin','S','Menu',
       FFCA.ACTION_TYPE ) AS "ACTION_TYPE",
       FFCA.SUMMARY AS "ACTION_DESCRION",
       -- when action_type=message begin ;
       DECODE(FFCA.MESSAGE_TYPE,'W','Warn' ,
              'E','Error',
              'S','Show',
              'H','Hint',
              'D','Debug',
          FFCA.MESSAGE_TYPE ) AS "MESSAGE_TYPE",
       FFCA.MESSAGE_TEXT , 
       -- when action_type=message end ;
       -- when action_type=property begin ;
       DECODE(FFCA.OBJECT_TYPE ,'VAR','Local Variable', FFCA.OBJECT_TYPE ) AS "OBJECT_TYPE",
       FFCA.TARGET_OBJECT AS "TARGET_OBJECT",
       DECODE(FFCA.PROPERTY_NAME, 0,'VALUE', FFCA.PROPERTY_NAME) AS "PROPERTY_NAME",
       FFCA.PROPERTY_VALUE,
       -- when action_type=property end ;
       -- when action_type=builtin begin ;
       DECODE(FFCA.BUILTIN_TYPE,'R','RAISE_FORM_TRIGGER_FAILURE',
         'F','FORMS_DDL',
         'E','Launch a Funtion',
         'C','Launch SRS Form',
         'U','Launch a URL',
         'D','DO_KEY',
         'P','Execute a Procedure',
         'G','GO_ITEM',
         'B','GO_BLOCK',
         'T','EXECUTE_TRIGGER',
         'S','SYNCHRONIZE',
         'L','Call Custom Library',
         'Q','Create Record Group from Query',
         'X','Set Profile Value in Cache',
        FFCA.BUILTIN_TYPE ) AS "BUILTIN_TYPE",
        FFCA.BUILTIN_ARGUMENTS AS "ARGUMENT",
        FFCA.MENU_ARGUMENT_SHORT AS "FUNCTION_CODE",
       ( SELECT FFF.USER_FUNCTION_NAME FROM APPS.FND_FORM_FUNCTIONS_VL FFF
         WHERE FFF.FUNCTION_NAME = FFCA.MENU_ARGUMENT_SHORT AND ROWNUM=1 )  AS "FUNCATION_NAME",
       FFCA.MENU_ARGUMENT_LONG AS "PARAMETERS", 
       
       -- when builtin_type= E begin ;
       FFCA.MENU_ENTRY ||':'|| FFCA.MENU_LABEL AS "MENU_ENTRY",
       FFCA.MENU_LABEL,
       FFCA.MENU_SEPERATOR,
       FFCA.MENU_ENABLED_IN ,
       -- when builtin_type= E end ;
       -- when action_type=builtin end ;
       FFCA.LAST_UPDATE_DATE AS "更新日期"
     --  ,FFCA.* 
  FROM APPS.FND_FORM_CUSTOM_RULES  FFCR , -- 个性化 
       APPS.FND_FORM_CUSTOM_ACTIONS FFCA -- 活动
 WHERE 1=1 --
   and FFCR.FORM_NAME IN ('INVIDITM') 
   AND FFCR.ID = FFCA.RULE_ID  
  -- AND FFCR.SEQUENCE = 30 
 ORDER BY FFCR.ID, FFCA.SEQUENCE