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: 2009/08/29 21:04 by
wikibot
-
Uncategorized
»
SH.DR$SUP_TEXT_IDX$R_(table)
»
OE.WAREHOUSES_(table)
[X]
»
SH.DR$SUP_TEXT_IDX$R_(table)
»
OE.WAREHOUSES_(table)
Edit
wikibot
Table
OE.WAREHOUSES
Column
Data Type
Nullable
Default
PK
Index
WAREHOUSE_ID
NUMBER(3, 0)
not null
WAREHOUSES_PK
WAREHOUSE_SPEC
SYS.XMLTYPE
null
WAREHOUSE_NAME
VARCHAR2(35)
null
LOCATION_ID
NUMBER(4, 0)
null
WHS_LOCATION_IX
WH_GEO_LOCATION
MDSYS.SDO_GEOMETRY
null
Relation
Column
Referenced Column
HR.LOCATIONS
LOCATION_ID
LOCATION_ID
Detail Table
Column
Referencing Column
OE.INVENTORIES
WAREHOUSE_ID
WAREHOUSE_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.