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

TABLE: HR.PER_EMPDIR_LOCATIONS_TL

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Primary Key: PER_EMPDIR_LOCATIONS_TL_PK
  1. ColumnORIG_SYSTEM_ID
  2. ColumnORIG_SYSTEM
  3. ColumnLANGUAGE
Indexes
Index Type Uniqueness Tablespace Column
PER_EMPDIR_LOCATIONS_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_ID
ColumnORIG_SYSTEM
ColumnLANGUAGE
PER_EMPDIR_LOCATIONS_TL_N1 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnUPPER("LOCATION_CODE")
Columns
Name Datatype Length Mandatory Comments
ORIG_SYSTEM VARCHAR2 (30) Yes
ORIG_SYSTEM_ID NUMBER (15) Yes
LOCATION_CODE VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (240)
LANGUAGE VARCHAR2 (4) Yes
SOURCE_LANG VARCHAR2 (4) Yes
OBJECT_VERSION_NUMBER NUMBER (9)
PARTITION_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_BY NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

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

Query Text

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


SELECT ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      LOCATION_CODE
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      OBJECT_VERSION_NUMBER
,      PARTITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM HR.PER_EMPDIR_LOCATIONS_TL;

Dependencies

[top of page]

HR.PER_EMPDIR_LOCATIONS_TL does not reference any database object

HR.PER_EMPDIR_LOCATIONS_TL is referenced by following:

SchemaHR
ViewPER_EMPDIR_LOCATIONS_TL#