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]

VIEW: APPS.CE_INTEREST_RATES_V

Object Details

Object Name:	CE_INTEREST_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_INTEREST_RATES_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
INTEREST_SCHEDULE_ID	NUMBER	(15)	Yes
BALANCE_RANGE_ID	NUMBER
INTEREST_RATE_ID	NUMBER
EFFECTIVE_DATE	DATE
ORIGINAL_EFFECTIVE_DATE	DATE
ROW_STATUS	CHAR	(3)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
BAL_RANGE1	NUMBER
BAL_RANGE2	NUMBER
BAL_RANGE3	NUMBER
BAL_RANGE4	NUMBER
BAL_RANGE5	NUMBER
BAL_RANGE6	NUMBER
BAL_RANGE7	NUMBER
BAL_RANGE8	NUMBER
BAL_RANGE9	NUMBER
BAL_RANGE10	NUMBER
BAL_RANGE11	NUMBER
BAL_RANGE12	NUMBER
BAL_RANGE13	NUMBER
BAL_RANGE14	NUMBER
BAL_RANGE15	NUMBER
BAL_RANGE16	NUMBER
BAL_RANGE17	NUMBER
BAL_RANGE18	NUMBER
BAL_RANGE19	NUMBER
BAL_RANGE20	NUMBER
BAL_RANGE21	NUMBER
BAL_RANGE22	NUMBER
BAL_RANGE23	NUMBER
BAL_RANGE24	NUMBER
BAL_RANGE25	NUMBER
INTEREST_RATE_CREATE_ID	NUMBER

Query Text

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


SELECT INTEREST_SCHEDULE_ID
,      BALANCE_RANGE_ID
,      INTEREST_RATE_ID
,      EFFECTIVE_DATE
,      ORIGINAL_EFFECTIVE_DATE
,      ROW_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BAL_RANGE1
,      BAL_RANGE2
,      BAL_RANGE3
,      BAL_RANGE4
,      BAL_RANGE5
,      BAL_RANGE6
,      BAL_RANGE7
,      BAL_RANGE8
,      BAL_RANGE9
,      BAL_RANGE10
,      BAL_RANGE11
,      BAL_RANGE12
,      BAL_RANGE13
,      BAL_RANGE14
,      BAL_RANGE15
,      BAL_RANGE16
,      BAL_RANGE17
,      BAL_RANGE18
,      BAL_RANGE19
,      BAL_RANGE20
,      BAL_RANGE21
,      BAL_RANGE22
,      BAL_RANGE23
,      BAL_RANGE24
,      BAL_RANGE25
,      INTEREST_RATE_CREATE_ID
FROM APPS.CE_INTEREST_RATES_V;

Dependencies

[top of page]

APPS.CE_INTEREST_RATES_V references the following:

APPS: CE_INTEREST_BAL_RANGES; CE_INTEREST_RATES; FND_GLOBAL - show dependent code

APPS.CE_INTEREST_RATES_V is not referenced by any database object