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

TABLE: FUN.FUN_BAL_INTRA_BSV_MAP_T

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

FUN_BAL_INTRA_BSV_MAP_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
LEDGER_ID NUMBER (15) Yes Ledger identifier
LE_ID NUMBER (15)
Legal entity identifier
BAL_SEG_VAL VARCHAR2 (25) Yes Balancing segment value
GL_DATE DATE

GL Date
DRIVING_DR_BSV VARCHAR2 (25)
Driving debit balancing segment value
DRIVING_CR_BSV VARCHAR2 (25)
Driving credit balancing segment value
INTRACOMPANY_MODE NUMBER (4)
Intracompany mode
TEMPLATE_ID NUMBER

Template identifier
BALANCE_BY VARCHAR2 (1)
Balance by
CLEARING_OPTION VARCHAR2 (2)
Clearing option
JE_SOURCE_NAME VARCHAR2 (25)
Journal source name
JE_CATEGORY_NAME VARCHAR2 (25)
Journal category name
CLEARING_BSV VARCHAR2 (25)
Clearing balancing segment value
DR_CR_DEBIT_CCID NUMBER (15)
Debit account
DR_CR_CREDIT_CCID NUMBER (15)
Credit account
CR_DR_DEBIT_CCID NUMBER (15)
Debit account
CR_DR_CREDIT_CCID NUMBER (15)
Credit account
BAL_SEG_COLUMN_NUMBER NUMBER (2)
Balancing segment column number
INTERCOMPANY_COLUMN_NUMBER NUMBER (2)
Intercompany segment column number
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of accounts identifier
MANY_TO_MANY_OPTION VARCHAR2 (2)
Many to many option
DR_CR_DEBIT_COMPLETE VARCHAR2 (1)
Debit complete
DR_CR_CREDIT_COMPLETE VARCHAR2 (1)
Credit complete
CR_DR_DEBIT_COMPLETE VARCHAR2 (1)
Debit complete
CR_DR_CREDIT_COMPLETE VARCHAR2 (1)
Credit complete
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_ID
,      LEDGER_ID
,      LE_ID
,      BAL_SEG_VAL
,      GL_DATE
,      DRIVING_DR_BSV
,      DRIVING_CR_BSV
,      INTRACOMPANY_MODE
,      TEMPLATE_ID
,      BALANCE_BY
,      CLEARING_OPTION
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      CLEARING_BSV
,      DR_CR_DEBIT_CCID
,      DR_CR_CREDIT_CCID
,      CR_DR_DEBIT_CCID
,      CR_DR_CREDIT_CCID
,      BAL_SEG_COLUMN_NUMBER
,      INTERCOMPANY_COLUMN_NUMBER
,      CHART_OF_ACCOUNTS_ID
,      MANY_TO_MANY_OPTION
,      DR_CR_DEBIT_COMPLETE
,      DR_CR_CREDIT_COMPLETE
,      CR_DR_DEBIT_COMPLETE
,      CR_DR_CREDIT_COMPLETE
FROM FUN.FUN_BAL_INTRA_BSV_MAP_T;

Dependencies

[top of page]

FUN.FUN_BAL_INTRA_BSV_MAP_T does not reference any database object

FUN.FUN_BAL_INTRA_BSV_MAP_T is referenced by following:

SchemaFUN
ViewFUN_BAL_INTRA_BSV_MAP_T#