VIEW: APPS.XTR_R_ROLLOVER_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT 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 , 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 , RATE_FIXING_DATE FROM XTR_R_ROLLOVER_TRANSACTIONS

View Text - HTML Formatted

SELECT 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
, 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
, RATE_FIXING_DATE
FROM XTR_R_ROLLOVER_TRANSACTIONS