Querying on WF_EVENT_T Data type column

Querying on WF_EVENT_T Data type column

WF_EVENT_T is defined as an object type with many sub-types in it.  To query on WF_EVENT_T data type column, you can convert that to a table and filter on top of it.

Example:

SELECT *

  FROM apps.wf_deferred d

 WHERE     corrid = 'APPS:oracle.apps.ar.receipts.CashReceipt.create'

       AND (SELECT VALUE

              FROM TABLE (d.user_data.parameter_list) t

             WHERE t.name = 'PAYMENT_SCHEDULE_ID') = '239180052';