Category Archives: wf_activities_vl

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        … Continue reading

Posted in oe_debug_pub, oe_workflow_assignments, order type, wf_activities_vl, Workflows | Leave a comment

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,          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,          … Continue reading

Posted in oe_workflow_assignments, order type, wf_activities_vl, Workflows | Leave a comment