|
|
| Line 16: |
Line 16: |
| | WHERE i.warehouse_id=w.warehouse_id | | WHERE i.warehouse_id=w.warehouse_id |
| | </pre> | | </pre> |
| − |
| |
| − | === References ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | Table
| |
| − | | [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
| |
| − |
| |
| − | |}
| |
| − |
| |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.OC_PRODUCT_INFORMATION_(view)|OE.OC_PRODUCT_INFORMATION]]
| |
| − |
| |
| − | |}
| |
Latest revision as of 10:34, 27 August 2011
wikibot[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
