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

TABLE: POA.EDW_GEOGRAPHY_M

Object Details
Object Name: EDW_GEOGRAPHY_M
Object Type: TABLE
Owner: POA
FND Design Data: TableBIS.EDW_GEOGRAPHY_M
TablePOA.EDW_GEOGRAPHY_M
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_GEOGRAPHY_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnGLOC_LOCATION_PK
ColumnGLOC_LOCATION_PK_KEY
EDW_GEOGRAPHY_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnGLOC_LOCATION_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_ALL_PK VARCHAR2 (40)
Unique identifier for the top level of the Geography dimension
ALL_ALL_PK_KEY NUMBER

System generated unique identifier for the top level of the Geography dimension
ALL_NAME VARCHAR2 (80)
The displayed name for All level
ARE1_AREA1_DP VARCHAR2 (240)
Unique name for World Area 1
ARE1_AREA1_PK VARCHAR2 (240)
Unique identifier for World Area1
ARE1_AREA1_PK_KEY NUMBER

System generated unique identifier for World Area1
ARE1_INSTANCE VARCHAR2 (40)
Instance identifier
ARE1_NAME VARCHAR2 (240)
World Area 1 name
ARE1_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
ARE1_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
ARE1_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
ARE1_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
ARE1_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
ARE2_AREA2_DP VARCHAR2 (240)
Unique name for World Area 2
ARE2_AREA2_PK VARCHAR2 (240)
Unique identifier for World Area2
ARE2_AREA2_PK_KEY NUMBER

System generated unique identifier for World Area2
ARE2_INSTANCE VARCHAR2 (40)
Instance identifier
ARE2_NAME VARCHAR2 (240)
World Area 2 name
ARE2_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
ARE2_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
ARE2_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
ARE2_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
ARE2_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CITY_CITY_DP VARCHAR2 (240)
Unique name for City
CITY_CITY_PK VARCHAR2 (480)
Unique identifier for City
CITY_CITY_PK_KEY NUMBER

System generated unique identifier for City
CITY_INSTANCE VARCHAR2 (40)
Instance identifier
CITY_NAME VARCHAR2 (240)
City name
CITY_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CITY_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CITY_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CITY_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CITY_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
COUN_COUNTRY_DP VARCHAR2 (240)
Unique name for Country
COUN_COUNTRY_PK VARCHAR2 (240)
Unique identifier for Country
COUN_COUNTRY_PK_KEY NUMBER

System generated unique identifier for Country
COUN_INSTANCE VARCHAR2 (40)
Instance identifier
COUN_NAME VARCHAR2 (240)
Country name
COUN_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
COUN_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
COUN_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
COUN_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
COUN_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
GLOC_ADDRESS_LINE_1 VARCHAR2 (240)
Address line 1
GLOC_ADDRESS_LINE_2 VARCHAR2 (240)
Address line 2
GLOC_ADDRESS_LINE_3 VARCHAR2 (240)
Address line 3
GLOC_ADDRESS_LINE_4 VARCHAR2 (240)
Address line 4
GLOC_INSTANCE VARCHAR2 (40)
Instance identifier
GLOC_LOCATION_DP VARCHAR2 (480)
Unique name for Location
GLOC_LOCATION_PK VARCHAR2 (240)
Unique identifier for Location
GLOC_LOCATION_PK_KEY NUMBER
Yes System generated unique identifier for Location
GLOC_NAME VARCHAR2 (480)
Location name
GLOC_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
GLOC_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
GLOC_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
GLOC_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
GLOC_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
PCCY_INSTANCE VARCHAR2 (40)
Instance identifier
PCCY_NAME VARCHAR2 (480)
Postal Code City name
PCCY_POSTCODE_CITY_DP VARCHAR2 (480)
Unique name for Postal Code City
PCCY_POSTCODE_CITY_PK VARCHAR2 (480)
Unique identifier for Postal Code City
PCCY_POSTCODE_CITY_PK_KEY NUMBER

System generated unique identifier for Postal Code City
PCCY_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
PCCY_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
PCCY_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
PCCY_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
PCCY_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
POST_INSTANCE VARCHAR2 (40)
Instance identifier
POST_NAME VARCHAR2 (240)
Postal Code name
POST_POSTCODE_DP VARCHAR2 (240)
Unique name for Postal Code
POST_POSTCODE_PK VARCHAR2 (480)
Unique identifier for Postal Code
POST_POSTCODE_PK_KEY NUMBER

System generated unique identifier for Postal Code
POST_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
POST_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
POST_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
POST_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
POST_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
REGN_INSTANCE VARCHAR2 (40)
Instance identifier
REGN_NAME VARCHAR2 (240)
Region name
REGN_REGION_DP VARCHAR2 (240)
Unique name for Region
REGN_REGION_PK VARCHAR2 (240)
Unique identifier for Region
REGN_REGION_PK_KEY NUMBER

System generated unique identifier for Region
REGN_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
REGN_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
REGN_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
REGN_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
REGN_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
SREG_INSTANCE VARCHAR2 (40)
Instance identifier
SREG_NAME VARCHAR2 (480)
State or Province Region name
SREG_STATE_REGION_DP VARCHAR2 (480)
Unique name for State or Province Region
SREG_STATE_REGION_PK VARCHAR2 (480)
Unique identifier for State or Province Region
SREG_STATE_REGION_PK_KEY NUMBER

