Welcome Guest, you are in: <root> • Login

Page History: OE OC_INVENTORIES (view)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 07:59

wikibot ¶

View	OE.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

References ¶

Dependency Type	Object Type	Referenced Object
Select	Table	OE.INVENTORIES

Dependencies ¶

Reference Type	Object Type	Referencing Object
Select	View	OE.OC_PRODUCT_INFORMATION