VIEW: XTR.XTR_R_DEALS#

Source

View Text - Preformatted

select ACCEPTOR_CODE ACCEPTOR_CODE, ACCEPTOR_NAME ACCEPTOR_NAME, ACCRUAL_FROM ACCRUAL_FROM, ACCRUAL_TO ACCRUAL_TO, ACCRUED_INTEREST_PRICE ACCRUED_INTEREST_PRICE, ACTION_STATUS ACTION_STATUS, ARCHIVE_BY ARCHIVE_BY, ARCHIVE_DATE ARCHIVE_DATE, ATTACHMENT_EXISTS ATTACHMENT_EXISTS, AUDIT_INDICATOR AUDIT_INDICATOR, BASE_DATE BASE_DATE, BASE_RATE BASE_RATE, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE, BOND_ISSUE BOND_ISSUE, BOND_PROFIT_LOSS BOND_PROFIT_LOSS, BOND_RENEG_DATE BOND_RENEG_DATE, BOND_RESALE_DATE BOND_RESALE_DATE, BOND_SALE_DATE BOND_SALE_DATE, BROKER BROKER, BROKERAGE_AMOUNT BROKERAGE_AMOUNT, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE, BROKERAGE_CODE BROKERAGE_CODE, BROKERAGE_CURRENCY BROKERAGE_CURRENCY, BROKERAGE_RATE BROKERAGE_RATE, BUY_ACCOUNT_NO BUY_ACCOUNT_NO, BUY_AMOUNT BUY_AMOUNT, BUY_HCE_AMOUNT BUY_HCE_AMOUNT, CALC_BASIS CALC_BASIS, CAPITAL_PRICE CAPITAL_PRICE, CAP_OR_FLOOR CAP_OR_FLOOR, CLIENT_ADVICE CLIENT_ADVICE, CLIENT_CODE CLIENT_CODE, CLIENT_REF CLIENT_REF, COMMENCE_DATE COMMENCE_DATE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CONTRACT_COMMISSION CONTRACT_COMMISSION, CONTRACT_FEES CONTRACT_FEES, CONTRACT_NOS CONTRACT_NOS, CONTRACT_RATE CONTRACT_RATE, COUPON_ACTION COUPON_ACTION, COUPON_RATE COUPON_RATE, CPARTY_ADVICE CPARTY_ADVICE, CPARTY_CODE CPARTY_CODE, CPARTY_REF CPARTY_REF, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CTY_CCY CTY_CCY, CUM_COUPON_DATE CUM_COUPON_DATE, CURRENCY CURRENCY, CURRENCY_BUY CURRENCY_BUY, CURRENCY_SELL CURRENCY_SELL, DEALER_CODE DEALER_CODE, DEAL_DATE DEAL_DATE, DEAL_LINKING_CODE DEAL_LINKING_CODE, DEAL_NO DEAL_NO, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DISCOUNT DISCOUNT, DRAWER_CODE DRAWER_CODE, DRAWER_NAME DRAWER_NAME, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON, ENDORSER_CODE ENDORSER_CODE, ENDORSER_NAME ENDORSER_NAME, ENTER_INTO_SWAP ENTER_INTO_SWAP, EXCHANGE_CODE EXCHANGE_CODE, EXERCISE EXERCISE, EXPIRY_DATE EXPIRY_DATE, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO, FACE_VALUE_AMOUNT FACE_VALUE_AMOUNT, FACE_VALUE_HCE_AMOUNT FACE_VALUE_HCE_AMOUNT, FIRST_REVAL FIRST_REVAL, FIXED_OR_FLOATING_RATE FIXED_OR_FLOATING_RATE, FIXED_TERM_MY FIXED_TERM_MY, FRA_DESCRIPTION FRA_DESCRIPTION, FREQUENCY FREQUENCY, FXD_DEAL_NO FXD_DEAL_NO, FXO_DEAL_NO FXO_DEAL_NO, FX_COVER_CROSS_REF FX_COVER_CROSS_REF, FX_PD_DEAL_NO FX_PD_DEAL_NO, FX_REVALUED_ON_DATE FX_REVALUED_ON_DATE, FX_RO_DEAL_NO FX_RO_DEAL_NO, FX_SUBSIDIARY_BALANCE_AMOUNT FX_SUBSIDIARY_BALANCE_AMOUNT, FX_WHOLESALE_REF FX_WHOLESALE_REF, INSERT_FOR_CASHFLOW INSERT_FOR_CASHFLOW, FORWARD_HCE_AMOUNT FORWARD_HCE_AMOUNT, INTEREST_AMOUNT INTEREST_AMOUNT, INTEREST_CUTOFF INTEREST_CUTOFF, INTEREST_HCE_AMOUNT INTEREST_HCE_AMOUNT, INTEREST_RATE INTEREST_RATE, INTERNAL_TICKET_NO INTERNAL_TICKET_NO, INT_SWAP_REF INT_SWAP_REF, KNOCK_EXECUTED_BY KNOCK_EXECUTED_BY, KNOCK_EXECUTED_ON KNOCK_EXECUTED_ON, KNOCK_INSERT_TYPE KNOCK_INSERT_TYPE, KNOCK_LEVEL KNOCK_LEVEL, KNOCK_TYPE KNOCK_TYPE, LIMIT_AMOUNT LIMIT_AMOUNT, LIMIT_CODE LIMIT_CODE, MARGIN MARGIN, MATURITY_ACCOUNT_NO MATURITY_ACCOUNT_NO, MATURITY_AMOUNT MATURITY_AMOUNT, MATURITY_BALANCE_AMOUNT MATURITY_BALANCE_AMOUNT, MATURITY_BALANCE_HCE_AMOUNT MATURITY_BALANCE_HCE_AMOUNT, MATURITY_DATE MATURITY_DATE, MATURITY_HCE_AMOUNT MATURITY_HCE_AMOUNT, NEXT_COUPON_DATE NEXT_COUPON_DATE, NI_DEAL_NO NI_DEAL_NO, NI_PROFIT_LOSS NI_PROFIT_LOSS, NO_OF_DAYS NO_OF_DAYS, OPTION_AMOUNT OPTION_AMOUNT, OPTION_COMMENCEMENT OPTION_COMMENCEMENT, OPTION_HCE_AMOUNT OPTION_HCE_AMOUNT, OPTION_POINTS OPTION_POINTS, OPTION_TYPE OPTION_TYPE, PAYMENT_FREQ PAYMENT_FREQ, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE, PI_AMOUNT_DUE PI_AMOUNT_DUE, PORTFOLIO_AMOUNT PORTFOLIO_AMOUNT, PORTFOLIO_CODE PORTFOLIO_CODE, PREMIUM_ACCOUNT_NO PREMIUM_ACCOUNT_NO, PREMIUM_ACTION PREMIUM_ACTION, PREMIUM_AMOUNT PREMIUM_AMOUNT, PREMIUM_AMOUNT_TYPE PREMIUM_AMOUNT_TYPE, PREMIUM_CURRENCY PREMIUM_CURRENCY, PREMIUM_DATE PREMIUM_DATE, PREMIUM_HCE_AMOUNT PREMIUM_HCE_AMOUNT, PREMIUM_NO_OF_DAYS PREMIUM_NO_OF_DAYS, PRINCIPAL_SETTLED_BY PRINCIPAL_SETTLED_BY, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE, PRINTED_YN PRINTED_YN, PRODUCT_TYPE PRODUCT_TYPE, QUICK_INPUT QUICK_INPUT, RATE_BASIS RATE_BASIS, REF_CCY REF_CCY, RENEG_DATE RENEG_DATE, RISKPARTY_CODE RISKPARTY_CODE, RISKPARTY_LIMIT_CODE RISKPARTY_LIMIT_CODE, SECURITY_NAME SECURITY_NAME, SELL_ACCOUNT_NO SELL_ACCOUNT_NO, SELL_AMOUNT SELL_AMOUNT, SELL_HCE_AMOUNT SELL_HCE_AMOUNT, SETTLE_ACCOUNT_NO SETTLE_ACCOUNT_NO, SETTLE_ACTION SETTLE_ACTION, SETTLE_AMOUNT SETTLE_AMOUNT, SETTLE_AMOUNT_TYPE SETTLE_AMOUNT_TYPE, SETTLE_DATE SETTLE_DATE, SETTLE_DUAL_AUTHORISATION_BY SETTLE_DUAL_AUTHORISATION_BY, SETTLE_DUAL_AUTHORISATION_ON SETTLE_DUAL_AUTHORISATION_ON, SETTLE_HCE_AMOUNT SETTLE_HCE_AMOUNT, SETTLE_NO_OF_DAYS SETTLE_NO_OF_DAYS, SETTLE_RATE SETTLE_RATE, SPOT_RATE_ON_VALUATION SPOT_RATE_ON_VALUATION, START_ACCOUNT_NO START_ACCOUNT_NO, START_AMOUNT START_AMOUNT, START_DATE START_DATE, START_HCE_AMOUNT START_HCE_AMOUNT, STATUS_CODE STATUS_CODE, SWAP_DEPO_ADJUSTMENT SWAP_DEPO_ADJUSTMENT, SWAP_DEPO_FLAG SWAP_DEPO_FLAG, SWAP_DEPO_INT_RATE SWAP_DEPO_INT_RATE, SWAP_DEPO_TOTAL_RECEIPT SWAP_DEPO_TOTAL_RECEIPT, SWAP_REF SWAP_REF, SYNTHETIC_PRINTED_YN SYNTHETIC_PRINTED_YN, TAX_AMOUNT TAX_AMOUNT, TAX_AMOUNT_HCE TAX_AMOUNT_HCE, TAX_CODE TAX_CODE, TAX_RATE TAX_RATE, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE, TERM_MY TERM_MY, TOTAL_PRICE TOTAL_PRICE, TRANSACTION_CROSS_REF TRANSACTION_CROSS_REF, TRANSACTION_NO TRANSACTION_NO, TRANSACTION_RATE TRANSACTION_RATE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VALUE_DATE VALUE_DATE, YEAR_BASIS YEAR_BASIS, YEAR_CALC_TYPE YEAR_CALC_TYPE, YIELD_AMOUNT YIELD_AMOUNT, YIELD_HCE_AMOUNT YIELD_HCE_AMOUNT, SECURITY_ID SECURITY_ID, EXERCISE_PRICE EXERCISE_PRICE from "XTR"."XTR_R_DEALS"

