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_ELEMENT_COMMITMENTS

Object Details

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

Element Commitment for a specific period

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_ELEMENT_COMMITMENTS_PK

ELEMENT_COMMITMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_ELEMENT_COMMITMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELEMENT_COMMITMENT_ID
PQH_ELEMENT_COMMITMENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PQH_ELEMENT_COMMITMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
PQH_ELEMENT_COMMITMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_TYPE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_ELEMENT_COMMITMENTS		PQH_BUDGET_VERSIONS	PQH_ELEMENT_COMMITMENTS BUDGET_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_COMMITMENT_ID	NUMBER	(15)	Yes	Primary Key
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version identifier
ELEMENT_TYPE_ID	NUMBER	(15)	Yes	Element Type identifier
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment Identifier
COMMITMENT_CALC_FREQUENCY	VARCHAR2	(30)	Yes	Period for which commitment is generated for the element
COMMITMENT_START_DATE	DATE		Yes	Start Date of commitment
COMMITMENT_END_DATE	DATE		Yes	End date of commitment
COMMITMENT_AMOUNT	NUMBER			Commitment amout for the element for the given period
LAST_UPDATE_DATE	DATE			Standard Who Column
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

Query Text

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


SELECT ELEMENT_COMMITMENT_ID
,      BUDGET_VERSION_ID
,      ELEMENT_TYPE_ID
,      ASSIGNMENT_ID
,      COMMITMENT_CALC_FREQUENCY
,      COMMITMENT_START_DATE
,      COMMITMENT_END_DATE
,      COMMITMENT_AMOUNT
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM HR.PQH_ELEMENT_COMMITMENTS;

Dependencies

[top of page]

HR.PQH_ELEMENT_COMMITMENTS does not reference any database object

HR.PQH_ELEMENT_COMMITMENTS is referenced by following:

HR: PQH_ELEMENT_COMMITMENTS#