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: CE.CE_INT_CALC_DETAILS_GT

Object Details

Object Name:	CE_INT_CALC_DETAILS_GT
Object Type:	TABLE
Owner:	CE
Subobject Name:
Status:	VALID

This temporary table is used to store interest rate calculation information.

Temporary Table Details

CE.CE_INT_CALC_DETAILS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
CE_INT_CALC_DETAILS_GT_N1	NORMAL	NONUNIQUE	INTEREST_SCHEDULE_ID
CE_INT_CALC_DETAILS_GT_N2	NORMAL	NONUNIQUE	BANK_ACCOUNT_ID
CE_INT_CALC_DETAILS_GT_U1	NORMAL	NONUNIQUE	INTEREST_CALC_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTEREST_CALC_DETAIL_ID	NUMBER	(15)	Yes	Uniquely identifies the interest calc detail
INTEREST_SCHEDULE_ID	NUMBER	(15)	Yes	Uniquely identifies the interest schedule
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Uniquely identifies the bank account
BALANCE_RANGE_ID	NUMBER	(15)		Uniquely identifies the interest schedule balance range
FROM_DATE	DATE
TO_DATE	DATE
VALUE_DATED_BALANCE	NUMBER
INTEREST_RATE	NUMBER
INTEREST_AMOUNT	NUMBER
NUMBER_OF_DAYS	NUMBER	(38)
RECORD_FROM	VARCHAR2	(15)
INTEREST_ACCT_TYPE	VARCHAR2	(30)
CASHPOOL_ID	NUMBER	(15)
CP_SUB_ACCOUNT_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT INTEREST_CALC_DETAIL_ID
,      INTEREST_SCHEDULE_ID
,      BANK_ACCOUNT_ID
,      BALANCE_RANGE_ID
,      FROM_DATE
,      TO_DATE
,      VALUE_DATED_BALANCE
,      INTEREST_RATE
,      INTEREST_AMOUNT
,      NUMBER_OF_DAYS
,      RECORD_FROM
,      INTEREST_ACCT_TYPE
,      CASHPOOL_ID
,      CP_SUB_ACCOUNT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM CE.CE_INT_CALC_DETAILS_GT;

Dependencies

[top of page]

CE.CE_INT_CALC_DETAILS_GT does not reference any database object

CE.CE_INT_CALC_DETAILS_GT is referenced by following:

APPS: CE_INT_CALC_DETAILS_GT