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_REF_TEMPLATES

Object Details

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

Lists copy and reference templates for a template

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: PQH_REF_TEMPLATES_PK

REF_TEMPLATE_ID

Unique Key: PQH_REF_TEMPLATES_UK

PARENT_TEMPLATE_ID
BASE_TEMPLATE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_REF_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_SEED	REF_TEMPLATE_ID
PQH_REF_TEMPLATES_UK	NORMAL	UNIQUE	APPS_TS_SEED	PARENT_TEMPLATE_ID BASE_TEMPLATE_ID
PQH_REF_TEMPLATES_FK2	NORMAL	NONUNIQUE	APPS_TS_SEED	BASE_TEMPLATE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_REF_TEMPLATES		PQH_TEMPLATES	PQH_REF_TEMPLATES BASE_TEMPLATE_ID
PQH_REF_TEMPLATES		PQH_TEMPLATES	PQH_REF_TEMPLATES PARENT_TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REF_TEMPLATE_ID	NUMBER	(15)	Yes	Primary Key
BASE_TEMPLATE_ID	NUMBER	(15)	Yes	Base Template identifier
PARENT_TEMPLATE_ID	NUMBER	(15)	Yes	Parent Template identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	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)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
REFERENCE_TYPE_CD	VARCHAR2	(30)	Yes	Referenced / copied

Query Text

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


SELECT REF_TEMPLATE_ID
,      BASE_TEMPLATE_ID
,      PARENT_TEMPLATE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REFERENCE_TYPE_CD
FROM HR.PQH_REF_TEMPLATES;

Dependencies

[top of page]

HR.PQH_REF_TEMPLATES does not reference any database object

HR.PQH_REF_TEMPLATES is referenced by following:

APPS: PQH_REF_TEMPLATES; PQH_REF_TEMPLATES_WHO
PUBLIC: PQH_REF_TEMPLATES