OE.INVENTORIES (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Check Constraints 1.5 Foreign Keys 1.6 Dependencies

wikibot

Table	OE.INVENTORIES
Description	Tracks availability of products by product_it and warehouse_id.

Columns

Column	Data Type	Nullable	Default	Description
PRODUCT_ID	NUMBER(6, 0)	not null		Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_ID	NUMBER(3, 0)	not null		Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HAND	NUMBER(8, 0)	not null

Primary Key

Primary Key	Columns
INVENTORY_IX	WAREHOUSE_ID, PRODUCT_ID

Indexes

Index	Type	Columns
INV_PRODUCT_IX		PRODUCT_ID

Check Constraints

Check Constraint	Expression	Description
INVENTORY_QOH_NN	"QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN	"WAREHOUSE_ID" IS NOT NULL

Foreign Keys

Relation	Column	Referenced Column
OE.PRODUCT_INFORMATION	PRODUCT_ID	PRODUCT_ID
OE.WAREHOUSES	WAREHOUSE_ID	WAREHOUSE_ID

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	OE.BOMBAY_INVENTORY
Select	View	OE.OC_INVENTORIES
Select	View	OE.SYDNEY_INVENTORY
Select	View	OE.TORONTO_INVENTORY