Difference between revisions of "OE.OC INVENTORIES (view)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
| '''view
+
| '''View
 
| OE.OC_INVENTORIES
 
| OE.OC_INVENTORIES
|-
 
 
|}
 
|}
  
 
+
=== Source ===
 
<pre>
 
<pre>
CREATE OR REPLACE SELECT i.product_id,
+
CREATE OR REPLACE VIEW OE.OC_INVENTORIES AS
 +
SELECT i.product_id,
 
           warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
 
           warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
 
           i.quantity_on_hand
 
           i.quantity_on_hand

Latest revision as of 10:34, 27 August 2011

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