Workflow Pending payables approval [message #206581] |
Thu, 30 November 2006 10:56 |
smulukutla
Messages: 45 Registered: May 2006
|
Member |
|
|
I want to find out all the expense reports which are in the status of 'Pending Payables Approval'.
I went through the workflow tables, wf_items and wf_item_types, wf_notifications, wf_messages and wf_lookups.
In wf_lookups there is a column called lookup_type = 'AP_EXPENSE_REPORT_STATUS' and lookup_code = 'MGRAPPR' and meaning = 'Pending Payables Approval'.
My question is how to link the wf_lookups to wf_items and rest of the workflow tables.
Thanks.
|
|
|
|