OE.OC INVENTORIES (view)
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 |