DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_TERM_ACTIONS

Object Details
Object Name: XTR_TERM_ACTIONS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_TERM_ACTIONS
Subobject Name:
Status: VALID


XTR_TERM_ACTIONS contains the details of the interest rates, principal adjustments, and schedule changes for retail term money deals. Each row corresponds to one action, for example sending a confirmation letter to a party.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
CREATED_BY VARCHAR2 (30)
User who created this record
CREATED_ON DATE

Date this record was created
DEAL_NO NUMBER

Unique number assigned to each deal
DUAL_AUTHORISATION_BY VARCHAR2 (30)
Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
DUAL_AUTHORISATION_ON DATE

Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
EFFECTIVE_FROM_DATE DATE

Interest rate adjustment effective date
FIXED_UNTIL DATE

Interest rate fixed until date
FROM_START_DATE DATE

Schedule change effective date
INCREASE_EFFECTIVE_FROM_DATE DATE

Principal adjustment effective date
MATURITY_DATE DATE

Date when the deal matures or when an action is required
NEW_INTEREST_RATE NUMBER

New interest rate
NEW_PI_AMOUNT_DUE NUMBER

New principal and interest repayment amount
NEXT_COUPON_DATE DATE

Next coupon date
PAYMENT_FREQ VARCHAR2 (12)
Payment frequency
PAYMENT_SCHEDULE_CODE VARCHAR2 (7)
Payment schedule code
PRINCIPAL_ACTION VARCHAR2 (7)
Principal action
PRINCIPAL_ADJUST NUMBER

Principal adjustment
PRINCIPAL_AMOUNT_TYPE VARCHAR2 (12)
Principal amount type
MASS_RATE_UPDATE VARCHAR2 (1)
Flag to indicate whether the interest rate adjustment is performed through the Mass Interest Rate Update concurrent program (Y) or not (N)
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 does not reference any database object

XTR.XTR_TERM_ACTIONS is referenced by following:

SchemaXTR
ViewXTR_TERM_ACTIONS#