[Home] [Help] [Dependency Information]
Object Name: | FUN_BAL_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_BAL_LINES_GT |
Subobject Name: | |
Status: | VALID |
FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing API.
FUN.FUN_BAL_LINES_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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FUN_BAL_LINES_GT_N1 | NORMAL | NONUNIQUE |
GROUP_ID
BAL_SEG_VAL | |
FUN_BAL_LINES_GT_N2 | NORMAL | NONUNIQUE | GENERATED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Yes | Group Id |
BAL_SEG_VAL | VARCHAR2 | (25) | Balancing Segment Value | |
ENTERED_AMT_DR | NUMBER | Entered Amount Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amount 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 Amount Debit | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted Amount Credit | ||
LINE_REFERENCE | VARCHAR2 | (25) | Line Reference | |
GENERATED | VARCHAR2 | (1) | Yes | Indicates whether the line has been generated by balancing API |
CCID | NUMBER | (15) | Code Combination Identifier |
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
, LINE_REFERENCE
, GENERATED
, CCID
FROM FUN.FUN_BAL_LINES_GT;
FUN.FUN_BAL_LINES_GT does not reference any database object
FUN.FUN_BAL_LINES_GT is referenced by following:
|
|
|