OE.WAREHOUSES (table)

From dbscript Online Help
Revision as of 21:01, 24 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

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