oracle alert

 

問題描述  Question Description:

 

 

請發行以下二種Notes Alert,格式、發布時間、發布人員請比照「外包工單無Resource」即可,謝謝。

1. 工單無RoutingNKPCKP開頭的工單瀘掉,此二類工單不需確認

2. 工單無入庫倉別或無發料倉別

程式如下:

--工單無Routing

select we.wip_entity_name

  from wip_entities we

      ,wip_discrete_jobs wdj

 where we.organization_id = wdj.organization_id

   and we.wip_entity_id = wdj.wip_entity_id

   and we.organization_id = 427

   and wdj.status_type in (1,3,6)

   andupper(we.wip_entity_name) notlike'NKP%'

   andupper(we.wip_entity_name) notlike'CKP%'

   andnotexists (select1

                     from wip_operations wo

                    where wo.wip_entity_id = we.wip_entity_id

                      and wo.organization_id = we.organization_id

                      and wo.organization_id = 427)

 

 

--工單無入庫倉別或無發料倉別

 

SELECT we.wip_entity_name

      ,decode(wdj.status_type,1,'Unreleased',3,'Released',6,'Ohand')

  FROM wip_entities we

      ,wip_discrete_jobs wdj

      ,wip_requirement_operations wro

 where we.organization_id = wdj.organization_id

   and we.wip_entity_id = wdj.wip_entity_id

   and we.organization_id = wro.organization_id

   and we.wip_entity_id = wro.wip_entity_id

   and we.organization_id = 427

   and wdj.status_type in (1,3,6)

   and (wdj.completion_subinventory isnullor wro.supply_subinventory isnull)

   and wro.wip_supply_type < 4

 groupby we.wip_entity_name

         ,wdj.status_type

 

 Form

  

 

 Action按钮,(action name:自己定义)

 

Action Details按钮

 

Action set 按钮(Action set name自定义,将上步定义的Action放入set中)

 

点击Action Set Detail按钮

 

action detail按钮

 

邮件发不出去(没有激活)

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值