DBA Data[Home] [Help] [Dependency Information]

TABLE: WSH.WSH_LOCATION_DATA_EXT

Object Details
Object Name: WSH_LOCATION_DATA_EXT
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_LOCATION_DATA_EXT
Subobject Name:
Status: VALID


Stores externally imported location information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000332022C00018$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000332022C00019$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
WSH_LOCATION_DATA_EXT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATE
WSH_LOCATION_DATA_EXT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCITY
WSH_LOCATION_DATA_EXT_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnZIP_CODE
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER

Unique Identifier
ZIP_CODE VARCHAR2 (40)
Postal Code
DST_INDICATOR VARCHAR2 (1)
Boolean flag . Y if DST applies, N otherwise
GMT_OFFSET NUMBER

Offset from GMT
DST_START_DATE DATE

Day light savings start date
DST_END_DATE DATE

Day light savings end date
COUNTRY VARCHAR2 (100)
Country
STATE VARCHAR2 (100)
State / Province
COUNTY VARCHAR2 (100)
County
CITY VARCHAR2 (100)
City
ADMIN_BOUND_ID NUMBER

State Admin bound ID (not used in WSH/MST)
ZIP_CENTROID SDO_GEOMETRY (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOCATION_ID
,      ZIP_CODE
,      DST_INDICATOR
,      GMT_OFFSET
,      DST_START_DATE
,      DST_END_DATE
,      COUNTRY
,      STATE
,      COUNTY
,      CITY
,      ADMIN_BOUND_ID
,      ZIP_CENTROID
FROM WSH.WSH_LOCATION_DATA_EXT;

Dependencies

[top of page]

WSH.WSH_LOCATION_DATA_EXT references the following:

SchemaMDSYS
TYPESDO_ELEM_INFO_ARRAY
TYPESDO_GEOMETRY
TYPESDO_ORDINATE_ARRAY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
WSH.WSH_LOCATION_DATA_EXT is referenced by following:

SchemaAPPS
SynonymWSH_LOCATION_DATA_EXT