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_ROLLOVER_TRANSACTIONS#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCEPTOR_CODE	VARCHAR2	(7)
ACCEPTOR_NAME	VARCHAR2	(20)
ACCRUAL_FROM	DATE
ACCRUAL_TO	DATE
ACCUM_INTEREST	NUMBER
ACCUM_INTEREST_BF	NUMBER
ACCUM_INTEREST_BF_HCE	NUMBER
ACCUM_INTEREST_HCE	NUMBER
ACCUM_INT_ACCOUNT_NO	VARCHAR2	(20)
ACCUM_INT_ACTION	VARCHAR2	(7)
ACCUM_INT_AMOUNT_TYPE	VARCHAR2	(7)
ACTION_STATUS	VARCHAR2	(20)
ADJUSTED_BALANCE	NUMBER
ARCHIVE_BY	VARCHAR2	(30)
ARCHIVE_DATE	DATE
ATTACHMENT_EXISTS	VARCHAR2	(1)
AUDIT_INDICATOR	VARCHAR2	(1)
BALANCE_OUT	NUMBER
BALANCE_OUT_BF	NUMBER
BALANCE_OUT_BF_HCE	NUMBER
BALANCE_OUT_HCE	NUMBER
BAL_OS_ACCOUNT_NO	VARCHAR2	(20)
BKGE_SETTLED_REFERENCE	NUMBER
BROKERAGE_AMOUNT	NUMBER
BROKERAGE_AMOUNT_HCE	NUMBER
BROKERAGE_CODE	VARCHAR2	(7)
BROKERAGE_RATE	NUMBER
CLIENT_ADVICE	VARCHAR2	(1)
CLIENT_CODE	VARCHAR2	(7)
COMMENTS	VARCHAR2	(255)
COMPANY_CODE	VARCHAR2	(7)
CPARTY_ADVICE	VARCHAR2	(1)
CPARTY_CODE	VARCHAR2	(7)
CREATED_BY	VARCHAR2	(30)	Yes
CREATED_ON	DATE		Yes
CROSS_REF_TO_TRANS	NUMBER
CURRENCY	VARCHAR2	(15)	Yes
DATE_RECEIVED	DATE
DEALER_CODE	VARCHAR2	(10)
DEAL_DATE	DATE
DEAL_LINKING_CODE	VARCHAR2	(8)
DEAL_NUMBER	NUMBER		Yes
DEAL_SUBTYPE	VARCHAR2	(7)
DEAL_TYPE	VARCHAR2	(7)	Yes
DRAWER_CODE	VARCHAR2	(7)
DRAWER_NAME	VARCHAR2	(20)
DUAL_AUTHORISATION_BY	VARCHAR2	(30)
DUAL_AUTHORISATION_ON	DATE
ENDORSER_CODE	VARCHAR2	(7)
ENDORSER_NAME	VARCHAR2	(20)
EXPECTED_BALANCE_BF	NUMBER
EXPECTED_BALANCE_OUT	NUMBER
EXTERNAL_COMMENTS	VARCHAR2	(255)
EXTERNAL_CPARTY_NO	VARCHAR2	(15)
FID_TAX	NUMBER
FID_TAX_HCE	NUMBER
INTEREST	NUMBER
INTEREST_FREQ	VARCHAR2	(1)
INTEREST_HCE	NUMBER
INTEREST_RATE	NUMBER
INTEREST_SETTLED	NUMBER
INTEREST_SETTLEMENT_TYPE	VARCHAR2	(1)
INTERNAL_TICKET_NO	VARCHAR2	(15)
ISSUER_ADVICE	VARCHAR2	(1)
LIMIT_CODE	VARCHAR2	(7)
MATURITY_DATE	DATE
NI_PROFIT_LOSS	NUMBER
NI_PROFIT_LOSS_HCE	NUMBER
NI_RENEG_DATE	DATE
NO_OF_DAYS	NUMBER
OLD_PRODUCT_TYPE	VARCHAR2	(10)
PARCEL_SPLIT_NO	NUMBER
PARENT_PARTY	VARCHAR2	(7)
PI_AMOUNT_DUE	NUMBER
PI_AMOUNT_RECEIVED	NUMBER
PORTFOLIO_CODE	VARCHAR2	(7)
PRINCIPAL_ACCOUNT_NO	VARCHAR2	(20)
PRINCIPAL_ACTION	VARCHAR2	(7)
PRINCIPAL_ADJUST	NUMBER
PRINCIPAL_ADJUST_HCE	NUMBER
PRINCIPAL_AMOUNT_TYPE	VARCHAR2	(12)
PRINTED_CPARTY_ADVICE	VARCHAR2	(1)
PRINTED_REDEMPTION_YN	VARCHAR2	(1)
PRINTED_YN	VARCHAR2	(1)
PRODUCT_TYPE	VARCHAR2	(10)
QUICK_INPUT	VARCHAR2	(1)
RATE_EFFECTIVE_CREATED	DATE
RENEG_ONLY_LETTER	VARCHAR2	(1)
REPAY_AMOUNT	NUMBER
REPAY_AMOUNT_HCE	NUMBER
SECURITY_TYPE	VARCHAR2	(1)
SETTLEMENT_TYPE	VARCHAR2	(1)
SETTLE_DATE	DATE
SETTLE_TERM_INTEREST	VARCHAR2	(1)
START_DATE	DATE
STATUS_CODE	VARCHAR2	(10)
TAX_AMOUNT	NUMBER
TAX_AMOUNT_HCE	NUMBER
TAX_CODE	VARCHAR2	(7)
TAX_RATE	NUMBER
TAX_SETTLED_REFERENCE	NUMBER
TRANSACTION_NUMBER	NUMBER		Yes
TRANS_CLOSEOUT_NO	NUMBER
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
YEAR_BASIS	NUMBER
YEAR_CALC_TYPE	VARCHAR2	(15)
RATE_FIXING_DATE	DATE
FIRST_REVAL_BATCH_ID	NUMBER	(15)
LAST_REVAL_BATCH_ID	NUMBER	(15)
CURRENCY_EXCHANGE_RATE	NUMBER
INITIAL_FAIR_VALUE	NUMBER
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ALL_IN_RATE	NUMBER
AVERAGE_EXCHANGE_RATE	NUMBER
BACK_END_BROKERAGE_AMOUNT	NUMBER
ORIG_COUPON_AMOUNT	NUMBER
QUANTITY	NUMBER
ORIGINAL_AMOUNT	NUMBER
FIRST_TRANSACTION_FLAG	VARCHAR2	(1)
PRINCIPAL_TAX_CODE	VARCHAR2	(7)
PRINCIPAL_TAX_RATE	NUMBER
PRINCIPAL_TAX_AMOUNT	NUMBER
PRINCIPAL_TAX_SETTLED_REF	NUMBER
PREPAID_INTEREST	VARCHAR2	(1)
INTEREST_REFUND	NUMBER
ORG_TRANS_NO	NUMBER
COUPON_DUE_DATE	DATE
PRINCIPAL_ACCT_USE_ID	NUMBER	(15)
ACCUM_INT_ACCT_USE_ID	NUMBER	(15)
BAL_OS_ACCT_USE_ID	NUMBER	(15)

