EBS: 查询个性化消息的有哪些个性化程序

 

查询 个性化消息的有哪些个性化程序

-- N:帮助>>诊断>>自定义代码>>个性化 
 SELECT FFCR.ID , 
        FFCR.FUNCTION_NAME AS "函数名",
        FFCR.FORM_NAME AS "表单",
        FFCR.SEQUENCE AS "序号",
        FFCR.DESCRIPTION AS "说明",
        DECODE(FFCR.RULE_TYPE,'A','功能','F','表单') AS "层",
        FFCR.ENABLED AS "启用",
        FFCR.TRIGGER_EVENT AS "条件-触发器事件",
        FFCR.TRIGGER_OBJECT AS "条件-触发器对象",
        FFCR.CONDITION AS "条件-条件"，
        FFCR.FIRE_IN_ENTER_QUERY AS "条件-处理模式",
       -- FFCR.LAST_UPDATE_DATE 
        ffca.SEQUENCE as "活动-序号" ,
        DECODE(FFCA.ACTION_TYPE,'B','内置','M','消息','P','特性','S','菜单') AS "活动-类型", 
        FFCA.SUMMARY AS "活动-说明",
        FFCA.LANGUAGE AS "活动-语言",
        DECODE(FFCA.MESSAGE_TYPE,'D','调试','E','错误','H','提示','S','显示',
          'W','警告',FFCA.MESSAGE_TYPE
        ) AS "消息类型",
        FFCA.MESSAGE_TEXT AS "消息文本",
        DECODE(FFCA.BUILTIN_TYPE,'R','RAISE FORM_TRIGGER_FAILURE','C','C','D','D', FFCA.BUILTIN_TYPE)  AS "内置类型",
        FFCA.BUILTIN_ARGUMENTS AS "变元",  -- 
        DECODE(FFCA.OBJECT_TYPE,'ITEM','项目',FFCA.OBJECT_TYPE) AS "对象类型",
        FFCA.TARGET_OBJECT AS "目标对象",
       -- FFCA.FOLDER_PROMPT_BLOCK,
        (SELECT FCPL.PROPERTY_NAME 
           FROM APPLSYS.FND_FORM_CUSTOM_PROP_LIST FCPL
          WHERE FIELD_TYPE= FFCA.OBJECT_TYPE
            AND FCPL.PROPERTY_ID = FFCA.PROPERTY_NAME
         ) AS "特性名称",
        DECODE(FFCA.PROPERTY_VALUE,'4','TRUE','5','FALSE',FFCA.PROPERTY_VALUE) AS "值"
      --  ,FFCR.* 
  FROM  APPS.FND_FORM_CUSTOM_RULES FFCR,
        APPS.FND_FORM_CUSTOM_ACTIONS ffca 
 where 1=1
   AND FFCR.ID = FFCA.RULE_ID 
  -- and FFCR.DESCRIPTION LIKE '循环带入可用数量，保留数量' --'查询搬运单数据'
  AND  FFCA.message_text like  '%%'  ---"消息文本",
  and FFCR.FORM_NAME like 'OEXOEORD' -- 'WSHFSTRX'  -- "表单"
  AND FFCA.ACTION_TYPE = 'M'  -- 活动-类型  M:消停 
  -- AND FFCR.FUNCTION_NAME LIKE 'WSHFSTRX'  -- 功能名称 
 -- AND FFCR.DESCRIPTION LIKE '进入交货页签即失效交货号栏位'  -- '离开行时当装箱单已审批不允许修改发运数量'
ORDER BY FFCR.FORM_NAME, FFCR.SEQUENCE ,
      ffca.SEQUENCE