In-line query to retrieve workflow node where line is stuck

Hi,

Does anyone have a query to retrieve the actual workflow node of a sales order line that I can use?  I have written one massive select query in order to retrieve all ATP data for open orders in order to manage scheduling and am finding several issues with TM.  I can quickly identify these if I can pull in the workflow node it is stuck at but do not know the workflow schema well enough to write queries on it (looking for a cheat, basically).

Thanks,

Beverley