OE.WAREHOUSES (table)

From dbscript Online Help
Revision as of 18:06, 2 May 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.WAREHOUSES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table OE.WAREHOUSES


Column Data Type Nullable Default PK Index
WAREHOUSE_ID NUMBER not null WAREHOUSES_PK
WAREHOUSE_SPEC SYS.XMLTYPE null
WAREHOUSE_NAME VARCHAR2 null
LOCATION_ID NUMBER 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