Oracle alert
Dear colluguesI have a problem with alert.
I need an alert for rejected PO, for direct person. Request is:
select
cc.action_code,
cc.action_date,
cc.note,
bb.segment1,
aa.user_name
into
&act,
&date,
¬e,
&PO_num
&Per
from po_action_history cc,
po_headers_all bb,
fnd_user aa
where cc.object_id = bb.po_header_id
and cc.last_updated_by = aa.user_id
and cc.action_date = sysdate
and cc.object_sub_type_code = 'STANDARD'
and cc.action_code = 'REJECT'
Action details
text :
Ваш ЗП № &PO_num
Был &act - ОТКЛОНЕН &date числа, по причине: ¬e
EVENT: application "Purchasing" and table "PO_ACTION_HISTORY"
I need an alert for rejected PO, for direct person. Request is:
select
cc.action_code,
cc.action_date,
cc.note,
bb.segment1,
aa.user_name
into
&act,
&date,
¬e,
&PO_num
&Per
from po_action_history cc,
po_headers_all bb,
fnd_user aa
where cc.object_id = bb.po_header_id
and cc.last_updated_by = aa.user_id
and cc.action_date = sysdate
and cc.object_sub_type_code = 'STANDARD'
and cc.action_code = 'REJECT'
Action details
text :
Ваш ЗП № &PO_num
Был &act - ОТКЛОНЕН &date числа, по причине: ¬e
EVENT: application "Purchasing" and table "PO_ACTION_HISTORY"
0