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

TABLE: FUN.FUN_BAL_LINES_T

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

FUN_BAL_LINES_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) Yes Group identifier
BAL_SEG_VAL VARCHAR2 (25)
BSV on journal line
ENTERED_AMT_DR NUMBER

Entered debit amount
ENTERED_AMT_CR NUMBER

Entered credit amount
ENTERED_CURRENCY_CODE VARCHAR2 (15)
Entered currency code
EXCHANGE_DATE DATE

Currency exchange date
EXCHANGE_RATE NUMBER

Currency exchange rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type
ACCOUNTED_AMT_DR NUMBER

Accounted debit amount
ACCOUNTED_AMT_CR NUMBER

Accounted credit amount
LINE_REFERENCE VARCHAR2 (25)
Line reference
GENERATED VARCHAR2 (1) Yes Indicates whether the line has been generated by balancing API
CCID NUMBER (15)
Query Text

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_T;

Dependencies

[top of page]

FUN.FUN_BAL_LINES_T does not reference any database object

FUN.FUN_BAL_LINES_T is referenced by following:

SchemaFUN
ViewFUN_BAL_LINES_T#