Cottonwood Distributors processes the supplier quote updates in
a series of steps that are similar to the customer bid requests. However,
the supplier quotes query is not read-only because the program needs to update
the quotes. The listener application allows Cottonwood Distributors to inspect
the request before allowing the update to commit.
Here are the specific steps for the supplier quote requests:
The supplier quote request writes a message to the queue.
Based on the format of the message, the listener application invokes a Db2® function to extract
the request to update a quote for a part.
The applicaton reviews the previously lowest quote from that supplier
for that part. If the new quote is lower or if the quote is for a part not
previously supplied by that supplier, the application updates the database.
If the new quote is higher, Cottonwood Distributors might not make the update.
Instead, the Cottonwood application marks the quotes as something that the
Cottonwood marketing team should review later or to negotiate with the supplier.
The following graphic displays the complete flow for the supplier price
updates:Figure 1. Supplier
prices can be updated
