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

TABLE: CSF.CSF_MD_POIS

Object Details
Object Name: CSF_MD_POIS
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_MD_POIS
Subobject Name:
Status: VALID


DEFINITION
This table defines POI (point of interest) for Map Display
EXAMPLE
Holiday Inn, Shell petrol station, etc.
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000083030C00016$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
SYS_IL0000083030C00017$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER (30) Yes A unique identifier for the POI.
FEATURE_CODE NUMBER
Yes The FEATURE CODE defines the type the POI.
FOOD_TYPE VARCHAR2 (240)
The FOOD TYPE defines the type of food served in restaurants.
IMPORTANCE VARCHAR2 (3) Yes The IMPORTANCE defines if the POI if of local or national importance.
POI_ADDRESS VARCHAR2 (240)
The POI ADDESS defines the streetname and house number of the POI.
TELEPHONE_NUMBER VARCHAR2 (240)
The POI telephone number
POPULATION NUMBER (25)
The POPULATION defines the estimated number of inhabitans of the city.
CHAIN_NAME VARCHAR2 (240)
The CHAIN NAME defines the name of the chain to which the POI belongs to.
INST_STYLE_ID NUMBER (30) Yes Generic unique identifier for an entity
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
Query Text

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


SELECT POI_ID
,      FEATURE_CODE
,      FOOD_TYPE
,      IMPORTANCE
,      POI_ADDRESS
,      TELEPHONE_NUMBER
,      POPULATION
,      CHAIN_NAME
,      INST_STYLE_ID
,      GEOMETRY
,      SECURITY_GROUP_ID
FROM CSF.CSF_MD_POIS;

Dependencies

[top of page]

CSF.CSF_MD_POIS references the following:

SchemaMDSYS
TYPESDO_GEOMETRY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
CSF.CSF_MD_POIS is referenced by following:

SchemaCSF
ViewCSF_MD_POIS#