Query to check the line workflows assigned to an order type

exec MO_GLOBAL.SET_POLICY_CONTEXT('S',102);

SELECT OWA.order_type_id,

       ol.name,

       oe.meaning item_type_code,

       wf.display_name line_flow

  FROM wf_activities_vl wf,

       oe_workflow_assignments OWA,

       oe_line_types_v ol,

       oe_lookups oe

 WHERE     OWA.line_type_id = ol.line_type_id

       AND oe.lookup_type(+) = 'WF_ASSIGN_ITEM_TYPES'

       AND oe.lookup_code(+) = OWA.item_type_code

       AND wf.name = OWA.process_name

       AND wf.item_type = 'OEOL'

       AND wf.version =

              (SELECT MAX (version)

                 FROM wf_activities_vl wf1

                WHERE wf1.name = wf.name AND wf1.item_type = 'OEOL');

Copy existing sales order through Open interface

Copy an existing order by importing it through Open interface tables & Import orders program.

Provide the order number to copy & the order source id in the below code snippet.

DECLARE

   l_return_status       VARCHAR2 (1);

   l_order_number_from   NUMBER := <Order_Number1>;

   l_order_source_id     NUMBER := <Order_Source_ID>;