[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_ROLLOVER_TRANSACTIONS_V

Object Details

Object Name:	XTR_ROLLOVER_TRANSACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_ROLLOVER_TRANSACTIONS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT 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
,      PRINCIPAL_TAX_CODE
,      PRINCIPAL_TAX_RATE
,      PRINCIPAL_TAX_AMOUNT
,      PRINCIPAL_TAX_SETTLED_REF
,      TRANSACTION_NUMBER
,      TRANS_CLOSEOUT_NO
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      YEAR_CALC_TYPE
,      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
,      RATE_FIXING_DATE
,      FIRST_REVAL_BATCH_ID
,      LAST_REVAL_BATCH_ID
,      CURRENCY_EXCHANGE_RATE
,      INITIAL_FAIR_VALUE
,      ALL_IN_RATE
,      AVERAGE_EXCHANGE_RATE
,      BACK_END_BROKERAGE_AMOUNT
,      QUANTITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIG_COUPON_AMOUNT
,      ORIGINAL_AMOUNT
,      FIRST_TRANSACTION_FLAG
,      PREPAID_INTEREST
,      INTEREST_REFUND
,      ORG_TRANS_NO
,      COUPON_DUE_DATE
FROM APPS.XTR_ROLLOVER_TRANSACTIONS_V;

Dependencies

[top of page]

APPS

XTR_COMPANY_AUTHORITIES

XTR_ROLLOVER_TRANSACTIONS

XTR_USER_ACCESS - show dependent code

APPS

QRM_PA_CALCULATION_P - show dependent code

XTR_AUTO_RECONCILIATION - show dependent code

XTR_A_ALL_CONTRACTS_V

XTR_CALCULATION_P - show dependent code

XTR_CALC_P - show dependent code

XTR_CANCELLED_TRANSACTIONS_V

XTR_CASH_TRANSACTIONS_V

XTR_EXP_SUMM_P - show dependent code

XTR_FPS2_P - show dependent code

XTR_FPS2_P - show dependent code

XTR_FPS3_P - show dependent code

XTR_LINKED_TRANSACTIONS_V

XTR_MISC_P - show dependent code

XTR_NI_TRANSFERS_PKG - show dependent code

XTR_RATE_CHANGE - show dependent code

XTR_REVAL_PROCESS_P - show dependent code

XTR_REVIEW_ALL_CONTRACTS_V

XTR_TAX_BROKERAGE_DETAILS_V

XTR_TMM_SUMMARY_V

XTR_TRANS_VALIDATIONS_V

XTR_WORKFLOW_PKG - show dependent code