[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_POI_NAMES |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_LF_POI_NAMES |
Subobject Name: | |
Status: | VALID |
DEFINITION
Intersection table required since one POI can have multiple names (i.e. Exoonyms, Synonyms) and one Name can be shared by multiple POIs (e.g. Shell, Holiday Inn).
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_MEDIA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POI_NAME_ID | NUMBER | (30) | Yes | Surrogate key used for primary unique identifiers |
NAME_TYPE | VARCHAR2 | (1) | Yes | Indication if name is used as Official or Alternate Name for POI |
POI_ID | NUMBER | (30) | Yes | Unique identifier for POI Table |
NAME_ID | NUMBER | (30) | Yes | Unique key for Name |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
Cut, paste (and edit) the following text to query this object:
SELECT POI_NAME_ID
, NAME_TYPE
, POI_ID
, NAME_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_POI_NAMES;
CSF.CSF_LF_POI_NAMES does not reference any database object
CSF.CSF_LF_POI_NAMES is referenced by following:
|
|
|