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_BUDGET_POOLS

Object Details

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

Reallocation pool for a budget version and for a specific budget mesurement unit

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_BUDGET_POOLS_PK

POOL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_BUDGET_POOLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POOL_ID
PQH_BUDGET_POOLS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PQH_BUDGET_POOLS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_UNIT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_BUDGET_POOLS		PQH_BUDGET_VERSIONS	PQH_BUDGET_POOLS BUDGET_VERSION_ID
PQH_BDGT_POOL_REALLOCTIONS		PQH_BUDGET_POOLS	PQH_BDGT_POOL_REALLOCTIONS POOL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POOL_ID	NUMBER	(15)	Yes	Primary Key
NAME	VARCHAR2	(30)	Yes	Folder/ transaction name
BUDGET_VERSION_ID	NUMBER	(15)		Identifies the budget version this pool is created for
BUDGET_UNIT_ID	NUMBER	(15)		measuement unit of the budget version for which the pool is created
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
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
ENTITY_TYPE	VARCHAR2	(30)		Primary Budget entity (Position/ Job/ Grade/ Organization)
PARENT_POOL_ID	NUMBER	(15)		Parent
BUSINESS_GROUP_ID	NUMBER	(15)		Business Grou Identifier
APPROVAL_STATUS	VARCHAR2	(30)		Approval Status
WF_TRANSACTION_CATEGORY_ID	NUMBER	(15)		Workflow Transaction Category Id

Query Text

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


SELECT POOL_ID
,      NAME
,      BUDGET_VERSION_ID
,      BUDGET_UNIT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      ENTITY_TYPE
,      PARENT_POOL_ID
,      BUSINESS_GROUP_ID
,      APPROVAL_STATUS
,      WF_TRANSACTION_CATEGORY_ID
FROM HR.PQH_BUDGET_POOLS;

Dependencies

[top of page]

HR.PQH_BUDGET_POOLS does not reference any database object

HR.PQH_BUDGET_POOLS is referenced by following:

HR: PQH_BUDGET_POOLS#