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


TABLE: FUN.FUN_BAL_INTER_INT2_GT

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

Temporary Table Details

FUN.FUN_BAL_INTER_INT2_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)
LEDGER_ID NUMBER (15)
GL_DATE DATE

STATUS VARCHAR2 (5)
DRIVING_DR_LE_ID NUMBER (15)
DRIVING_CR_LE_ID NUMBER (15)
INTERCOMPANY_MODE NUMBER (4)
LE_ID NUMBER (15)
ENTERED_CURRENCY_CODE VARCHAR2 (15)
ACCOUNTED_AMT_CR NUMBER

ACCOUNTED_AMT_DR NUMBER

ENTERED_AMT_CR NUMBER

ENTERED_AMT_DR NUMBER

REC_ACCT NUMBER (15)
PAY_ACCT NUMBER (15)
BAL_SEG_COLUMN_NAME VARCHAR2 (25)
REC_BSV VARCHAR2 (25)
PAY_BSV VARCHAR2 (25)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
TYPE VARCHAR2 (1)
DRIVING_DR_LE_BSV VARCHAR2 (25)
DRIVING_CR_LE_BSV VARCHAR2 (25)
LINE_LE_BSV VARCHAR2 (25)
Query Text

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


SELECT GROUP_ID
,      LEDGER_ID
,      GL_DATE
,      STATUS
,      DRIVING_DR_LE_ID
,      DRIVING_CR_LE_ID
,      INTERCOMPANY_MODE
,      LE_ID
,      ENTERED_CURRENCY_CODE
,      ACCOUNTED_AMT_CR
,      ACCOUNTED_AMT_DR
,      ENTERED_AMT_CR
,      ENTERED_AMT_DR
,      REC_ACCT
,      PAY_ACCT
,      BAL_SEG_COLUMN_NAME
,      REC_BSV
,      PAY_BSV
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      TYPE
,      DRIVING_DR_LE_BSV
,      DRIVING_CR_LE_BSV
,      LINE_LE_BSV
FROM FUN.FUN_BAL_INTER_INT2_GT;

Dependencies

[top of page]

FUN.FUN_BAL_INTER_INT2_GT does not reference any database object

FUN.FUN_BAL_INTER_INT2_GT is referenced by following:

SchemaAPPS
SynonymFUN_BAL_INTER_INT2_GT