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: HR.PER_JP_POSTAL_CODES

Object Details

Object Name:	PER_JP_POSTAL_CODES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_JP_POSTAL_CODES
Subobject Name:
Status:	VALID

PER_JP_POSTAL_CODES holds information provided by the Ministry of
Posts and Telecommunications.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_JP_POSTAL_CODES_PK

POSTAL_CODE
DISTRICT_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_JP_POSTAL_CODES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POSTAL_CODE DISTRICT_CODE
PER_JP_POSTAL_CODES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISTRICT_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_JP_POSTAL_CODES		PER_JP_ADDRESS_LOOKUPS	PER_JP_POSTAL_CODES DISTRICT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
POSTAL_CODE	VARCHAR2	(10)	Yes	Primary Key (Characters)
DISTRICT_CODE	VARCHAR2	(6)	Yes	Japanese district code
REGION	VARCHAR2	(150)		Japanese Region Name in Kanji Characters
REGION_KANA	VARCHAR2	(250)		Japanese Region Name in Kana Characters
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
CREATED_BY	NUMBER	(15)		Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.

Query Text

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


SELECT POSTAL_CODE
,      DISTRICT_CODE
,      REGION
,      REGION_KANA
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_JP_POSTAL_CODES;

Dependencies

[top of page]

HR.PER_JP_POSTAL_CODES does not reference any database object

HR.PER_JP_POSTAL_CODES is referenced by following:

APPS: PER_JP_POSTAL_CODES; PER_JP_POSTAL_CODES_WHO
PUBLIC: PER_JP_POSTAL_CODES