IF rec.person_id IS NOT NULL THEN
command_sys.mail('IFSADMIN',rec.person_id,'Hello,'||chr(13)||chr(13)||'A customer order line that you own an approval step for has been placed on hold.'||
chr(13)||'Customer Order: '||'&NEW:ORDER_NO'||chr(13)||'Line No: '||'&NEWINE_NO'||chr(13)||
'Release No: '||'&NEW:REL_NO'||chr(13)||'Hold Type: '||'&NEW:HOLD_TYPE'||
' '||hold_type_desc_||chr(13)||'Hold Reason: '||'&NEW:REASON'||chr(13)||chr(13)||
'Please take appropriate action.'||chr(13)||chr(13)||'Thanks,'||
chr(13)||'IFS Applications Administrator',null,null,null,'Order line hold'); Here’s an example from an event to send an e-mail:
|