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: GL.GL_RX_TRIAL_BALANCE_ITF

Object Details

Object Name:	GL_RX_TRIAL_BALANCE_ITF
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_RX_TRIAL_BALANCE_ITF
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_RX_TRIAL_BALANCE_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent request defining column
PERIOD_NAME	VARCHAR2	(15)		Current period name
LEDGER_ID	NUMBER	(15)		Ledger defining column
LEDGER_NAME	VARCHAR2	(30)		Ledger name
CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Key flexfield structure defining column
CURRENCY_CODE	VARCHAR2	(15)		Currency
BALANCING_SEGMENT	VARCHAR2	(25)		Balancing Segment value
ACCOUNT_SEGMENT	VARCHAR2	(25)		Natural account segment value
BALANCING_DESCRIPTION	VARCHAR2	(240)		Balancing segment value description
ACCOUNT_DESCRIPTION	VARCHAR2	(240)		Natural account segment value description
SUMMARY_FLAG	VARCHAR2	(1)		Summary data indicator
BEGIN_YEAR_BALANCE_DR	NUMBER			Beginning of fiscal year debit balance
BEGIN_YEAR_BALANCE_CR	NUMBER			Beginning of fiscal year credit balance
BEGIN_ADJ_PERIOD_NET_DR	NUMBER			Debit movement for beginning adjustment period
BEGIN_ADJ_PERIOD_NET_CR	NUMBER			Credit movement for beginning adjustment period
PRIOR_PERIODS_NET_DR	NUMBER			Debit movement for previous regular periods
PRIOR_PERIODS_NET_CR	NUMBER			Credit movement for previous regular periods
BEGIN_PERIOD_BALANCE_DR	NUMBER			Beginning of current period debit balance
BEGIN_PERIOD_BALANCE_CR	NUMBER			Beginning of current period credit balance
PERIOD_NET_DR	NUMBER			Debit movement for current period
PERIOD_NET_CR	NUMBER			Credit movement for current period
YEAR_TO_DATE_BALANCE_DR	NUMBER			Year-to-date debit balance
YEAR_TO_DATE_BALANCE_CR	NUMBER			Year-to-date credit balance
YEAR_TO_DATE_NET_DIFFERENCE_DR	NUMBER			Net year-to-date debit balance
YEAR_TO_DATE_NET_DIFFERENCE_CR	NUMBER			Net year-to-date credit balance

Query Text

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


SELECT REQUEST_ID
,      PERIOD_NAME
,      LEDGER_ID
,      LEDGER_NAME
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      BALANCING_SEGMENT
,      ACCOUNT_SEGMENT
,      BALANCING_DESCRIPTION
,      ACCOUNT_DESCRIPTION
,      SUMMARY_FLAG
,      BEGIN_YEAR_BALANCE_DR
,      BEGIN_YEAR_BALANCE_CR
,      BEGIN_ADJ_PERIOD_NET_DR
,      BEGIN_ADJ_PERIOD_NET_CR
,      PRIOR_PERIODS_NET_DR
,      PRIOR_PERIODS_NET_CR
,      BEGIN_PERIOD_BALANCE_DR
,      BEGIN_PERIOD_BALANCE_CR
,      PERIOD_NET_DR
,      PERIOD_NET_CR
,      YEAR_TO_DATE_BALANCE_DR
,      YEAR_TO_DATE_BALANCE_CR
,      YEAR_TO_DATE_NET_DIFFERENCE_DR
,      YEAR_TO_DATE_NET_DIFFERENCE_CR
FROM GL.GL_RX_TRIAL_BALANCE_ITF;

Dependencies

[top of page]

GL.GL_RX_TRIAL_BALANCE_ITF does not reference any database object

GL.GL_RX_TRIAL_BALANCE_ITF is referenced by following:

GL: GL_RX_TRIAL_BALANCE_ITF#