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: TablePQH.PQH_BUDGET_POOLS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_BUDGET_POOLS_PK
  1. ColumnPOOL_ID
Indexes
Index Type Uniqueness Tablespace Column
PQH_BUDGET_POOLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOOL_ID
PQH_BUDGET_POOLS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
PQH_BUDGET_POOLS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_UNIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_BUDGET_POOLS PQH_BUDGET_POOLS_FK1 TablePQH_BUDGET_VERSIONS PQH_BUDGET_POOLS BUDGET_VERSION_ID
TablePQH_BDGT_POOL_REALLOCTIONS PQH_BDGT_POOL_REALLOCTIONS_FK1 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:

SchemaHR
ViewPQH_BUDGET_POOLS#