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.PQP_CONFIGURATION_VALUES

Object Details

Object Name:	PQP_CONFIGURATION_VALUES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_CONFIGURATION_VALUES
Subobject Name:
Status:	VALID

This table is used to store all configuration information. The table can have seeded as well as user perference data. The data is identified by the key word that is stored in PC_INFORMATION_CATEGORY.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_CONFIGURATION_VALUES_UI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONFIGURATION_VALUE_ID LEGISLATION_CODE BUSINESS_GROUP_ID PCV_INFORMATION_CATEGORY ZD_EDITION_NAME
PQP_CONFIGURATION_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PCV_INFORMATION_CATEGORY LEGISLATION_CODE BUSINESS_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIGURATION_VALUE_ID	NUMBER	(10)	Yes	Primary key generated by a sequence.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group id.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code for seeded data.
PCV_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Category for the Descriptive flexfield.
PCV_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column
PCV_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column
PCV_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column
PCV_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column
PCV_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
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
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
CONFIGURATION_NAME	VARCHAR2	(80)		A name to identify the unique row for the configuration values. This is used to identify the row when the configuration category can have more than one row.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT CONFIGURATION_VALUE_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      PCV_ATTRIBUTE_CATEGORY
,      PCV_ATTRIBUTE1
,      PCV_ATTRIBUTE2
,      PCV_ATTRIBUTE3
,      PCV_ATTRIBUTE4
,      PCV_ATTRIBUTE5
,      PCV_ATTRIBUTE6
,      PCV_ATTRIBUTE7
,      PCV_ATTRIBUTE8
,      PCV_ATTRIBUTE9
,      PCV_ATTRIBUTE10
,      PCV_ATTRIBUTE11
,      PCV_ATTRIBUTE12
,      PCV_ATTRIBUTE13
,      PCV_ATTRIBUTE14
,      PCV_ATTRIBUTE15
,      PCV_ATTRIBUTE16
,      PCV_ATTRIBUTE17
,      PCV_ATTRIBUTE18
,      PCV_ATTRIBUTE19
,      PCV_ATTRIBUTE20
,      PCV_INFORMATION_CATEGORY
,      PCV_INFORMATION1
,      PCV_INFORMATION2
,      PCV_INFORMATION3
,      PCV_INFORMATION4
,      PCV_INFORMATION5
,      PCV_INFORMATION6
,      PCV_INFORMATION7
,      PCV_INFORMATION8
,      PCV_INFORMATION9
,      PCV_INFORMATION10
,      PCV_INFORMATION11
,      PCV_INFORMATION12
,      PCV_INFORMATION13
,      PCV_INFORMATION14
,      PCV_INFORMATION15
,      PCV_INFORMATION16
,      PCV_INFORMATION17
,      PCV_INFORMATION18
,      PCV_INFORMATION19
,      PCV_INFORMATION20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CONFIGURATION_NAME
,      ZD_EDITION_NAME
FROM HR.PQP_CONFIGURATION_VALUES;

Dependencies

[top of page]

HR.PQP_CONFIGURATION_VALUES does not reference any database object

HR.PQP_CONFIGURATION_VALUES is referenced by following:

HR: PQP_CONFIGURATION_VALUES#