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
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 |