OE.OC_INVENTORIES_(view)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''View'''
| OE.OC_INVENTORIES
|}

=== Source ===
{{{{<nowiki>
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
</nowiki>}}}}

ScrewTurn Wiki

Navigation

OE.OC_INVENTORIES_(view)