[SamWoodcock]

Have you considered 'externalising' the various notifications into refnums?

Quite often notifications are sent to entity Involved Parties. If you specify your IP Contact at a Location (or if you use a naming convention to join contacts to a location), then you can set refnum quals on the IPLocs to control which notifications should be 'turned on/off' for a given IPContact. Each notification would have its own related unique Location Refnum Qualifier. You could have a separate refnum qual for Pickup Estimates, Delivery Estimates, or any other custom workflow notification you want to build.

For example, I have a workflow to notify the ORDEROWNER when a new Order Base is created. Some ORDEROWNER's want to receive this alert, some don't. By attaching the refnum to the ORDEROWNER's location, I can control whether to send the alert or not by adding or deleting the refnum qual on the location. Similarly you can exclude/include refnums depending on the notification a given ORDEROWNER wants to receive.

The following SQL is used to Assign a variable in an agent (this is for an Order Base agent notification). Then, the variable is used as the Notify Contact.

SELECT NVL(
(SELECT INVOLVED_PARTY_CONTACT_GID
FROM ob_involved_party obip,
location_refnum lr
WHERE INVOLVED_PARTY_QUAL_GID = 'ORDEROWNER'
AND lr.location_gid = obip.INVOLVED_PARTY_CONTACT_GID
AND LOCATION_REFNUM_QUAL_GID=obip.domain_name
||'.OC-OB-CREATED_NOTIFY_IP'
AND obip.order_base_gid = $Gid
), ('ELX.DUMMY'))
FROM dual

---
Sam Woodcock
Mavenwire Consultant