eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XLA.XLA_AC_BALANCES

Object Details

Object Name:	XLA_AC_BALANCES
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_AC_BALANCES
Subobject Name:
Status:	VALID

Supporting Reference Balances table for maintaining balances

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_AC_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID LEDGER_ID CODE_COMBINATION_ID ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_TYPE_CODE AMB_CONTEXT_CODE AC1 PERIOD_NAME AC2 AC3 AC4 AC5
XLA_AC_BALANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID LEDGER_ID PERIOD_NAME CODE_COMBINATION_ID
XLA_AC_BALANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID PERIOD_NAME LEDGER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Internal identifier of the application associated with the supporting reference.
LEDGER_ID	NUMBER	(15)	Yes	Internal identifier of the ledger associated with the supporting reference.
CODE_COMBINATION_ID	NUMBER	(15)	Yes	The accounting Code combination identifier of the supporting reference.
ANALYTICAL_CRITERION_CODE	VARCHAR2	(30)	Yes	Supporting reference code.
ANALYTICAL_CRITERION_TYPE_CODE	VARCHAR2	(1)	Yes	Supporting reference type code, which indicates whether the supporting reference attached is seeded or user defined. If it is seeded then it will be stamped as �S� or else �C�.
AMB_CONTEXT_CODE	VARCHAR2	(30)	Yes	Accounting Methods Builder (AMB) context code
AC1	VARCHAR2	(30)		Supporting reference 1
AC2	VARCHAR2	(30)		Supporting reference 2
AC3	VARCHAR2	(30)		Supporting reference 3
AC4	VARCHAR2	(30)		Supporting reference 4
AC5	VARCHAR2	(30)		Supporting reference 5
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name
BEGINNING_BALANCE_DR	NUMBER			Beginning debit balance for the period. For initial period of the supporting reference �null� value will be populated in this column.
BEGINNING_BALANCE_CR	NUMBER			Beginning credit balance for the period. For initial period of the supporting reference �null� value will be populated in this column.
PERIOD_BALANCE_DR	NUMBER			Current period debit balance: made up of the period activity. If Journal Line Type (JLT) setup enabled for carried forward then this value will be carried forward to the next year.
PERIOD_BALANCE_CR	NUMBER			Current period credit balance: made up of the period activity. If Journal Line Type (JLT) setup enabled for carried forward then this value will be carried forward to the next year.
INITIAL_BALANCE_FLAG	VARCHAR2	(1)		Flag that shows if this is an initial balance. The values are: Y: initial balance N: non initial balance
FIRST_PERIOD_FLAG	VARCHAR2	(1)		This flag indicates if this is the first period in a fiscal year for which balances have been calculated for a given key. The values are: Y: first period in a fiscal year N: not first period in a fiscal year
PERIOD_YEAR	NUMBER			Fiscal year of the period
CREATION_DATE	DATE			Standard who column. Date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column. User who created this row.
LAST_UPDATE_DATE	DATE			Standard Who column. Date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column. User who last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column. Operating system login of user who last updated this row.
PROGRAM_UPDATE_DATE	DATE			Concurrent program who column. Date when a program last updated this row.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program who column. Application identifier of the program that last updated this row.
PROGRAM_ID	NUMBER	(15)		Concurrent program who column. Identifier of the program that last updated this row.
REQUEST_ID	NUMBER	(15)		Concurrent program who column. Identifier of the concurrent request that last updated this row.

Query Text

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


SELECT APPLICATION_ID
,      LEDGER_ID
,      CODE_COMBINATION_ID
,      ANALYTICAL_CRITERION_CODE
,      ANALYTICAL_CRITERION_TYPE_CODE
,      AMB_CONTEXT_CODE
,      AC1
,      AC2
,      AC3
,      AC4
,      AC5
,      PERIOD_NAME
,      BEGINNING_BALANCE_DR
,      BEGINNING_BALANCE_CR
,      PERIOD_BALANCE_DR
,      PERIOD_BALANCE_CR
,      INITIAL_BALANCE_FLAG
,      FIRST_PERIOD_FLAG
,      PERIOD_YEAR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
FROM XLA.XLA_AC_BALANCES;

Dependencies

[top of page]

XLA.XLA_AC_BALANCES does not reference any database object

XLA.XLA_AC_BALANCES is referenced by following:

APPS: XLA_AC_BALANCES