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

  

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