Delmiaworks Oracle SQL Queries

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.