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


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_GL_INTERFACE_PK
  1. ColumnGL_INTERFACE_ID
Indexes
Index Type Uniqueness Tablespace Column
PQH_GL_INTERFACE_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_INTERFACE_ID
PQH_GL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
PQH_GL_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_DETAIL_ID
PQH_GL_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_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:

SchemaHR
ViewPQH_GL_INTERFACE#