Procurement - EBS (MOSC)

MOSC Banner

Oracle alert

edited Oct 8, 2013 5:02AM in Procurement - EBS (MOSC) 2 commentsAnswered
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,
      &note,
      &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 числа, по причине: &note
EVENT: application "Purchasing"  and table "PO_ACTION_HISTORY"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center