EBS:订单事务类型查询之流程分配
EBS R12订单类型的流程名称 查询
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 | SELECT OTTT.transaction_type_id, ottt.language, ottt. name as transaction_type_name, ottt.description as LINE_transaction_desc, WF.ASSIGNMENT_ID AS "分配ID" , OTTL.TRANSACTION_TYPE_ID AS LINE_TYPE_ID, ottL. name as "工作流行类型" , --ottL.description as LINE_transaction_desc, WF.PROCESS_NAME AS "流程名称CODE" , WA.DISPLAY_NAME AS "流程名称" , WF.START_DATE_ACTIVE AS "开始日期" , WF.END_DATE_ACTIVE AS "结束日期" , WF.LAST_UPDATE_DATE AS "更新日期" -- ,WF.* FROM ONT.oe_workflow_assignments wf, -- 订单类型分配 ONT.OE_TRANSACTION_TYPES_TL OTTT, ONT.oe_transaction_types_all ott, ONT.OE_TRANSACTION_TYPES_TL OTTL, -- 订单行类型 ( SELECT wav.display_name, wav.description, wav.item_type, wav. name , MAX (wav.version) FROM apps.wf_activities_vl wav WHERE wav.TYPE = 'PROCESS' AND NVL (wav.end_date, SYSDATE) >= SYSDATE AND wav.item_type IN ( 'OEOL' , 'OEOH' ) AND wav.runnable_flag = 'Y' AND wav. name NOT LIKE 'UPG_%' GROUP BY wav.display_name, wav.description, wav. name , wav.item_type ) WA -- 流程名称 WHERE WF.ORDER_TYPE_ID = OTT.TRANSACTION_TYPE_ID -- AND WF.ORDER_TYPE_ID = 1055 AND OTTT.TRANSACTION_TYPE_ID = OTT.TRANSACTION_TYPE_ID AND OTTT.LANGUAGE = USERENV( 'LANG' ) AND WF.LINE_TYPE_ID = OTTL.TRANSACTION_TYPE_ID(+) AND OTTL.LANGUAGE(+) = USERENV( 'LANG' ) AND WF.PROCESS_NAME = WA. NAME (+) AND OTTT. NAME LIKE '6%' -- AND OTTL.NAME LIKE '仅发运行' --行流 - 通用;仅限于发运 ORDER BY OTTT. NAME , OTTL. NAME ; |
注意 APPS.WF_ACTIVITIES_VL.NAME
N: OM》》设置》》事务处理类型》》定义 。
优质生活从拆开始
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步