[Home] [Help] [Dependency Information]
Object Name: | FUN_BAL_INTER_INT_GT |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_BAL_INTER_INT_GT |
Subobject Name: | |
Status: | VALID |
FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.
FUN.FUN_BAL_INTER_INT_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_INTER_INT_GT_N1 | NORMAL | NONUNIQUE | GROUP_ID | |
FUN_BAL_INTER_INT_GT_N2 | NORMAL | NONUNIQUE | INTERCOMPANY_MODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group Identifier | |
LEDGER_ID | NUMBER | (15) | Ledger Identifier | |
GL_DATE | DATE | Gl Date | ||
STATUS | VARCHAR2 | (5) | Status | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving Debit Legal Entity Identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving Credit Legal Entity Identifier | |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany Mode | |
LE_ID | NUMBER | (15) | Legal Entity Identifier | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered Currency Code | |
ACCOUNTED_AMT_CR | NUMBER | Accounted Amount Credit | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted Amount Debit | ||
ENTERED_AMT_CR | NUMBER | Entered Amount Credit | ||
ENTERED_AMT_DR | NUMBER | Entered Identifier Debit | ||
REC_ACCT | NUMBER | (15) | Receivables Account | |
PAY_ACCT | NUMBER | (15) | Payables Account | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Bal Seg Column Name | |
REC_BSV | VARCHAR2 | (25) | Rec Bsv | |
PAY_BSV | VARCHAR2 | (25) | Pay Bsv | |
EXCHANGE_DATE | DATE | Exchange Date | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
TYPE | VARCHAR2 | (1) | Type | |
DRIVING_DR_LE_BSV | VARCHAR2 | (25) | Driving Dr Le Bsv | |
DRIVING_CR_LE_BSV | VARCHAR2 | (25) | Driving Cr Le Bsv | |
LINE_LE_BSV | VARCHAR2 | (25) | Line Le Bsv |
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_INT_GT;
FUN.FUN_BAL_INTER_INT_GT does not reference any database object
FUN.FUN_BAL_INTER_INT_GT is referenced by following:
|
|
|