https://github.com/061375/IQMS-PLSQL-Snippets
An ongoing list of PL/SQL queries I have used while working in Delmiaworks formerly IQMS.
I am updating them regularly on my Github.
Here is a list of some of the more useful ones:
- aq_cogs_qtr.sql – A function that returns the Cost of Goods and Services by quarter for a given year
- aq_create_backups.sql – A procedure that backs up the specified table. Takes WHERE as an argument.
- aq_trigger_add_supplier.sql – A useful trigger for EDI customers who have several or dynamic ship to locations. This automatically adds the service code for a given customer when a new ship to is added.
- aq_trigger_addnegwo_loc.sql – When a user moves the center schedule position this adds a zero location for the work order.
- aq_trigger_bi_ps_ticket.sql – Automatically add a note to the pick ticket when new pick ticket is added for specified items and customer(s)
- std_future_cost_comparison.sql – Compare the difference of the current standard cost and estimated future cost of all items.
- v_aq_search_iqalert_sql.sql – A view to quickly search the IQAlert tables that use a SQL query.
