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

VIEW: APPS.XTR_TERM_ACTIONS_V

Object Details
Object Name: XTR_TERM_ACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_TERM_ACTIONS_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 Comments
DEAL_NO NUMBER

PRINCIPAL_ADJUST NUMBER

PRINCIPAL_ACTION VARCHAR2 (7)
PRINCIPAL_AMOUNT_TYPE VARCHAR2 (12)
INCREASE_EFFECTIVE_FROM_DATE DATE

NEW_PI_AMOUNT_DUE NUMBER

FROM_START_DATE DATE

MATURITY_DATE DATE

PAYMENT_SCHEDULE_CODE VARCHAR2 (7)
PAYMENT_FREQ VARCHAR2 (12)
NEXT_COUPON_DATE DATE

NEW_INTEREST_RATE NUMBER

EFFECTIVE_FROM_DATE DATE

FIXED_UNTIL DATE

CREATED_ON DATE

CREATED_BY VARCHAR2 (30)
AUDIT_INDICATOR VARCHAR2 (1)
DUAL_AUTHORISATION_ON DATE

DUAL_AUTHORISATION_BY VARCHAR2 (30)
MASS_RATE_UPDATE VARCHAR2 (1)
Query Text

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


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

Dependencies

[top of page]

APPS.XTR_TERM_ACTIONS_V references the following:

SchemaAPPS
SynonymXTR_TERM_ACTIONS
APPS.XTR_TERM_ACTIONS_V is referenced by following:

SchemaAPPS
Package BodyXTR_RATE_CHANGE - show dependent code