DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_JOURNAL_REPORTS_ITF

Object Details
Object Name: GL_JOURNAL_REPORTS_ITF
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_JOURNAL_REPORTS_ITF
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_JOURNAL_REPORTS_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Request defining column of the extract request
BATCH_ID NUMBER (15) Yes Batch defining column
HEADER_ID NUMBER (15) Yes Journal entry header defining column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
JE_LINE_NUM NUMBER (15)
Journal entry line number
ORGANIZATION_NAME VARCHAR2 (30)
Accounting books name
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
BATCH_STATUS VARCHAR2 (80)
Batch status
BATCH_TYPE VARCHAR2 (240)
Batch type (Actual, Budget, or Encumbrance)
BATCH_JOURNAL_TYPE VARCHAR2 (80)
Journal type (Standard or Average)
BATCH_APPROVAL_STATUS VARCHAR2 (80)
Batch approval status
BATCH_BUDGET_CONTROL_STATUS VARCHAR2 (80)
Budgetary control status
EXCHANGE_TYPE VARCHAR2 (30)
Currency conversion type
DOC_SEQUENCE_NAME VARCHAR2 (30)
Sequential numbering sequence name
TAX_STATUS VARCHAR2 (80)
Journal entry tax status
HEADER_ENCUMBRANCE_TYPE VARCHAR2 (30)
Encumbrance type
HEADER_BUDGET_NAME VARCHAR2 (15)
Budget name
SUBLEDGER_DOC_SEQ_NAME VARCHAR2 (30)
Subledger sequential numbering sequence name
TAX_CODE VARCHAR2 (50)
Tax code
TAX_TYPE VARCHAR2 (80)
Tax type (Input or Output)
JE_ACCOUNT VARCHAR2 (240)
Account
JE_ACCOUNT_DESC VARCHAR2 (240)
Account description
JE_BALANCE VARCHAR2 (240)
Balancing segment value
JE_BALANCE_DESC VARCHAR2 (240)
Balancing segment description
JE_NATACCT VARCHAR2 (240)
Natural account segment value
JE_NATACCT_DESC VARCHAR2 (240)
Natural account segment description
JE_CC VARCHAR2 (240)
Cost center segment value
JE_CC_DESC VARCHAR2 (240)
Cost center segment description
JE_SECONDARY_SEG VARCHAR2 (240)
Secondary segment
JE_SECONDARY_DESC VARCHAR2 (240)
Secondary segment description
JE_CONTRA_ACCT VARCHAR2 (240)
Contra account segment
JE_CONTRA_ACCT_DESC VARCHAR2 (240)
Contra account description
Query Text

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


SELECT REQUEST_ID
,      BATCH_ID
,      HEADER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      JE_LINE_NUM
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      BATCH_STATUS
,      BATCH_TYPE
,      BATCH_JOURNAL_TYPE
,      BATCH_APPROVAL_STATUS
,      BATCH_BUDGET_CONTROL_STATUS
,      EXCHANGE_TYPE
,      DOC_SEQUENCE_NAME
,      TAX_STATUS
,      HEADER_ENCUMBRANCE_TYPE
,      HEADER_BUDGET_NAME
,      SUBLEDGER_DOC_SEQ_NAME
,      TAX_CODE
,      TAX_TYPE
,      JE_ACCOUNT
,      JE_ACCOUNT_DESC
,      JE_BALANCE
,      JE_BALANCE_DESC
,      JE_NATACCT
,      JE_NATACCT_DESC
,      JE_CC
,      JE_CC_DESC
,      JE_SECONDARY_SEG
,      JE_SECONDARY_DESC
,      JE_CONTRA_ACCT
,      JE_CONTRA_ACCT_DESC
FROM GL.GL_JOURNAL_REPORTS_ITF;

Dependencies

[top of page]

GL.GL_JOURNAL_REPORTS_ITF does not reference any database object

GL.GL_JOURNAL_REPORTS_ITF is referenced by following:

SchemaGL
ViewGL_JOURNAL_REPORTS_ITF#