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_BDGT_CMMTMNT_ELMNTS

Object Details

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

Elements for computing commitments for a budget

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_BDGT_CMMTMNT_ELMNTS_PK

BDGT_CMMTMNT_ELMNT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_BDGT_CMMTMNT_ELMNTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BDGT_CMMTMNT_ELMNT_ID
PQH_BDGT_CMMTMNT_ELMNTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DFLT_ELMNT_FREQUENCY
PQH_BDGT_CMMTMNT_ELMNTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_BDGT_CMMTMNT_ELMNTS		PER_TIME_PERIOD_TYPES	PQH_BDGT_CMMTMNT_ELMNTS DFLT_ELMNT_FREQUENCY

Columns

Name	Datatype	Length	Mandatory	Comments
BDGT_CMMTMNT_ELMNT_ID	NUMBER	(15)	Yes	Primary Key
BUDGET_ID	NUMBER	(15)	Yes	Budget Identifier
ELEMENT_TYPE_ID	NUMBER	(9)		Element type Identifier
SALARY_BASIS_FLAG	VARCHAR2	(10)		compuating commitments (salary basis /Element input value, frequency/formula)
ELEMENT_INPUT_VALUE_ID	NUMBER	(9)		computating commitments (salary basis /Element input value, frequency/formula)
FREQUENCY_INPUT_VALUE_ID	NUMBER	(9)		computating commitments (salary basis /Element input value, frequency/formula)
FORMULA_ID	NUMBER	(9)		computating commitments (salary basis /Element input value, frequency/formula)
DFLT_ELMNT_FREQUENCY	VARCHAR2	(30)		Fall back frequency for input value
OVERHEAD_PERCENTAGE	NUMBER	(5)		Tolerance to be added to commitment amout
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
ACTUAL_COMMITMENT_TYPE	VARCHAR2	(30)	Yes	Identifies Actual/ Commitment/ Both
BALANCE_TYPE_ID	NUMBER	(15)		Balance Type Identifier

Query Text

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


SELECT BDGT_CMMTMNT_ELMNT_ID
,      BUDGET_ID
,      ELEMENT_TYPE_ID
,      SALARY_BASIS_FLAG
,      ELEMENT_INPUT_VALUE_ID
,      FREQUENCY_INPUT_VALUE_ID
,      FORMULA_ID
,      DFLT_ELMNT_FREQUENCY
,      OVERHEAD_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACTUAL_COMMITMENT_TYPE
,      BALANCE_TYPE_ID
FROM HR.PQH_BDGT_CMMTMNT_ELMNTS;

Dependencies

[top of page]

HR.PQH_BDGT_CMMTMNT_ELMNTS does not reference any database object

HR.PQH_BDGT_CMMTMNT_ELMNTS is referenced by following:

APPS: PQH_BDGT_CMMTMNT_ELMNTS; PQH_BDGT_CMMTMNT_ELMNTS_WHO
PUBLIC: PQH_BDGT_CMMTMNT_ELMNTS