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