Home » Applications » Oracle Fusion Apps & E-Business Suite » Workflow Pending payables approval
Workflow Pending payables approval [message #206581] Thu, 30 November 2006 10:56 Go to next message
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.
Re: Workflow Pending payables approval [message #206640 is a reply to message #206581] Thu, 30 November 2006 23:11 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Why don't you have a look at etrm?

By
Vamsi
Previous Topic: Account Segment
Next Topic: Receivales A/c Lines Status
Goto Forum:
  


Current Time: Thu Jun 27 12:52:59 CDT 2024