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 |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2022-03-17 WPS不能编辑