This is a followup to a question I asked in the SCM forum but was asked to post EAM questions here by Sandeep who answered my previous questions graciously.
A> I am tracking a specific situation- when every operation assigned to a work order is completed I need to execute a pl/sql Concurrent program.
For this one I think the work order status would be changed to complete?
B>I am also tracking another situation- When a resource is assigned to a work order I need to execute a pl/sql conc prog.
What table info gets set when this happens?
A> WIP_MOVE_TRANSACTIONS is probably what you are looking for. Write a trigger on that table.
B> WIP_OPERATION_RESOURCES is the table used. So you can write a trigger on that table.
Hope this helps,