ONT Workflow Assignments

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Workflow Assignments Report
Application: Order Management
Source: Workflow Assignments Report (XML)
Short Name: OEXWFASG_XML
DB package: ONT_OEXWFASG_XMLP_PKG
Run ONT Workflow Assignments and other Oracle EBS reports with Blitz Report™ on our demo environment
select ot.order_type_id, 
          ot.name order_type_name, 
          ot.description, ot.start_date_active,
          ot.end_date_active, ot.order_category_code,
          olt1.name default_inbound_line_type, 
          olt2.name default_outbound_line_type, 
          wf.display_name order_workflow
from wf_activities_vl wf,
          oe_workflow_assignments owa ,
          oe_order_types_v ot,
          oe_line_types_v olt1,
          oe_line_types_v olt2
          where  &lp_where_clause
          ot.default_inbound_line_type_id = olt1.line_type_id(+)
          and ot.default_outbound_line_type_id = olt2.line_type_id(+)
          and owa.order_type_id = ot.transaction_type_id 
          and owa.line_type_id is null
          and wf.name = owa.process_name
          and  wf.item_type = 'OEOH' 
          and wf.version = (select max(version)
		   from wf_activities_vl wf1
	                     where wf1.name = wf.name
                   	   and wf1.item_type = 'OEOH')
          and  trunc(sysdate) <= nvl(owa.end_date_active, sysdate)
          ORDER BY ot.name
Parameter Name SQL text Validation
Operating Unit
 
LOV
Order Type (From)
 
LOV Oracle
Order Type (To)
 
LOV Oracle