eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_GEOGRAPHIES

Object Details

Object Name:	HZ_GEOGRAPHIES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_GEOGRAPHIES
Subobject Name:
Status:	VALID

The HZ_GEOGRPHIES table stores data representing physical geographies. This table stores both Master Reference and non-Master Reference data and each geography is stored as its own record.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_GEOGRAPHIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ID
SYS_IL0000323141C00075$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000323141C00076$$	LOB	UNIQUE	APPS_TS_TX_DATA
HZ_GEOGRAPHIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_CODE GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT1_ID GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_USE
HZ_GEOGRAPHIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT1_ID GEOGRAPHY_ELEMENT2_ID GEOGRAPHY_ELEMENT3_ID GEOGRAPHY_ELEMENT4_ID GEOGRAPHY_ELEMENT5_ID GEOGRAPHY_ELEMENT6_ID GEOGRAPHY_ELEMENT7_ID GEOGRAPHY_ELEMENT8_ID GEOGRAPHY_ELEMENT9_ID GEOGRAPHY_ELEMENT10_ID
HZ_GEOGRAPHIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_NAME GEOGRAPHY_TYPE GEOGRAPHY_USE
HZ_GEOGRAPHIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT2_ID GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT3_ID GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT4_ID GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT5_ID GEOGRAPHY_TYPE
HZ_GEOGRAPHIES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ELEMENT6_ID GEOGRAPHY_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
GEOGRAPHY_ID	NUMBER	(15)	Yes	Unique identifier for a geography.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
GEOGRAPHY_TYPE	VARCHAR2	(30)	Yes	Type of geography.
GEOGRAPHY_NAME	VARCHAR2	(360)	Yes	Primary Name of the geography.
GEOGRAPHY_USE	VARCHAR2	(30)	Yes	Usage of geography data.
GEOGRAPHY_CODE	VARCHAR2	(30)		User identifier for this geography.
START_DATE	DATE		Yes	Start date from which this geography is valid for use.
END_DATE	DATE		Yes	Date from which this geography is no longer valid.
MULTIPLE_PARENT_FLAG	VARCHAR2	(1)	Yes	Indicates whether this geography has multiple parents.
CREATED_BY_MODULE	VARCHAR2	(150)	Yes	Created by module
COUNTRY_CODE	VARCHAR2	(2)		Code of the Country to which the Geography belongs.
GEOGRAPHY_ELEMENT1	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT1_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT1_CODE	VARCHAR2	(30)		Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2_CODE	VARCHAR2	(30)		Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3_CODE	VARCHAR2	(30)		Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4_CODE	VARCHAR2	(30)		Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5_CODE	VARCHAR2	(30)		Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT6	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT6_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT7	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT7_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT8	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT8_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT9	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT9_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT10	VARCHAR2	(360)		Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT10_ID	NUMBER	(15)		Unique identifier of de-normalized parent of the geography.
TIMEZONE_CODE	VARCHAR2	(50)		Timezone to which the geography belongs
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_LOGIN_ID	NUMBER	(15)		Program identifier login of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ATTRIBUTE_CATEGORY	VARCHAR2	(60)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(60)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(60)		Descriptive flexfield segment
GEOMETRY	SDO_GEOMETRY	(1)

Query Text

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


SELECT GEOGRAPHY_ID
,      OBJECT_VERSION_NUMBER
,      GEOGRAPHY_TYPE
,      GEOGRAPHY_NAME
,      GEOGRAPHY_USE
,      GEOGRAPHY_CODE
,      START_DATE
,      END_DATE
,      MULTIPLE_PARENT_FLAG
,      CREATED_BY_MODULE
,      COUNTRY_CODE
,      GEOGRAPHY_ELEMENT1
,      GEOGRAPHY_ELEMENT1_ID
,      GEOGRAPHY_ELEMENT1_CODE
,      GEOGRAPHY_ELEMENT2
,      GEOGRAPHY_ELEMENT2_ID
,      GEOGRAPHY_ELEMENT2_CODE
,      GEOGRAPHY_ELEMENT3
,      GEOGRAPHY_ELEMENT3_ID
,      GEOGRAPHY_ELEMENT3_CODE
,      GEOGRAPHY_ELEMENT4
,      GEOGRAPHY_ELEMENT4_ID
,      GEOGRAPHY_ELEMENT4_CODE
,      GEOGRAPHY_ELEMENT5
,      GEOGRAPHY_ELEMENT5_ID
,      GEOGRAPHY_ELEMENT5_CODE
,      GEOGRAPHY_ELEMENT6
,      GEOGRAPHY_ELEMENT6_ID
,      GEOGRAPHY_ELEMENT7
,      GEOGRAPHY_ELEMENT7_ID
,      GEOGRAPHY_ELEMENT8
,      GEOGRAPHY_ELEMENT8_ID
,      GEOGRAPHY_ELEMENT9
,      GEOGRAPHY_ELEMENT9_ID
,      GEOGRAPHY_ELEMENT10
,      GEOGRAPHY_ELEMENT10_ID
,      TIMEZONE_CODE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GEOMETRY
FROM AR.HZ_GEOGRAPHIES;

Dependencies

[top of page]

AR.HZ_GEOGRAPHIES references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

AR.HZ_GEOGRAPHIES is referenced by following:

APPS: HZ_GEOGRAPHIES