[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_GEO_AREAS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_ACT_GEO_AREAS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACT_GEO_AREA_ID | NUMBER | Yes | Unique Identifier. | |
OBJECT_VERSION_NO | NUMBER | (9) | This column is used for locking purposes. | |
ACT_GEO_AREA_USER | VARCHAR2 | (30) | Yes | Unique activity type used across systems. |
ACT_GEO_AREA_USER_ID | NUMBER | Yes | Unique activity code used across systems. | |
GEO_TYPE_CODE | VARCHAR2 | (30) | Yes | Geographic type code. |
GEO_TYPE_NAME | VARCHAR2 | (240) | Yes | Meaning of geographic type code. |
GEO_HIERARCHY_ID | NUMBER | Yes | Geography hierarchy identifier. | |
GEO_AREA_NAME | VARCHAR2 | (240) | Geographic area name. | |
GEO_LOCATION | VARCHAR2 | (963) | Geographic location. |
Cut, paste (and edit) the following text to query this object:
SELECT ACT_GEO_AREA_ID
, OBJECT_VERSION_NO
, ACT_GEO_AREA_USER
, ACT_GEO_AREA_USER_ID
, GEO_TYPE_CODE
, GEO_TYPE_NAME
, GEO_HIERARCHY_ID
, GEO_AREA_NAME
, GEO_LOCATION
FROM APPS.AMS_ACT_GEO_AREAS_V;
|
|
|