OE.WAREHOUSES (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table OE.WAREHOUSES
Description Warehouse data unspecific to any industry.

Columns[edit]

Column Data Type Nullable Default Description
WAREHOUSE_ID NUMBER(3, 0) not null Primary key column.
WAREHOUSE_SPEC SYS.XMLTYPE null
WAREHOUSE_NAME VARCHAR2(35) null
LOCATION_ID NUMBER(4, 0) null
WH_GEO_LOCATION MDSYS.SDO_GEOMETRY null Primary key column, references hr.locations.location_id.

Primary Key[edit]

Primary Key Columns
WAREHOUSES_PK WAREHOUSE_ID

Indexes[edit]

Index Type Columns
WHS_LOCATION_IX LOCATION_ID

Foreign Keys[edit]

Relation Column Referenced Column
HR.LOCATIONS LOCATION_ID LOCATION_ID

Detail Tables[edit]

Detail Table Column Referencing Column
OE.INVENTORIES WAREHOUSE_ID WAREHOUSE_ID