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