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

TABLE: FUN.FUN_BAL_RESULTS_GT

Object Details
Object Name: FUN_BAL_RESULTS_GT
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_BAL_RESULTS_GT
Subobject Name:
Status: VALID

FUN_BAL_RESULTS_GT is a global temporary table used by the Intercompany balancing API. After balancing an Intercompany journal, the Intercompany balancing API inserts the resulting balancing lines into this table. Calling modules like SLA and GL read the results from this table and take appropriate action.

Temporary Table Details

FUN.FUN_BAL_RESULTS_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
GROUP_ID NUMBER (15)
Group Id
BAL_SEG_VAL VARCHAR2 (25)
Bal Seg Val
ENTERED_AMT_DR NUMBER

Entered Amt Debit
ENTERED_AMT_CR NUMBER

Entered Amt Credit
ENTERED_CURRENCY_CODE VARCHAR2 (15)
Entered Currency Code
EXCHANGE_DATE DATE

Exchange Date
EXCHANGE_RATE NUMBER

Exchange Rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
ACCOUNTED_AMT_DR NUMBER

Accounted Amt Debit
ACCOUNTED_AMT_CR NUMBER

Accounted Amt Credit
CCID NUMBER (15)
Ccid
JGZZ_RECON_STATUS VARCHAR2 (1)
GL Reconciliation column. Currently not used.
JGZZ_RECON_DATE DATE

GL Reconciliation column. Currently not used.
JGZZ_RECON_ID NUMBER (15)
GL Reconciliation column. Currently not used.
JGZZ_RECON_REF VARCHAR2 (240)
GL Reconciliation column. Currently not used.
JGZZ_RECON_CONTEXT VARCHAR2 (30)
GL Reconciliation column. Currently not used.
DR_BSV VARCHAR2 (25)
Debit Bsv
CR_BSV VARCHAR2 (25)
Credit Bsv
ACCT_TYPE VARCHAR2 (1)
Acct Type
TEMPLATE_ID NUMBER (15)
Template Id
LE_ID NUMBER (15)
Legal Entity Identifier
BALANCING_TYPE VARCHAR2 (1)
Balancing Type
Query Text

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


SELECT GROUP_ID
,      BAL_SEG_VAL
,      ENTERED_AMT_DR
,      ENTERED_AMT_CR
,      ENTERED_CURRENCY_CODE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      ACCOUNTED_AMT_DR
,      ACCOUNTED_AMT_CR
,      CCID
,      JGZZ_RECON_STATUS
,      JGZZ_RECON_DATE
,      JGZZ_RECON_ID
,      JGZZ_RECON_REF
,      JGZZ_RECON_CONTEXT
,      DR_BSV
,      CR_BSV
,      ACCT_TYPE
,      TEMPLATE_ID
,      LE_ID
,      BALANCING_TYPE
FROM FUN.FUN_BAL_RESULTS_GT;

Dependencies

[top of page]

FUN.FUN_BAL_RESULTS_GT does not reference any database object

FUN.FUN_BAL_RESULTS_GT is referenced by following:

SchemaAPPS
SynonymFUN_BAL_RESULTS_GT