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

TABLE: FUN.FUN_BAL_INTER_INT_T

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

FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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 credit amount
ACCOUNTED_AMT_DR NUMBER

Accounted debit amount
ENTERED_AMT_CR NUMBER

Entered credit amount
ENTERED_AMT_DR NUMBER

Entered debit amount
REC_ACCT NUMBER (15)
Receivables account
PAY_ACCT NUMBER (15)
Payables account
BAL_SEG_COLUMN_NAME VARCHAR2 (25)
Balancing segment column name
REC_BSV VARCHAR2 (25)
Receivables balancing segment value
PAY_BSV VARCHAR2 (25)
Payables balancing segment value
EXCHANGE_DATE DATE

Currency exchange date
EXCHANGE_RATE NUMBER

Currency exchange rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type
TYPE VARCHAR2 (1)
Type
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_INT_T;

Dependencies

[top of page]

FUN.FUN_BAL_INTER_INT_T does not reference any database object

FUN.FUN_BAL_INTER_INT_T is referenced by following:

SchemaFUN
ViewFUN_BAL_INTER_INT_T#