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_TEMPLATES

Object Details

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

TEMPLATE along with TEMPLATE_ATTRIBUTES defines which attributes can be changed / viewed. It can be considered as a transparency, which is overlayed on a transaction form. Each transaction can have one or more templates applied to a transaction. Template can also be understood as a type of transaction like "Reclassify Position".
Each user will also have a "system" defined template, which will determine the maximum rights of an user. Based on this template other template determine which attributes can be opened for change / view.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_TEMPLATES_PK

TEMPLATE_ID

Unique Key: PQH_TEMPLATES_UK

SHORT_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
PQH_TEMPLATES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
PQH_TEMPLATES_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CATEGORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_TEMPLATES	PQH_TRANSACTION_CATEGORIES	PQH_TEMPLATES TRANSACTION_CATEGORY_ID
PQH_REF_TEMPLATES	PQH_TEMPLATES	PQH_REF_TEMPLATES PARENT_TEMPLATE_ID
PQH_REF_TEMPLATES	PQH_TEMPLATES	PQH_REF_TEMPLATES BASE_TEMPLATE_ID
PQH_ROLE_TEMPLATES	PQH_TEMPLATES	PQH_ROLE_TEMPLATES TEMPLATE_ID
PQH_TEMPLATE_ATTRIBUTES	PQH_TEMPLATES	PQH_TEMPLATE_ATTRIBUTES TEMPLATE_ID
PQH_TRANSACTION_TEMPLATES	PQH_TEMPLATES	PQH_TRANSACTION_TEMPLATES TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER	(15)	Yes	Primary Key
TEMPLATE_NAME	VARCHAR2	(100)	Yes	Template Description
SHORT_NAME	VARCHAR2	(30)	Yes	Developer Key
ATTRIBUTE_ONLY_FLAG	VARCHAR2	(10)		identifies if this template can reference other templates
ENABLE_FLAG	VARCHAR2	(10)	Yes	Enabled / disabled
CREATE_FLAG	VARCHAR2	(10)		identifies if a template is create or update (for task template)
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	Transaction category identifier
UNDER_REVIEW_FLAG	VARCHAR2	(10)		Indicates if a transaction is to placed under review (for update template only)
FREEZE_STATUS_CD	VARCHAR2	(30)		Frozed or not
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)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version Number
TEMPLATE_TYPE_CD	VARCHAR2	(30)	Yes	Role template / task template
LEGISLATION_CODE	VARCHAR2	(30)		Legislation Code

Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      SHORT_NAME
,      ATTRIBUTE_ONLY_FLAG
,      ENABLE_FLAG
,      CREATE_FLAG
,      TRANSACTION_CATEGORY_ID
,      UNDER_REVIEW_FLAG
,      FREEZE_STATUS_CD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      TEMPLATE_TYPE_CD
,      LEGISLATION_CODE
FROM HR.PQH_TEMPLATES;

Dependencies

[top of page]

HR.PQH_TEMPLATES does not reference any database object

HR.PQH_TEMPLATES is referenced by following:

APPS: PQH_TEMPLATES; PQH_TEMPLATES_WHO
PUBLIC: PQH_TEMPLATES