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: TablePER.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_JP_POSTAL_CODES_PK
  1. ColumnPOSTAL_CODE
  2. ColumnDISTRICT_CODE
Indexes
Index Type Uniqueness Tablespace Column
PER_JP_POSTAL_CODES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTAL_CODE
ColumnDISTRICT_CODE
PER_JP_POSTAL_CODES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRICT_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_JP_POSTAL_CODES PER_JP_POSTAL_CODES_FK TablePER_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:

SchemaHR
ViewPER_JP_POSTAL_CODES#