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: IGI.IGI_CBR_GL_RECON_BALANCE

Object Details

Object Name:	IGI_CBR_GL_RECON_BALANCE
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_CBR_GL_RECON_BALANCE
Subobject Name:
Status:	VALID

IGI_CBR_GL_RECON_BALANCE contains the beginning balance and period amount of the account in the accrual and cash Sets of Books.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SUM_ACCR_BEGIN_BALANCE	NUMBER		Beginning balance of account in accrual Set of Books
SUM_CASH_BEGIN_BALANCE	NUMBER		Beginning balance of account in cash Set of Books
SUM_ACCR_PERIOD_NET	NUMBER		Period net amount of account in accrual Set of Books
SUM_CASH_PERIOD_NET	NUMBER		Period net amount of account in cash Set of Books
ACCOUNT_NUM	VARCHAR2	(30)	Account number

Query Text

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


SELECT SUM_ACCR_BEGIN_BALANCE
,      SUM_CASH_BEGIN_BALANCE
,      SUM_ACCR_PERIOD_NET
,      SUM_CASH_PERIOD_NET
,      ACCOUNT_NUM
FROM IGI.IGI_CBR_GL_RECON_BALANCE;

Dependencies

[top of page]

IGI.IGI_CBR_GL_RECON_BALANCE does not reference any database object

IGI.IGI_CBR_GL_RECON_BALANCE is referenced by following:

APPS: IGI_CBR_GL_RECON_BALANCE