SQL to find Automatic Collections Transaction Strategy Tasks with "To Be Created" status

Summary:

SQL to find Automatic Collections Transaction Strategy Tasks with "To Be Completed" status

Content (required):

Hi,

Looking here, at Strategy Tasks for a sample transaction in Collections:

I am trying to use SQL to extract Strategy Tasks with a status of "To Be Created" and a type of "Automatic" - shown in blue above.

This is what I have worked out so far:

• When a Strategy Task has a status of Completed, and the Start and End Dates are populated, I can see the relevant data in the IEX_STRATEGY_WORK_ITEMS table - yellow line above
• When a Strategy Task is manually added, and has a status of "To Be Created", and a type of "Manual", I can see the relevant data in the IEX_STRATEGY_USER_ITEMS table - green line above.