admin 發表於 2015-11-13 15:14:40

Execute Online SQL on Custom Event

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: '||'&NEW:LINE_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:
頁: [1]
查看完整版本: Execute Online SQL on Custom Event