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

Object Details

Object Name:	PQH_SPECIAL_ATTRIBUTES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_SPECIAL_ATTRIBUTES
Subobject Name:
Status:	VALID

Identifies attributes with special functions

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: PQH_SPECIAL_ATTRIBUTES_PK

SPECIAL_ATTRIBUTE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_SPECIAL_ATTRIBUTES_PK	NORMAL	UNIQUE	APPS_TS_SEED	SPECIAL_ATTRIBUTE_ID
PQH_SPECIAL_ATTRIBUTES_FK1	NORMAL	NONUNIQUE	APPS_TS_SEED	TXN_CATEGORY_ATTRIBUTE_ID
PQH_SPECIAL_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	CONTEXT ATTRIBUTE_TYPE_CD FLEX_CODE
PQH_SPECIAL_ATTRIBUTES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	DDF_VALUE_COLUMN_NAME
PQH_SPECIAL_ATTRIBUTES_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	CONTEXT KEY_ATTRIBUTE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_SPECIAL_ATTRIBUTES		PQH_COPY_ENTITY_CONTEXTS	PQH_SPECIAL_ATTRIBUTES CONTEXT
PQH_SPECIAL_ATTRIBUTES		PQH_TXN_CATEGORY_ATTRIBUTES	PQH_SPECIAL_ATTRIBUTES TXN_CATEGORY_ATTRIBUTE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SPECIAL_ATTRIBUTE_ID	NUMBER	(10)	Yes	Primary Key
TXN_CATEGORY_ATTRIBUTE_ID	NUMBER	(15)	Yes	Attribute and transaction identifier
CONTEXT	VARCHAR2	(27)	Yes	Context identifier
ATTRIBUTE_TYPE_CD	VARCHAR2	(30)		Attribute Type (Display, criteria, changeable, key_flex, select, parameter)
DDF_COLUMN_NAME	VARCHAR2	(30)		DDF Column name which associated with the attribute
DDF_VALUE_COLUMN_NAME	VARCHAR2	(30)		DDF column which would display value (in case of column with value set association)
FLEX_CODE	VARCHAR2	(30)		Key Flexfield Code for Key flex attributes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version Number
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
KEY_ATTRIBUTE_TYPE	VARCHAR2	(30)		Developer Key Attribute Type for Data Upload
ENABLE_FLAG	VARCHAR2	(10)	Yes	Enable Flag - Status of the record

Query Text

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


SELECT SPECIAL_ATTRIBUTE_ID
,      TXN_CATEGORY_ATTRIBUTE_ID
,      CONTEXT
,      ATTRIBUTE_TYPE_CD
,      DDF_COLUMN_NAME
,      DDF_VALUE_COLUMN_NAME
,      FLEX_CODE
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      KEY_ATTRIBUTE_TYPE
,      ENABLE_FLAG
FROM HR.PQH_SPECIAL_ATTRIBUTES;

Dependencies

[top of page]

HR.PQH_SPECIAL_ATTRIBUTES does not reference any database object

HR.PQH_SPECIAL_ATTRIBUTES is referenced by following:

APPS: PQH_SPECIAL_ATTRIBUTES; PQH_SPECIAL_ATTRIBUTES_WHO
PUBLIC: PQH_SPECIAL_ATTRIBUTES