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_WORKSHEET_DETAILS

Object Details

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

Work table of Hr entities for Budget information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_WORKSHEET_DETAILS_PK

WORKSHEET_DETAIL_ID

Unique Key: PQH_WORKSHEET_DETAILS_UK

ACTION_CD
WORKSHEET_ID
ORGANIZATION_ID
JOB_ID
POSITION_ID
GRADE_ID
POSITION_TRANSACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_WORKSHEET_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORKSHEET_DETAIL_ID
PQH_WORKSHEET_DETAILS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_CD WORKSHEET_ID ORGANIZATION_ID JOB_ID POSITION_ID GRADE_ID POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
PQH_WORKSHEET_DETAILS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PQH_WORKSHEET_DETAILS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_DETAIL_ID
PQH_WORKSHEET_DETAILS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
PQH_WORKSHEET_DETAILS_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_ID
PQH_WORKSHEET_DETAILS_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKSHEET_ID
PQH_WORKSHEET_DETAILS_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_WORKSHEET_DETAIL_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_WORKSHEET_DETAILS	HR_ALL_ORGANIZATION_UNITS	PQH_WORKSHEET_DETAILS ORGANIZATION_ID
PQH_WORKSHEET_DETAILS	PER_GRADES	PQH_WORKSHEET_DETAILS GRADE_ID
PQH_WORKSHEET_DETAILS	PER_JOBS	PQH_WORKSHEET_DETAILS JOB_ID
PQH_WORKSHEET_DETAILS	PQH_BUDGET_DETAILS	PQH_WORKSHEET_DETAILS BUDGET_DETAIL_ID
PQH_WORKSHEET_DETAILS	PQH_POSITION_TRANSACTIONS	PQH_WORKSHEET_DETAILS POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEETS	PQH_WORKSHEET_DETAILS WORKSHEET_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS PARENT_WORKSHEET_DETAIL_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS PARENT_WORKSHEET_DETAIL_ID
PQH_WORKSHEET_PERIODS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_PERIODS WORKSHEET_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORKSHEET_DETAIL_ID	NUMBER	(15)	Yes	Primary Key
WORKSHEET_ID	NUMBER	(15)	Yes	Worksheet identifier
ORGANIZATION_ID	NUMBER	(15)		Organization identifier ( delegate / budgeted) (Hr entity)
JOB_ID	NUMBER	(15)		Budgeted Job identifier (Hr entity)
POSITION_ID	NUMBER	(15)		Budgeted Job identifier (Hr entity)
GRADE_ID	NUMBER	(15)		Budgeted Job identifier (Hr entity)
POSITION_TRANSACTION_ID	NUMBER	(15)		budgeted position transaction identifier
BUDGET_DETAIL_ID	NUMBER	(15)		Budget detail identifier (in correction / edit modes of worksheet)
PARENT_WORKSHEET_DETAIL_ID	NUMBER	(15)		Parent Worksheet detail identifier ( null in case of top node)
USER_ID	NUMBER	(15)		manager of the organization, part or the worksheet delegated to
ACTION_CD	VARCHAR2	(30)		Action (Budgeted / delegated/ null)
DEFER_FLAG	VARCHAR2	(10)		Notification to be sent right away or defered
BUDGET_UNIT1_PERCENT	NUMBER	(15)		Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT2_PERCENT	NUMBER	(15)		Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT3_PERCENT	NUMBER	(15)		Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT1_VALUE	NUMBER			Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT2_VALUE	NUMBER			Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT3_VALUE	NUMBER			Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT1_VALUE_TYPE_CD	VARCHAR2	(30)		Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT2_VALUE_TYPE_CD	VARCHAR2	(30)		Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT3_VALUE_TYPE_CD	VARCHAR2	(30)		Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT1_AVAILABLE	NUMBER			unused value of worksheet detail
BUDGET_UNIT2_AVAILABLE	NUMBER			unused value of worksheet detail
BUDGET_UNIT3_AVAILABLE	NUMBER			unused value of worksheet detail
OLD_UNIT1_VALUE	NUMBER			Old values of worksheet details when changes are not propaged
OLD_UNIT2_VALUE	NUMBER			Old values of worksheet details when changes are not propaged
OLD_UNIT3_VALUE	NUMBER			Old values of worksheet details when changes are not propaged
PROPAGATION_METHOD	VARCHAR2	(2)		Propagation Method used to propagate changes.
STATUS	VARCHAR2	(10)		Status
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

Query Text

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


SELECT WORKSHEET_DETAIL_ID
,      WORKSHEET_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      POSITION_TRANSACTION_ID
,      BUDGET_DETAIL_ID
,      PARENT_WORKSHEET_DETAIL_ID
,      USER_ID
,      ACTION_CD
,      DEFER_FLAG
,      BUDGET_UNIT1_PERCENT
,      BUDGET_UNIT2_PERCENT
,      BUDGET_UNIT3_PERCENT
,      BUDGET_UNIT1_VALUE
,      BUDGET_UNIT2_VALUE
,      BUDGET_UNIT3_VALUE
,      BUDGET_UNIT1_VALUE_TYPE_CD
,      BUDGET_UNIT2_VALUE_TYPE_CD
,      BUDGET_UNIT3_VALUE_TYPE_CD
,      BUDGET_UNIT1_AVAILABLE
,      BUDGET_UNIT2_AVAILABLE
,      BUDGET_UNIT3_AVAILABLE
,      OLD_UNIT1_VALUE
,      OLD_UNIT2_VALUE
,      OLD_UNIT3_VALUE
,      PROPAGATION_METHOD
,      STATUS
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PQH_WORKSHEET_DETAILS;

Dependencies

[top of page]

HR.PQH_WORKSHEET_DETAILS does not reference any database object

HR.PQH_WORKSHEET_DETAILS is referenced by following:

HR: PQH_WORKSHEET_DETAILS#