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   

  

posted @   samrv  阅读(89)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
历史上的今天:
2022-03-17 WPS不能编辑
点击右上角即可分享
微信分享提示