EBS: OM-订单类型之分配行流查询
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 | -- OM-订单类型之分配行流查询.sql ; select ( SELECT OU. NAME FROM HR_ORGANIZATION_UNITS OU WHERE OU.ORGANIZATION_ID= OTT.ORG_ID AND ROWNUM =1 ) AS "组织OU" , OTT. NAME AS "事务处理类型" , OWLA.assignment_id, OWLA.LINE_TYPE_ID, OWLA.LINE_TYPE AS "行类型" , OWLA.item_type_code AS "项目类型" , OWLA.PROCESS_NAME AS "流程名称代码" , WF.DISPLAY_NAME AS "流程名称" , OWLA.START_DATE_ACTIVE,OWLA.end_date_active -- , OWLA.* from OE_WF_LINE_ASSIGN_V OWLA, -- 流程分配 -- oe_workflow_assignments wf oe_transaction_types_all_vl ott, -- 事务处理类型 ( select display_name, description, item_type, name as process_name, max (version) as "VERSION" from wf_activities_vl where type = 'PROCESS' and nvl(end_date, sysdate) >= sysdate and item_type = 'OEOL' and runnable_flag = 'Y' and name not like 'UPG_%' group by display_name, description, name , item_type ) WF -- 流程 WHERE OWLA.ORDER_TYPE_ID = OTT.TRANSACTION_TYPE_ID AND OWLA.PROCESS_NAME = WF.process_name(+) -- AND OTT.ORG_ID = 281 ORDER BY OTT.ORG_ID, OTT. NAME ,OWLA.assignment_id |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了