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_GL_INTERFACE

Object Details

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

Interface entity containing budget and commitment information used to post to GL

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_GL_INTERFACE_PK

GL_INTERFACE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_GL_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GL_INTERFACE_ID
PQH_GL_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PQH_GL_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_DETAIL_ID
PQH_GL_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_ALLOCATION_KEYFLEX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GL_INTERFACE_ID	NUMBER	(15)	Yes	Primary Key
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version identifier
BUDGET_DETAIL_ID	NUMBER	(15)	Yes	Budget detail identifier
PERIOD_NAME	VARCHAR2	(30)	Yes	Budget period type
CODE_COMBINATION_ID	NUMBER	(15)		GL Account code combination
POSTING_TYPE_CD	VARCHAR2	(30)		Identifies Budget / Commitment posting
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
AMOUNT_DR	NUMBER			Amount Debited
AMOUNT_CR	NUMBER			Amount Credited
ACCOUNTING_DATE	DATE			Accounting Date
POSTING_DATE	DATE			Posting Date
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(15)		Cost allocation Account Code Combination
STATUS	VARCHAR2	(30)		Posting status
ADJUSTMENT_FLAG	VARCHAR2	(30)		Identifies original amount posted or an adjustment to original amount
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
PROJECT_ID	NUMBER	(15)		Project Identifier
TASK_ID	NUMBER	(15)		Task Identifier
AWARD_ID	NUMBER	(15)		Award Identifier
EXPENDITURE_TYPE	VARCHAR2	(30)		Project/ Award Expenditure Type
ORGANIZATION_ID	NUMBER	(15)		Organization Identifier

Query Text

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


SELECT GL_INTERFACE_ID
,      BUDGET_VERSION_ID
,      BUDGET_DETAIL_ID
,      PERIOD_NAME
,      CODE_COMBINATION_ID
,      POSTING_TYPE_CD
,      CURRENCY_CODE
,      AMOUNT_DR
,      AMOUNT_CR
,      ACCOUNTING_DATE
,      POSTING_DATE
,      COST_ALLOCATION_KEYFLEX_ID
,      STATUS
,      ADJUSTMENT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_TYPE
,      ORGANIZATION_ID
FROM HR.PQH_GL_INTERFACE;

Dependencies

[top of page]

HR.PQH_GL_INTERFACE does not reference any database object

HR.PQH_GL_INTERFACE is referenced by following:

APPS: PQH_GL_INTERFACE; PQH_GL_INTERFACE_WHO
PUBLIC: PQH_GL_INTERFACE