EBS:订单事务类型查询之流程分配

EBS R12订单类型的流程名称 查询

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