ONT Workflow Assignments

➜ Back to Library
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
Download
 
Related Blitz Reports
ONT Transaction Types and Line WF Processes ONT Credit Order Discrepancy ONT Credit Order Summary ONT Orders Summary AR Customers and Sites CAC Intercompany SO Price List vs. Item Cost Comparison ONT Orders and Lines PPF_WP3_OM_DETAILS ONT Unbooked Orders Detail
Blitz Report™

Blitz Report™ provides multiple benefits: