OE.WAREHOUSES (table) - Revision history

Bot at 05:16, 24 June 2010

2010-06-24T05:16:08Z

Bot at 07:28, 11 February 2010

2010-02-11T07:28:58Z

Bot at 19:01, 24 August 2009

2009-08-24T19:01:15Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.WAREHOUSES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

2009-05-02T17:06:17Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.WAREHOUSES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| OE.WAREHOUSES
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[HR.LOCATIONS_(table)|HR.LOCATIONS]]
| LOCATION_ID
| LOCATION_ID
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
| WAREHOUSE_ID
| WAREHOUSE_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | OE.WAREHOUSES
@@ Line 8: / Line 8: @@
 | '''Description
 | Warehouse data unspecific to any industry.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | WAREHOUSE_ID
 | NUMBER(3, 0)
@@ Line 27: / Line 25: @@
+|
 | Primary key column.
-|-
+|- valign="top"
 | WAREHOUSE_SPEC
 | SYS.XMLTYPE
@@ Line 33: / Line 31: @@
+|
+|
-|-
+|- valign="top"
 | WAREHOUSE_NAME
 | VARCHAR2(35)
@@ Line 39: / Line 37: @@
+|
+|
-|-
+|- valign="top"
 | LOCATION_ID
 | NUMBER(4, 0)
@@ Line 45: / Line 43: @@
+|
+|
-|-
+|- valign="top"
 | WH_GEO_LOCATION
 | MDSYS.SDO_GEOMETRY
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | WAREHOUSES_PK
 | WAREHOUSE_ID
@@ Line 69: / Line 67: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | WHS_LOCATION_IX
+|
@@ Line 82: / Line 80: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HR.LOCATIONS_(table)|HR.LOCATIONS]]
 | LOCATION_ID
@@ Line 95: / Line 93: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[OE.INVENTORIES_(table)|OE.INVENTORIES]]
 | WAREHOUSE_ID
 | WAREHOUSE_ID
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | OE.WAREHOUSES
 |-
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 15: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description
 |-
@@ Line 23: / Line 26: @@
 | not null
+|
-| WAREHOUSES_PK
+| Primary key column.
 |-
 | WAREHOUSE_SPEC
 | SYS.XMLTYPE
 | null
+|
+|
@@ Line 36: / Line 37: @@
 | VARCHAR2(35)
 | null
+|
+|
@@ Line 45: / Line 45: @@
+|
+|
 |-
 | WH_GEO_LOCATION
@@ Line 51: / Line 50: @@
 | null
+|
+| Primary key column, references hr.locations.location_id.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 69: / Line 89: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"