Execute Online SQL on Custom Event

admin

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: