Alert Subject to find Alert
select *
from alr_alerts a, alr_actions_v b
where a.alert_id = b.alert_id
and subject ='<Alert Name>';
from alr_alerts a, alr_actions_v b
where a.alert_id = b.alert_id
and subject ='<Alert Name>';
submit request output eamil to user
declare l_conc_id number; l_boolean boolean := TRUE; e_add_del exception; e_add_layout exception; e_set_option exception; e_set_repeat exception; begin -- intialize the apps. -- fnd_global.apps_initialize (10275, 52373, 222); fnd_global.apps_initialize (10275, 51953, 222); -- Adding delivery option to send the request output as email l_boolean := fnd_request.add_delivery_option (type => 'E' -- this one to speciy the delivery option as email ,p_argument1 => 'Delivery Option Test' -- subject for the mail ,p_argument2 => '100385@senao.com' -- from address ...
留言
張貼留言