|
|
| (One intermediate revision 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 === | | === Source === |
| Line 18: |
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
| |
| − |
| |
| − | |-
| |
| − | | 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
| |
| − |
| |
| − | |-
| |
| − | | 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
