Monday 16 May 2016

Find the Workflow of Order or Line in Order Apps


To find the workflow for Sales Order or Line

SELECT transaction_type_id, tl.*
  FROM oe_transaction_types_tl tl
 WHERE name LIKE '%Non%Standard%';

  SELECT *
    FROM oe_order_lines_all
   WHERE line_type_id = :transaction_type_id 
     AND creation_date IS NOT NULL
ORDER BY creation_date DESC;

SELECT *
  FROM oe_order_headers_all
 WHERE header_id = 2374832;


To open the workflow for specific order, search the Order Number' IN "Sales Order  or Order organizer" form under "OM Superuser" responsibility and switch to Line then under Tools Menu CHECK THE workflow.

No comments:

Post a Comment