OE.OC INVENTORIES (view)

From dbscript Online Help
Revision as of 10:34, 27 August 2011 by Bot (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot[edit]

View OE.OC_INVENTORIES

Source[edit]

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