ONT Workflow Assignments
Description
- Categories
- BI Publisher
- Application
- Order Management
- Source
- Workflow Assignments Report (XML)
- Short Name
- OEXWFASG_XML
- DB package
- ONT_OEXWFASG_XMLP_PKG
Imported from BI Publisher
Workflow Assignments Report
Workflow Assignments Report
SQL 26 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Order Type (From) | LOV Oracle | |
| Order Type (To) | LOV Oracle |