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

 

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

?

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

-- 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