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_RI_CONFIG_LOCATIONS

Object Details

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

This stores locations information specified by the user in the Organization Structures Configuration wizard (configurations) it is required to have this table since we need to show all the legislation specific validation from flexfield when user is entering data

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_RI_CONFIG_LOCATIONS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIGURATION_CODE	VARCHAR2	(60)	Yes	Foreign Key (PER_RI_CONFIGURATIONS.CONFIGURATION_CODE)
CONFIGURATION_CONTEXT	VARCHAR2	(120)	Yes	Lookup PER_RI_CONFIG_LOCATION_CONTEXT
LOCATION_ID	NUMBER	(15)	Yes	Sequence, Stores the Location ID
LOCATION_CODE	VARCHAR2	(60)		Location Code
DESCRIPTION	VARCHAR2	(240)		Description of the Location
STYLE	VARCHAR2	(7)		Location Style
ADDRESS_LINE_1	VARCHAR2	(240)		Adddress Line 1
ADDRESS_LINE_2	VARCHAR2	(240)		Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)		Address Line 3
TOWN_OR_CITY	VARCHAR2	(30)		Town Or City
COUNTRY	VARCHAR2	(60)		Country Name
POSTAL_CODE	VARCHAR2	(30)		Postal Code
REGION_1	VARCHAR2	(120)		Region 1
REGION_2	VARCHAR2	(120)		Region 2
REGION_3	VARCHAR2	(120)		Region 3
TELEPHONE_NUMBER_1	VARCHAR2	(60)		Telephone Number 1
TELEPHONE_NUMBER_2	VARCHAR2	(60)		Telephone Number 2
TELEPHONE_NUMBER_3	VARCHAR2	(60)		Telephone Number 3
LOC_INFORMATION13	VARCHAR2	(150)		Location Information 13
LOC_INFORMATION14	VARCHAR2	(150)		Location Information 14
LOC_INFORMATION15	VARCHAR2	(150)		Location Information 15
LOC_INFORMATION16	VARCHAR2	(150)		Location Information 16
LOC_INFORMATION17	VARCHAR2	(150)		Location Information 17
LOC_INFORMATION18	VARCHAR2	(150)		Location Information 18
LOC_INFORMATION19	VARCHAR2	(150)		Location Information 19
LOC_INFORMATION20	VARCHAR2	(150)		Location Information 20
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
CREATED_BY	NUMBER	(15)		Standard WHO Column
CREATION_DATE	DATE			Standard WHO Column

Query Text

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


SELECT CONFIGURATION_CODE
,      CONFIGURATION_CONTEXT
,      LOCATION_ID
,      LOCATION_CODE
,      DESCRIPTION
,      STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_RI_CONFIG_LOCATIONS;

Dependencies

[top of page]

HR.PER_RI_CONFIG_LOCATIONS does not reference any database object

HR.PER_RI_CONFIG_LOCATIONS is referenced by following:

APPS: PER_RI_CONFIG_LOCATIONS; PER_RI_CONFIG_LOCATIONS_WHO
PUBLIC: PER_RI_CONFIG_LOCATIONS