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


TABLE: FUN.FUN_BAL_ERRORS_GT

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

Temporary Table Details

FUN.FUN_BAL_ERRORS_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
Indexes
Index Type Uniqueness Tablespace Column
FUN_BAL_ERRORS_GT_N1 NORMAL NONUNIQUE Tablespace ColumnERROR_CODE
Columns
Name Datatype Length Mandatory Comments
ERROR_CODE VARCHAR2 (30)
Error Code
GROUP_ID NUMBER (15)
Group Id
BAL_SEG_VAL VARCHAR2 (25)
Bal Seg Val
DR_BSV VARCHAR2 (25)
Debit Bsv
CR_BSV VARCHAR2 (25)
Credit Bsv
CLEARING_BSV VARCHAR2 (25)
Clearing Bsv
LINE_REFERENCE VARCHAR2 (25)
Line Reference
FROM_LE_ID NUMBER (15)
From Legal Entity Identifier
TO_LE_ID NUMBER (15)
To Legal Entity Identifier
CCID NUMBER (15)
Code Combination Identifier
LE_ID NUMBER (15)
Legal Entity Identifier
CCID_CONCAT_DISPLAY VARCHAR2 (800)
Concatenated Account
TEMPLATE_ID NUMBER (15)
Template Id
ACCT_TYPE VARCHAR2 (1)
Account Type
Query Text

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


SELECT ERROR_CODE
,      GROUP_ID
,      BAL_SEG_VAL
,      DR_BSV
,      CR_BSV
,      CLEARING_BSV
,      LINE_REFERENCE
,      FROM_LE_ID
,      TO_LE_ID
,      CCID
,      LE_ID
,      CCID_CONCAT_DISPLAY
,      TEMPLATE_ID
,      ACCT_TYPE
FROM FUN.FUN_BAL_ERRORS_GT;

Dependencies

[top of page]

FUN.FUN_BAL_ERRORS_GT does not reference any database object

FUN.FUN_BAL_ERRORS_GT is referenced by following:

SchemaAPPS
SynonymFUN_BAL_ERRORS_GT