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: FTP.FTP_INTEREST_RATES_AUDIT

Object Details

Object Name:	FTP_INTEREST_RATES_AUDIT
Object Type:	TABLE
Owner:	FTP
Subobject Name:
Status:	VALID

The FTP_INTEREST_RATES_AUDIT table contains forecasted interest rate data. The table is populated when you select Forward Rates or 1 Month Rates audit parameters during option cost processing. These audit parameters are disabled if you do not specify option costs parameters while defining versions for a Transfer Pricing Process rule. You can refer to these rates using Oracle Discoverer.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTP_INTEREST_RATES_AUDIT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID CALC_SOURCE_CODE START_DATE SCENARIO_NUM INTEREST_RATE_CODE INTEREST_RATE_TERM INTEREST_RATE_TERM_MULT BUCKET_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Identifies the Application process run for which the interest rate audit information applies
CALC_SOURCE_CODE	NUMBER	(5)	Yes	Designates how the audit data was generated
START_DATE	DATE		Yes	Date the process was run
SCENARIO_NUM	NUMBER	(10)	Yes	Scenario number for which the data applies
INTEREST_RATE_CODE	NUMBER	(5)	Yes	Interest Rate Code for the audit record
INTEREST_RATE_TERM	NUMBER	(5)	Yes	Interest rate term for the audit record
INTEREST_RATE_TERM_MULT	VARCHAR2	(1)	Yes	Multiplier for the specified Interest Rate Term: D for Day, M for Month, or Y for Year
BUCKET_NUM	NUMBER	(5)	Yes	Date bucket for the audit record
BUCKET_START_DATE	DATE		Yes	Beginning date for the specified bucket number
BUCKET_END_DATE	DATE		Yes	Ending date for the specified bucket number
RATE	NUMBER	(10)	Yes	Forecasted interest rate for the specified date bucket
PROCESS_DATE	DATE		Yes	Date the Application process was run

Query Text

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


SELECT OBJECT_ID
,      CALC_SOURCE_CODE
,      START_DATE
,      SCENARIO_NUM
,      INTEREST_RATE_CODE
,      INTEREST_RATE_TERM
,      INTEREST_RATE_TERM_MULT
,      BUCKET_NUM
,      BUCKET_START_DATE
,      BUCKET_END_DATE
,      RATE
,      PROCESS_DATE
FROM FTP.FTP_INTEREST_RATES_AUDIT;

Dependencies

[top of page]

FTP.FTP_INTEREST_RATES_AUDIT does not reference any database object

FTP.FTP_INTEREST_RATES_AUDIT is referenced by following:

APPS: FTP_INTEREST_RATES_AUDIT