Query Text

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


SELECT ACCEPTOR_CODE
,      ACCEPTOR_NAME
,      ACCRUAL_FROM
,      ACCRUAL_TO
,      ACCUM_INTEREST
,      ACCUM_INTEREST_BF
,      ACCUM_INTEREST_BF_HCE
,      ACCUM_INTEREST_HCE
,      ACCUM_INT_ACCOUNT_NO
,      ACCUM_INT_ACTION
,      ACCUM_INT_AMOUNT_TYPE
,      ACTION_STATUS
,      ADJUSTED_BALANCE
,      ARCHIVE_BY
,      ARCHIVE_DATE
,      ATTACHMENT_EXISTS
,      AUDIT_INDICATOR
,      BALANCE_OUT
,      BALANCE_OUT_BF
,      BALANCE_OUT_BF_HCE
,      BALANCE_OUT_HCE
,      BAL_OS_ACCOUNT_NO
,      BKGE_SETTLED_REFERENCE
,      BROKERAGE_AMOUNT
,      BROKERAGE_AMOUNT_HCE
,      BROKERAGE_CODE
,      BROKERAGE_RATE
,      CLIENT_ADVICE
,      CLIENT_CODE
,      COMMENTS
,      COMPANY_CODE
,      CPARTY_ADVICE
,      CPARTY_CODE
,      CREATED_BY
,      CREATED_ON
,      CROSS_REF_TO_TRANS
,      CURRENCY
,      DATE_RECEIVED
,      DEALER_CODE
,      DEAL_DATE
,      DEAL_LINKING_CODE
,      DEAL_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DRAWER_CODE
,      DRAWER_NAME
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      ENDORSER_CODE
,      ENDORSER_NAME
,      EXPECTED_BALANCE_BF
,      EXPECTED_BALANCE_OUT
,      EXTERNAL_COMMENTS
,      EXTERNAL_CPARTY_NO
,      FID_TAX
,      FID_TAX_HCE
,      INTEREST
,      INTEREST_FREQ
,      INTEREST_HCE
,      INTEREST_RATE
,      INTEREST_SETTLED
,      INTEREST_SETTLEMENT_TYPE
,      INTERNAL_TICKET_NO
,      ISSUER_ADVICE
,      LIMIT_CODE
,      MATURITY_DATE
,      NI_PROFIT_LOSS
,      NI_PROFIT_LOSS_HCE
,      NI_RENEG_DATE
,      NO_OF_DAYS
,      OLD_PRODUCT_TYPE
,      PARCEL_SPLIT_NO
,      PARENT_PARTY
,      PI_AMOUNT_DUE
,      PI_AMOUNT_RECEIVED
,      PORTFOLIO_CODE
,      PRINCIPAL_ACCOUNT_NO
,      PRINCIPAL_ACTION
,      PRINCIPAL_ADJUST
,      PRINCIPAL_ADJUST_HCE
,      PRINCIPAL_AMOUNT_TYPE
,      PRINTED_CPARTY_ADVICE
,      PRINTED_REDEMPTION_YN
,      PRINTED_YN
,      PRODUCT_TYPE
,      QUICK_INPUT
,      RATE_EFFECTIVE_CREATED
,      RENEG_ONLY_LETTER
,      REPAY_AMOUNT
,      REPAY_AMOUNT_HCE
,      SECURITY_TYPE
,      SETTLEMENT_TYPE
,      SETTLE_DATE
,      SETTLE_TERM_INTEREST
,      START_DATE
,      STATUS_CODE
,      TAX_AMOUNT
,      TAX_AMOUNT_HCE
,      TAX_CODE
,      TAX_RATE
,      TAX_SETTLED_REFERENCE
,      TRANSACTION_NUMBER
,      TRANS_CLOSEOUT_NO
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      YEAR_CALC_TYPE
,      RATE_FIXING_DATE
,      FIRST_REVAL_BATCH_ID
,      LAST_REVAL_BATCH_ID
,      CURRENCY_EXCHANGE_RATE
,      INITIAL_FAIR_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ALL_IN_RATE
,      AVERAGE_EXCHANGE_RATE
,      BACK_END_BROKERAGE_AMOUNT
,      ORIG_COUPON_AMOUNT
,      QUANTITY
,      ORIGINAL_AMOUNT
,      FIRST_TRANSACTION_FLAG
,      PRINCIPAL_TAX_CODE
,      PRINCIPAL_TAX_RATE
,      PRINCIPAL_TAX_AMOUNT
,      PRINCIPAL_TAX_SETTLED_REF
,      PREPAID_INTEREST
,      INTEREST_REFUND
,      ORG_TRANS_NO
,      COUPON_DUE_DATE
,      PRINCIPAL_ACCT_USE_ID
,      ACCUM_INT_ACCT_USE_ID
,      BAL_OS_ACCT_USE_ID
FROM XTR.XTR_ROLLOVER_TRANSACTIONS#;

Dependencies

[top of page]

XTR.XTR_ROLLOVER_TRANSACTIONS# references the following:

XTR: XTR_ROLLOVER_TRANSACTIONS

XTR.XTR_ROLLOVER_TRANSACTIONS# is referenced by following:

APPS: XTR_AID_ROLLOVER_TRANS_T; XTR_AU_ROLLOVER_TRANSACTIONS_T; XTR_BI_ROLLOVER_TRANSACTIONS_T; XTR_BU_ROLLOVER_TRANSACTIONS_T; XTR_ROLLOVER_TRANSACTIONS