VbzCart/queries/qryRstkReq by PurchOrd

About

 * Purpose: One of two queries which are UNIONed to create
 * Requires:
 * History:
 * 2008-12-22 Adapted from the discarded query qryCbxRestock_by_PurchOrd

SQL
CREATE OR REPLACE VIEW qryRstkReq_by_PurchOrd AS SELECT r.ID, CAST(r.PurchOrdNum AS CHAR) AS Descr, NOT IsLocked AS IsOpen, r.WhenOrdered, r.WhenConfirmed, r.ID_Supplier FROM rstk_req AS r WHERE r.PurchOrdNum IS NOT NULL ORDER BY COALESCE(r.WhenKilled,r.WhenOrdered,r.WhenCreated) DESC;