11 March 2009

Oracle Sales Fulfillment Setup

In Order transaction setup fulfillment list of values are coming from Workflow tables.

SQL :

select display_name, description, item_type, name, max(version)
from
wf_activities_vl where type = 'PROCESS' and nvl(end_date, sysdate) >=
sysdate and item_type = 'OEOH' and runnable_flag = 'Y' and name not like
'UPG_%' group by display_name, description, name, item_type