[Home] [Help]
[Dependency Information]
| Object Name: | FUN_BAL_INTER_INT2_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | FUN |
| FND Design Data: | FUN.FUN_BAL_INTER_INT2_GT
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: | ![]() |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| 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) |
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;
FUN.FUN_BAL_INTER_INT2_GT does not reference any database object
FUN.FUN_BAL_INTER_INT2_GT is referenced by following:
APPS
FUN_BAL_INTER_INT2_GT
|
|
|
|