Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
OE WAREHOUSES (table)
Print
RSS
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
HR LOCATIONS (table)
OE INVENTORIES (table)
HR LOCATIONS (table)
OE INVENTORIES (table)
»
OE WAREHOUSES (table)
[X]
»
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.