Alert for release hold with line number
I have the alert for release hold but is planning to update it to alert on the specified line number, when the line number is being released. How should I set the action sets and action so that when the
1.SO is released in header, an alert with only SO number sent, without each line having the alert,
2.Specified line released, an alert for the that line sent.
3.Multiple line released, an summary alert with the lines sent.
I know it is a trigger event, is it possible to achieve 3?
select distinct
oh.ORDER_NUMBER,
RCUST.CUSTOMER_NAME,
rcust.CUSTOMER_NUMBER,
0