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

TABLE: AR.AR_GL_RECON_GT

Object Details
Object Name: AR_GL_RECON_GT
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_GL_RECON_GT
Subobject Name:
Status: VALID

Temporary Table Details

AR.AR_GL_RECON_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
CODE_COMBINATION_ID NUMBER

Account Code combination Id
OPENING_BALANCE_DR NUMBER

Opening GL Balance Debit
OPENING_BALANCE_CR NUMBER

Opening GL Balance Credit
PERIOD_ACTIVITY_DR NUMBER

Period GL Activity Debit
PERIOD_ACTIVITY_CR NUMBER

Period GL Activity Credit
SUBLEDGER_NOT_AR_DR NUMBER

Subledgers (Debit) which are not Manual, not from Receivables or are not Unposted
SUBLEDGER_NOT_AR_CR NUMBER

Subledgers (Credit) which are not Manual, not from Receivables or are not Unposted
SUBLEDGER_MANUAL_DR NUMBER

Manual Subledger Debit
SUBLEDGER_MANUAL_CR NUMBER

Manual Subledger Credit
SUBLEDGER_REC_DR NUMBER

Subledger Debit (Source = Receivables)
SUBLEDGER_REC_CR NUMBER

Subledger Credit (Source = Receivables)
GL_UNPOSTED_DR NUMBER

Unposted Subledgers in GL (Debit)
GL_UNPOSTED_CR NUMBER

Unposted Subledgers in GL (Credit)
GL_INTERFACE_DR NUMBER

Subledgers in intergace table (Debit)
GL_INTERFACE_CR NUMBER

Subledgers in intergace table (Credit)
RECEIVABLES_DR NUMBER

Posted Journals in AR (Debit)
RECEIVABLES_CR NUMBER

Posted Journals in AR (Credit)
ACCOUNT_TYPE VARCHAR2 (240)
GL Account Type
ACCOUNT VARCHAR2 (500)
Account Description
COMPANY VARCHAR2 (30)
Balancing Segment
ACCOUNT_DESC VARCHAR2 (240)
Accounting Segment Description
ACCOUNT_TYPE_CODE VARCHAR2 (30)
Query Text

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


SELECT CODE_COMBINATION_ID
,      OPENING_BALANCE_DR
,      OPENING_BALANCE_CR
,      PERIOD_ACTIVITY_DR
,      PERIOD_ACTIVITY_CR
,      SUBLEDGER_NOT_AR_DR
,      SUBLEDGER_NOT_AR_CR
,      SUBLEDGER_MANUAL_DR
,      SUBLEDGER_MANUAL_CR
,      SUBLEDGER_REC_DR
,      SUBLEDGER_REC_CR
,      GL_UNPOSTED_DR
,      GL_UNPOSTED_CR
,      GL_INTERFACE_DR
,      GL_INTERFACE_CR
,      RECEIVABLES_DR
,      RECEIVABLES_CR
,      ACCOUNT_TYPE
,      ACCOUNT
,      COMPANY
,      ACCOUNT_DESC
,      ACCOUNT_TYPE_CODE
FROM AR.AR_GL_RECON_GT;

Dependencies

[top of page]

AR.AR_GL_RECON_GT does not reference any database object

AR.AR_GL_RECON_GT is referenced by following:

SchemaAPPS
SynonymAR_GL_RECON_GT