Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

OE OC_INVENTORIES (view)

RSS
Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

wikibot

ViewOE.OC_INVENTORIES

Source

CREATE OR REPLACE VIEW OE.OC_INVENTORIES AS 
SELECT i.product_id,
           warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
           i.quantity_on_hand
    FROM inventories i, warehouses w
    WHERE i.warehouse_id=w.warehouse_id

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.