問題描述 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_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按钮
邮件发不出去(没有激活)