View Text - HTML Formatted

SELECT ACCEPTOR_CODE ACCEPTOR_CODE
, ACCEPTOR_NAME ACCEPTOR_NAME
, ACCRUAL_FROM ACCRUAL_FROM
, ACCRUAL_TO ACCRUAL_TO
, ACCRUED_INTEREST_PRICE ACCRUED_INTEREST_PRICE
, ACTION_STATUS ACTION_STATUS
, ARCHIVE_BY ARCHIVE_BY
, ARCHIVE_DATE ARCHIVE_DATE
, ATTACHMENT_EXISTS ATTACHMENT_EXISTS
, AUDIT_INDICATOR AUDIT_INDICATOR
, BASE_DATE BASE_DATE
, BASE_RATE BASE_RATE
, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE
, BOND_ISSUE BOND_ISSUE
, BOND_PROFIT_LOSS BOND_PROFIT_LOSS
, BOND_RENEG_DATE BOND_RENEG_DATE
, BOND_RESALE_DATE BOND_RESALE_DATE
, BOND_SALE_DATE BOND_SALE_DATE
, BROKER BROKER
, BROKERAGE_AMOUNT BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE BROKERAGE_CODE
, BROKERAGE_CURRENCY BROKERAGE_CURRENCY
, BROKERAGE_RATE BROKERAGE_RATE
, BUY_ACCOUNT_NO BUY_ACCOUNT_NO
, BUY_AMOUNT BUY_AMOUNT
, BUY_HCE_AMOUNT BUY_HCE_AMOUNT
, CALC_BASIS CALC_BASIS
, CAPITAL_PRICE CAPITAL_PRICE
, CAP_OR_FLOOR CAP_OR_FLOOR
, CLIENT_ADVICE CLIENT_ADVICE
, CLIENT_CODE CLIENT_CODE
, CLIENT_REF CLIENT_REF
, COMMENCE_DATE COMMENCE_DATE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CONTRACT_COMMISSION CONTRACT_COMMISSION
, CONTRACT_FEES CONTRACT_FEES
, CONTRACT_NOS CONTRACT_NOS
, CONTRACT_RATE CONTRACT_RATE
, COUPON_ACTION COUPON_ACTION
, COUPON_RATE COUPON_RATE
, CPARTY_ADVICE CPARTY_ADVICE
, CPARTY_CODE CPARTY_CODE
, CPARTY_REF CPARTY_REF
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CTY_CCY CTY_CCY
, CUM_COUPON_DATE CUM_COUPON_DATE
, CURRENCY CURRENCY
, CURRENCY_BUY CURRENCY_BUY
, CURRENCY_SELL CURRENCY_SELL
, DEALER_CODE DEALER_CODE
, DEAL_DATE DEAL_DATE
, DEAL_LINKING_CODE DEAL_LINKING_CODE
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DISCOUNT DISCOUNT
, DRAWER_CODE DRAWER_CODE
, DRAWER_NAME DRAWER_NAME
, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON
, ENDORSER_CODE ENDORSER_CODE
, ENDORSER_NAME ENDORSER_NAME
, ENTER_INTO_SWAP ENTER_INTO_SWAP
, EXCHANGE_CODE EXCHANGE_CODE
, EXERCISE EXERCISE
, EXPIRY_DATE EXPIRY_DATE
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO
, FACE_VALUE_AMOUNT FACE_VALUE_AMOUNT
, FACE_VALUE_HCE_AMOUNT FACE_VALUE_HCE_AMOUNT
, FIRST_REVAL FIRST_REVAL
, FIXED_OR_FLOATING_RATE FIXED_OR_FLOATING_RATE
, FIXED_TERM_MY FIXED_TERM_MY
, FRA_DESCRIPTION FRA_DESCRIPTION
, FREQUENCY FREQUENCY
, FXD_DEAL_NO FXD_DEAL_NO
, FXO_DEAL_NO FXO_DEAL_NO
, FX_COVER_CROSS_REF FX_COVER_CROSS_REF
, FX_PD_DEAL_NO FX_PD_DEAL_NO
, FX_REVALUED_ON_DATE FX_REVALUED_ON_DATE
, FX_RO_DEAL_NO FX_RO_DEAL_NO
, FX_SUBSIDIARY_BALANCE_AMOUNT FX_SUBSIDIARY_BALANCE_AMOUNT
, FX_WHOLESALE_REF FX_WHOLESALE_REF
, INSERT_FOR_CASHFLOW INSERT_FOR_CASHFLOW
, FORWARD_HCE_AMOUNT FORWARD_HCE_AMOUNT
, INTEREST_AMOUNT INTEREST_AMOUNT
, INTEREST_CUTOFF INTEREST_CUTOFF
, INTEREST_HCE_AMOUNT INTEREST_HCE_AMOUNT
, INTEREST_RATE INTEREST_RATE
, INTERNAL_TICKET_NO INTERNAL_TICKET_NO
, INT_SWAP_REF INT_SWAP_REF
, KNOCK_EXECUTED_BY KNOCK_EXECUTED_BY
, KNOCK_EXECUTED_ON KNOCK_EXECUTED_ON
, KNOCK_INSERT_TYPE KNOCK_INSERT_TYPE
, KNOCK_LEVEL KNOCK_LEVEL
, KNOCK_TYPE KNOCK_TYPE
, LIMIT_AMOUNT LIMIT_AMOUNT
, LIMIT_CODE LIMIT_CODE
, MARGIN MARGIN
, MATURITY_ACCOUNT_NO MATURITY_ACCOUNT_NO
, MATURITY_AMOUNT MATURITY_AMOUNT
, MATURITY_BALANCE_AMOUNT MATURITY_BALANCE_AMOUNT
, MATURITY_BALANCE_HCE_AMOUNT MATURITY_BALANCE_HCE_AMOUNT
, MATURITY_DATE MATURITY_DATE
, MATURITY_HCE_AMOUNT MATURITY_HCE_AMOUNT
, NEXT_COUPON_DATE NEXT_COUPON_DATE
, NI_DEAL_NO NI_DEAL_NO
, NI_PROFIT_LOSS NI_PROFIT_LOSS
, NO_OF_DAYS NO_OF_DAYS
, OPTION_AMOUNT OPTION_AMOUNT
, OPTION_COMMENCEMENT OPTION_COMMENCEMENT
, OPTION_HCE_AMOUNT OPTION_HCE_AMOUNT
, OPTION_POINTS OPTION_POINTS
, OPTION_TYPE OPTION_TYPE
, PAYMENT_FREQ PAYMENT_FREQ
, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE
, PI_AMOUNT_DUE PI_AMOUNT_DUE
, PORTFOLIO_AMOUNT PORTFOLIO_AMOUNT
, PORTFOLIO_CODE PORTFOLIO_CODE
, PREMIUM_ACCOUNT_NO PREMIUM_ACCOUNT_NO
, PREMIUM_ACTION PREMIUM_ACTION
, PREMIUM_AMOUNT PREMIUM_AMOUNT
, PREMIUM_AMOUNT_TYPE PREMIUM_AMOUNT_TYPE
, PREMIUM_CURRENCY PREMIUM_CURRENCY
, PREMIUM_DATE PREMIUM_DATE
, PREMIUM_HCE_AMOUNT PREMIUM_HCE_AMOUNT
, PREMIUM_NO_OF_DAYS PREMIUM_NO_OF_DAYS
, PRINCIPAL_SETTLED_BY PRINCIPAL_SETTLED_BY
, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE
, PRINTED_YN PRINTED_YN
, PRODUCT_TYPE PRODUCT_TYPE
, QUICK_INPUT QUICK_INPUT
, RATE_BASIS RATE_BASIS
, REF_CCY REF_CCY
, RENEG_DATE RENEG_DATE
, RISKPARTY_CODE RISKPARTY_CODE
, RISKPARTY_LIMIT_CODE RISKPARTY_LIMIT_CODE
, SECURITY_NAME SECURITY_NAME
, SELL_ACCOUNT_NO SELL_ACCOUNT_NO
, SELL_AMOUNT SELL_AMOUNT
, SELL_HCE_AMOUNT SELL_HCE_AMOUNT
, SETTLE_ACCOUNT_NO SETTLE_ACCOUNT_NO
, SETTLE_ACTION SETTLE_ACTION
, SETTLE_AMOUNT SETTLE_AMOUNT
, SETTLE_AMOUNT_TYPE SETTLE_AMOUNT_TYPE
, SETTLE_DATE SETTLE_DATE
, SETTLE_DUAL_AUTHORISATION_BY SETTLE_DUAL_AUTHORISATION_BY
, SETTLE_DUAL_AUTHORISATION_ON SETTLE_DUAL_AUTHORISATION_ON
, SETTLE_HCE_AMOUNT SETTLE_HCE_AMOUNT
, SETTLE_NO_OF_DAYS SETTLE_NO_OF_DAYS
, SETTLE_RATE SETTLE_RATE
, SPOT_RATE_ON_VALUATION SPOT_RATE_ON_VALUATION
, START_ACCOUNT_NO START_ACCOUNT_NO
, START_AMOUNT START_AMOUNT
, START_DATE START_DATE
, START_HCE_AMOUNT START_HCE_AMOUNT
, STATUS_CODE STATUS_CODE
, SWAP_DEPO_ADJUSTMENT SWAP_DEPO_ADJUSTMENT
, SWAP_DEPO_FLAG SWAP_DEPO_FLAG
, SWAP_DEPO_INT_RATE SWAP_DEPO_INT_RATE
, SWAP_DEPO_TOTAL_RECEIPT SWAP_DEPO_TOTAL_RECEIPT
, SWAP_REF SWAP_REF
, SYNTHETIC_PRINTED_YN SYNTHETIC_PRINTED_YN
, TAX_AMOUNT TAX_AMOUNT
, TAX_AMOUNT_HCE TAX_AMOUNT_HCE
, TAX_CODE TAX_CODE
, TAX_RATE TAX_RATE
, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE
, TERM_MY TERM_MY
, TOTAL_PRICE TOTAL_PRICE
, TRANSACTION_CROSS_REF TRANSACTION_CROSS_REF
, TRANSACTION_NO TRANSACTION_NO
, TRANSACTION_RATE TRANSACTION_RATE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VALUE_DATE VALUE_DATE
, YEAR_BASIS YEAR_BASIS
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, YIELD_AMOUNT YIELD_AMOUNT
, YIELD_HCE_AMOUNT YIELD_HCE_AMOUNT
, SECURITY_ID SECURITY_ID
, EXERCISE_PRICE EXERCISE_PRICE
FROM "XTR"."XTR_R_DEALS"