VIEW: APPS.XTR_R_DEALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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