ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
OE.WAREHOUSES_(table)
Print
RSS
Modified: 2011/08/27 11:08 by
wikibot
-
Uncategorized
»
OE.WAREHOUSES_(table)
[X]
»
OE.WAREHOUSES_(table)
Edit
wikibot
Table
OE.WAREHOUSES
Description
Warehouse data unspecific to any industry.
Edit
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.
Edit
Primary Key
Primary Key
Columns
WAREHOUSES_PK
WAREHOUSE_ID
Edit
Indexes
Index
Type
Columns
WHS_LOCATION_IX
LOCATION_ID
Edit
Foreign Keys
Relation
Column
Referenced Column
HR.LOCATIONS
LOCATION_ID
LOCATION_ID
Edit
Detail Tables
Detail Table
Column
Referencing Column
OE.INVENTORIES
WAREHOUSE_ID
WAREHOUSE_ID
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.