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

TABLE: HR.PER_EMPDIR_PHONES

Object Details
Object Name: PER_EMPDIR_PHONES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_EMPDIR_PHONES
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Primary Key: PER_EMPDIR_PHONES_PK
  1. ColumnORIG_SYSTEM_ID
  2. ColumnORIG_SYSTEM
Indexes
Index Type Uniqueness Tablespace Column
PER_EMPDIR_PHONES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_ID
ColumnORIG_SYSTEM
PER_EMPDIR_PHONES_N1 NORMAL NONUNIQUE Tablespace ColumnPARENT_ID
ColumnPARENT_TABLE
PER_EMPDIR_PHONES_N2 NORMAL NONUNIQUE Tablespace ColumnPHONE_KEY
Columns
Name Datatype Length Mandatory Comments
ORIG_SYSTEM VARCHAR2 (30) Yes
ORIG_SYSTEM_ID NUMBER (15) Yes
DATE_FROM DATE
Yes
DATE_TO DATE

PHONE_TYPE VARCHAR2 (30) Yes
PHONE_NUMBER VARCHAR2 (60) Yes
PHONE_KEY VARCHAR2 (60) Yes
PARENT_ID NUMBER (15)
PARENT_TABLE VARCHAR2 (80)
OBJECT_VERSION_NUMBER VARCHAR2 (9)
PARTITION_ID NUMBER

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

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


SELECT ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      DATE_FROM
,      DATE_TO
,      PHONE_TYPE
,      PHONE_NUMBER
,      PHONE_KEY
,      PARENT_ID
,      PARENT_TABLE
,      OBJECT_VERSION_NUMBER
,      PARTITION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_EMPDIR_PHONES;

Dependencies

[top of page]

HR.PER_EMPDIR_PHONES does not reference any database object

HR.PER_EMPDIR_PHONES is referenced by following:

SchemaHR
ViewPER_EMPDIR_PHONES#