[Home] [Help] [Dependency Information]
Object Name: | XNP_GEO_AREAS_B |
---|---|
Object Type: | TABLE |
Owner: | XNP |
FND Design Data: | XNP.XNP_GEO_AREAS_B |
Subobject Name: | |
Status: | VALID |
XNP_GEO_AREAS_B stores given geographic areas.
There can be hierarchy of geographic areas.
EXAMPLE: EU Europe, WE West Europe, PA Paris, US, United States of America, CA California
SF San Francisco, LA Los Angeles
In the context of NP, Geographic areas are used to describe the area covered by a Service provider,
Routing Number and Number Range.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XNP_GEO_AREAS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | GEO_AREA_ID |
XNP_GEO_AREAS_B_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
GEO_AREA_TYPE_CODE
CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GEO_AREA_ID | NUMBER | Yes | Geographic Area identifier | |
GEO_AREA_TYPE_CODE | VARCHAR2 | (10) | Yes | Type of Geographic Area |
CODE | VARCHAR2 | (20) | Yes | Code for Geographic Area |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Indicates if geographic area is active |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT GEO_AREA_ID
, GEO_AREA_TYPE_CODE
, CODE
, ACTIVE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_GEO_AREAS_B;
XNP.XNP_GEO_AREAS_B does not reference any database object
XNP.XNP_GEO_AREAS_B is referenced by following:
|
|
|