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');

Query to check the workflow assigned to an order type

Query to check the workflow assigned to an order type

  SELECT ot.order_type_id,

         ot.name order_type_name,

         ot.description,

         ot.start_date_active,