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》》设置》》事务处理类型》》定义 。

 

posted @   samrv  阅读(70)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示