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: XTR.XTR_TERM_ACTIONS#

Object Details

Object Name:	XTR_TERM_ACTIONS#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
AUDIT_INDICATOR	VARCHAR2	(1)
CREATED_BY	VARCHAR2	(30)
CREATED_ON	DATE
DEAL_NO	NUMBER
DUAL_AUTHORISATION_BY	VARCHAR2	(30)
DUAL_AUTHORISATION_ON	DATE
EFFECTIVE_FROM_DATE	DATE
FIXED_UNTIL	DATE
FROM_START_DATE	DATE
INCREASE_EFFECTIVE_FROM_DATE	DATE
MATURITY_DATE	DATE
NEW_INTEREST_RATE	NUMBER
NEW_PI_AMOUNT_DUE	NUMBER
NEXT_COUPON_DATE	DATE
PAYMENT_FREQ	VARCHAR2	(12)
PAYMENT_SCHEDULE_CODE	VARCHAR2	(7)
PRINCIPAL_ACTION	VARCHAR2	(7)
PRINCIPAL_ADJUST	NUMBER
PRINCIPAL_AMOUNT_TYPE	VARCHAR2	(12)
MASS_RATE_UPDATE	VARCHAR2	(1)

Query Text

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


SELECT AUDIT_INDICATOR
,      CREATED_BY
,      CREATED_ON
,      DEAL_NO
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      EFFECTIVE_FROM_DATE
,      FIXED_UNTIL
,      FROM_START_DATE
,      INCREASE_EFFECTIVE_FROM_DATE
,      MATURITY_DATE
,      NEW_INTEREST_RATE
,      NEW_PI_AMOUNT_DUE
,      NEXT_COUPON_DATE
,      PAYMENT_FREQ
,      PAYMENT_SCHEDULE_CODE
,      PRINCIPAL_ACTION
,      PRINCIPAL_ADJUST
,      PRINCIPAL_AMOUNT_TYPE
,      MASS_RATE_UPDATE
FROM XTR.XTR_TERM_ACTIONS#;

Dependencies

[top of page]

XTR.XTR_TERM_ACTIONS# references the following:

XTR: XTR_TERM_ACTIONS

XTR.XTR_TERM_ACTIONS# is referenced by following:

APPS: XTR_TERM_ACTIONS