1 of 1 people found this helpful
This is a very "quick-n-dirty" query that could obviously be polished up as you see fit:
select * from contact1 where accountno in (select accountno from contsupp where rectype = 'E' and address1 = 'AP Name')
In short, attached automated processes are stored in the CONTSUPP table with a RECTYPE = 'E' and the NAME of the specific automated process is stored in the address1 field. In the example above, the automated process is named "AP Name".
Hope this feedback helps. Please let me know if I need to clarify anything.
Thanks, John. This is exactly what I needed. I knew that it was in the contsupp with rectype = E but did not know the name of the field that contained the AP name.