OE WAREHOUSES (table)
wikibot
¶
Table
OE.WAREHOUSES
Description
Warehouse data unspecific to any industry.
Columns
¶
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
¶
Primary Key
Columns
WAREHOUSES_PK
WAREHOUSE_ID
Indexes
¶
Index
Type
Columns
WHS_LOCATION_IX
LOCATION_ID
Foreign Keys
¶
Relation
Column
Referenced Column
HR.LOCATIONS
LOCATION_ID
LOCATION_ID
Detail Tables
¶
Detail Table
Column
Referencing Column
OE.INVENTORIES
WAREHOUSE_ID
WAREHOUSE_ID