System generated unique identifier for State or Province Region
SREG_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
SREG_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
SREG_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
SREG_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
SREG_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
STAT_INSTANCE VARCHAR2 (40)
Instance identifier
STAT_NAME VARCHAR2 (480)
State or Province name
STAT_STATE_DP VARCHAR2 (480)
Unique name for State or Province
STAT_STATE_PK VARCHAR2 (480)
Unique identifier for State or Province
STAT_STATE_PK_KEY NUMBER

System generated unique identifier for State or Province
STAT_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
STAT_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
STAT_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
STAT_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
STAT_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT ALL_ALL_PK
,      ALL_ALL_PK_KEY
,      ALL_NAME
,      ARE1_AREA1_DP
,      ARE1_AREA1_PK
,      ARE1_AREA1_PK_KEY
,      ARE1_INSTANCE
,      ARE1_NAME
,      ARE1_USER_ATTRIBUTE1
,      ARE1_USER_ATTRIBUTE2
,      ARE1_USER_ATTRIBUTE3
,      ARE1_USER_ATTRIBUTE4
,      ARE1_USER_ATTRIBUTE5
,      ARE2_AREA2_DP
,      ARE2_AREA2_PK
,      ARE2_AREA2_PK_KEY
,      ARE2_INSTANCE
,      ARE2_NAME
,      ARE2_USER_ATTRIBUTE1
,      ARE2_USER_ATTRIBUTE2
,      ARE2_USER_ATTRIBUTE3
,      ARE2_USER_ATTRIBUTE4
,      ARE2_USER_ATTRIBUTE5
,      CITY_CITY_DP
,      CITY_CITY_PK
,      CITY_CITY_PK_KEY
,      CITY_INSTANCE
,      CITY_NAME
,      CITY_USER_ATTRIBUTE1
,      CITY_USER_ATTRIBUTE2
,      CITY_USER_ATTRIBUTE3
,      CITY_USER_ATTRIBUTE4
,      CITY_USER_ATTRIBUTE5
,      COUN_COUNTRY_DP
,      COUN_COUNTRY_PK
,      COUN_COUNTRY_PK_KEY
,      COUN_INSTANCE
,      COUN_NAME
,      COUN_USER_ATTRIBUTE1
,      COUN_USER_ATTRIBUTE2
,      COUN_USER_ATTRIBUTE3
,      COUN_USER_ATTRIBUTE4
,      COUN_USER_ATTRIBUTE5
,      GLOC_ADDRESS_LINE_1
,      GLOC_ADDRESS_LINE_2
,      GLOC_ADDRESS_LINE_3
,      GLOC_ADDRESS_LINE_4
,      GLOC_INSTANCE
,      GLOC_LOCATION_DP
,      GLOC_LOCATION_PK
,      GLOC_LOCATION_PK_KEY
,      GLOC_NAME
,      GLOC_USER_ATTRIBUTE1
,      GLOC_USER_ATTRIBUTE2
,      GLOC_USER_ATTRIBUTE3
,      GLOC_USER_ATTRIBUTE4
,      GLOC_USER_ATTRIBUTE5
,      PCCY_INSTANCE
,      PCCY_NAME
,      PCCY_POSTCODE_CITY_DP
,      PCCY_POSTCODE_CITY_PK
,      PCCY_POSTCODE_CITY_PK_KEY
,      PCCY_USER_ATTRIBUTE1
,      PCCY_USER_ATTRIBUTE2
,      PCCY_USER_ATTRIBUTE3
,      PCCY_USER_ATTRIBUTE4
,      PCCY_USER_ATTRIBUTE5
,      POST_INSTANCE
,      POST_NAME
,      POST_POSTCODE_DP
,      POST_POSTCODE_PK
,      POST_POSTCODE_PK_KEY
,      POST_USER_ATTRIBUTE1
,      POST_USER_ATTRIBUTE2
,      POST_USER_ATTRIBUTE3
,      POST_USER_ATTRIBUTE4
,      POST_USER_ATTRIBUTE5
,      REGN_INSTANCE
,      REGN_NAME
,      REGN_REGION_DP
,      REGN_REGION_PK
,      REGN_REGION_PK_KEY
,      REGN_USER_ATTRIBUTE1
,      REGN_USER_ATTRIBUTE2
,      REGN_USER_ATTRIBUTE3
,      REGN_USER_ATTRIBUTE4
,      REGN_USER_ATTRIBUTE5
,      SREG_INSTANCE
,      SREG_NAME
,      SREG_STATE_REGION_DP
,      SREG_STATE_REGION_PK
,      SREG_STATE_REGION_PK_KEY
,      SREG_USER_ATTRIBUTE1
,      SREG_USER_ATTRIBUTE2
,      SREG_USER_ATTRIBUTE3
,      SREG_USER_ATTRIBUTE4
,      SREG_USER_ATTRIBUTE5
,      STAT_INSTANCE
,      STAT_NAME
,      STAT_STATE_DP
,      STAT_STATE_PK
,      STAT_STATE_PK_KEY
,      STAT_USER_ATTRIBUTE1
,      STAT_USER_ATTRIBUTE2
,      STAT_USER_ATTRIBUTE3
,      STAT_USER_ATTRIBUTE4
,      STAT_USER_ATTRIBUTE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM POA.EDW_GEOGRAPHY_M;

Dependencies

[top of page]

POA.EDW_GEOGRAPHY_M does not reference any database object

POA.EDW_GEOGRAPHY_M is referenced by following:

SchemaAPPS
SynonymEDW_GEOGRAPHY_M