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

TABLE: AP.AP_TB_BALANCES_TMP

Object Details
Object Name: AP_TB_BALANCES_TMP
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_TB_BALANCES_TMP
Subobject Name:
Status: VALID

AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER

Ledger Identifier
CODE_COMBINATION_ID NUMBER

Account Identifier
BALANCE_DATE DATE

Balance Date for which Balance Amount is stored
BALANCE_AMOUNT NUMBER

Balance Amount
Query Text

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


SELECT LEDGER_ID
,      CODE_COMBINATION_ID
,      BALANCE_DATE
,      BALANCE_AMOUNT
FROM AP.AP_TB_BALANCES_TMP;

Dependencies

[top of page]

AP.AP_TB_BALANCES_TMP does not reference any database object

AP.AP_TB_BALANCES_TMP is referenced by following:

SchemaAPPS
SynonymAP_TB_BALANCES_TMP