EBS Customizations (MOSC)

MOSC Banner

Trying to add the buyers name to the Blanket Notification Expiration alert

edited Feb 28, 2018 12:35PM in EBS Customizations (MOSC) 2 commentsAnswered ✓

Hello Gurus,

I would like to add the buyers name to the below sql statement. The requirement is to add the buyers name who is creating the blanket agreement. Below is screen shot of how the output looks like. Please advise.

SELECT    email_address,

          po_num,

          end_date,

          start_date_active,

          notification_id         

INTO      &EMAIL,

          &PO_NUM,

          &EXP_DATE,

          &MSG_DATE,

          &NOTIFICATION_ID 

FROM      po_alert_blanket_view                

WHERE     notification_condition_code = 'EXPIRATION'

AND       trunc(sysdate) >= start_date_active

AND       trunc(sysdate) <= end_date_active

AND       end_date IS NOT NULL

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