oracle alert

 

問題描述  Question Description:

 

 

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

1. 工單無Routing（NKP及CKP開頭的工單瀘掉，此二類工單不需確認）

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_typein (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_typein (1,3,6)

   and (wdj.completion_subinventoryisnullor wro.supply_subinventoryisnull)

   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按钮

 

邮件发不出去（没有激活）