VIEW: APPS.XTR_DEALS_V

Source

View Text - Preformatted

SELECT xd.ACCEPTOR_CODE , xd.ACCEPTOR_NAME , xd.ACCRUAL_FROM , xd.ACCRUAL_TO , xd.ACCRUED_INTEREST_PRICE , xd.ACTION_STATUS , xd.ARCHIVE_BY , xd.ARCHIVE_DATE , xd.ATTACHMENT_EXISTS , xd.AUDIT_INDICATOR , xd.BASE_DATE , xd.BASE_RATE , xd.BKGE_SETTLED_REFERENCE , xd.BOND_ISSUE , xd.BOND_PROFIT_LOSS , xd.BOND_RENEG_DATE , xd.BOND_RESALE_DATE , xd.BOND_SALE_DATE , xd.BROKER , xd.BROKERAGE_AMOUNT , xd.BROKERAGE_AMOUNT_HCE , xd.BROKERAGE_CODE , xd.BROKERAGE_CURRENCY , xd.BROKERAGE_RATE , xd.BUY_ACCOUNT_NO , xd.BUY_AMOUNT , xd.BUY_HCE_AMOUNT , xd.CALC_BASIS , xd.CAPITAL_PRICE , xd.CAP_OR_FLOOR , xd.CLIENT_ADVICE , xd.CLIENT_CODE , xd.CLIENT_REF , xd.COMMENCE_DATE , xd.COMMENTS , xd.COMPANY_CODE , xd.CONTRACT_COMMISSION , xd.CONTRACT_FEES , xd.CONTRACT_NOS , xd.CONTRACT_RATE , xd.COUPON_ACTION , xd.COUPON_RATE , xd.CPARTY_ADVICE , xd.CPARTY_CODE , xd.CPARTY_REF , xd.CREATED_BY , xd.CREATED_ON , xd.CTY_CCY , xd.CUM_COUPON_DATE , xd.CURRENCY , xd.CURRENCY_BUY , xd.CURRENCY_SELL , xd.DEALER_CODE , xd.DEAL_DATE , xd.DEAL_LINKING_CODE , xd.DEAL_NO , xd.DEAL_SUBTYPE , xd.DEAL_TYPE , xd.DISCOUNT , xd.DRAWER_CODE , xd.DRAWER_NAME , xd.DUAL_AUTHORISATION_BY , xd.DUAL_AUTHORISATION_ON , xd.ENDORSER_CODE , xd.ENDORSER_NAME , xd.ENTER_INTO_SWAP , xd.EXCHANGE_CODE , xd.EXERCISE ,xd.EXPIRY_DATE , xd.EXTERNAL_COMMENTS , xd.EXTERNAL_CPARTY_NO , xd.FACE_VALUE_AMOUNT , xd.FACE_VALUE_HCE_AMOUNT , xd.FIRST_REVAL , xd.FIXED_OR_FLOATING_RATE , xd.FIXED_TERM_MY , xd.FORWARD_HCE_AMOUNT , xd.FRA_DESCRIPTION , xd.FREQUENCY , xd.FXD_DEAL_NO , xd.FXO_DEAL_NO , xd.FX_COVER_CROSS_REF , xd.FX_PD_DEAL_NO , xd.FX_REVALUED_ON_DATE , xd.FX_RO_DEAL_NO , xd.FX_SUBSIDIARY_BALANCE_AMOUNT , xd.FX_WHOLESALE_REF , xd.INSERT_FOR_CASHFLOW , xd.INTEREST_AMOUNT , xd.INTEREST_CUTOFF, xd.INTEREST_HCE_AMOUNT , xd.INTEREST_RATE , xd.INTERNAL_TICKET_NO , xd.INT_SWAP_REF , xd.KNOCK_EXECUTED_BY , xd.KNOCK_EXECUTED_ON , xd.KNOCK_INSERT_TYPE , xd.KNOCK_LEVEL , xd.KNOCK_TYPE , xd.LIMIT_AMOUNT , xd.LIMIT_CODE , xd.MARGIN , xd.MATURITY_ACCOUNT_NO , xd.MATURITY_AMOUNT , xd.MATURITY_BALANCE_AMOUNT , xd.MATURITY_BALANCE_HCE_AMOUNT , xd.MATURITY_DATE , xd.MATURITY_HCE_AMOUNT , xd.NEXT_COUPON_DATE , xd.NI_DEAL_NO , xd.NI_PROFIT_LOSS , xd.NO_OF_DAYS , xd.OPTION_AMOUNT , xd.OPTION_COMMENCEMENT , xd.OPTION_HCE_AMOUNT , xd.OPTION_POINTS , xd.OPTION_TYPE , xd.PAYMENT_FREQ , xd.PAYMENT_SCHEDULE_CODE , xd.PI_AMOUNT_DUE , xd.PORTFOLIO_AMOUNT , xd.PORTFOLIO_CODE , xd.PREMIUM_ACCOUNT_NO , xd.PREMIUM_ACTION , xd.PREMIUM_AMOUNT , xd.PREMIUM_AMOUNT_TYPE , xd.PREMIUM_CURRENCY , xd.PREMIUM_DATE ,xd.PREMIUM_HCE_AMOUNT , xd.PREMIUM_NO_OF_DAYS , xd.PRINCIPAL_SETTLED_BY , xd.PRINTED_CPARTY_ADVICE , xd.PRINTED_YN , xd.PRODUCT_TYPE , xd.QUANTITY, xd.QUICK_INPUT , xd.RATE_BASIS , xd.REF_CCY , xd.REMAINING_QUANTITY, xd.RENEG_DATE , xd.RISKPARTY_CODE , xd.RISKPARTY_LIMIT_CODE , xd.SECURITY_NAME , xd.SELL_ACCOUNT_NO , xd.SELL_AMOUNT , xd.SELL_HCE_AMOUNT , xd.SETTLE_ACCOUNT_NO, xd.SETTLE_ACTION , xd.SETTLE_AMOUNT , xd.SETTLE_AMOUNT_TYPE , xd.SETTLE_DATE , xd.SETTLE_DUAL_AUTHORISATION_BY , xd.SETTLE_DUAL_AUTHORISATION_ON , xd.SETTLE_HCE_AMOUNT , xd.SETTLE_NO_OF_DAYS , xd.SETTLE_RATE , xd.SPOT_RATE_ON_VALUATION , xd.START_ACCOUNT_NO , xd.START_AMOUNT , xd.START_DATE , xd.START_HCE_AMOUNT , xd.STATUS_CODE , xd.SWAP_DEPO_ADJUSTMENT , xd.SWAP_DEPO_FLAG , xd.SWAP_DEPO_INT_RATE , xd.SWAP_DEPO_TOTAL_RECEIPT , xd.SWAP_REF , xd.SYNTHETIC_PRINTED_YN , xd.TAX_AMOUNT , xd.TAX_AMOUNT_HCE , xd.TAX_CODE , xd.TAX_RATE ,xd.TAX_SETTLED_REFERENCE , xd.INCOME_TAX_CODE, xd.INCOME_TAX_RATE, xd.TERM_MY , xd.TOTAL_PRICE , xd.TRANSACTION_CROSS_REF , xd.TRANSACTION_NO , xd.TRANSACTION_RATE , xd.UPDATED_BY , xd.UPDATED_ON , xd.VALUE_DATE , xd.YEAR_BASIS , xd.YEAR_CALC_TYPE , xd.YIELD_AMOUNT , xd.YIELD_HCE_AMOUNT , xd.RATE_FIXING_DATE , xd.SECURITY_ID , xd.EXERCISE_PRICE, xd.PRICING_MODEL, xd.MARKET_DATA_SET, xd.INITIAL_FAIR_VALUE, xd.EXCHANGE_RATE_ONE, xd.EXCHANGE_RATE_TWO, xd.FIRST_REVAL_BATCH_ID, xd.LAST_REVAL_BATCH_ID, xd.EXTERNAL_DEAL_ID, xd.REQUEST_ID, xd.PROGRAM_APPLICATION_ID, xd.PROGRAM_ID, xd.PROGRAM_UPDATE_DATE, xd.ATTRIBUTE_CATEGORY, xd.ATTRIBUTE1, xd.ATTRIBUTE2, xd.ATTRIBUTE3, xd.ATTRIBUTE4, xd.ATTRIBUTE5, xd.ATTRIBUTE6, xd.ATTRIBUTE7, xd.ATTRIBUTE8, xd.ATTRIBUTE9, xd.ATTRIBUTE10, xd.ATTRIBUTE11, xd.ATTRIBUTE12, xd.ATTRIBUTE13, xd.ATTRIBUTE14, xd.ATTRIBUTE15 ,xd.KNOCK_EXECUTE_DATE,xd.PROFIT_LOSS,xd.FX_RO_PD_RATE, xd.FX_M1_Deal_No, xd.Force_Month_End,xd.ROUNDING_TYPE,xd.DAY_COUNT_TYPE, xd.SETTLE_ROUNDING_TYPE,xd.SETTLE_DAY_COUNT_TYPE,xd.ORIGINAL_AMOUNT,xd.PREPAID_INTEREST, xd.INCOME_TAX_AMOUNT, xd.INCOME_TAX_SETTLED_REF, xd.CPARTY_ACCOUNT_NO, xd.CLIENT_ACCOUNT_NO, xd.MATURE_SETTLEMENT_BASIS, xd.PAYMENT_SETTLEMENT_BASIS FROM XTR_DEALS xd WHERE company_code IN (SELECT xca.party_code FROM XTR_COMPANY_AUTHORITIES xca WHERE xca.DEALER_CODE = xtr_user_access.dealer_code AND xca.COMPANY_AUTHORISED_FOR_INPUT = 'Y' )

View Text - HTML Formatted

SELECT XD.ACCEPTOR_CODE
, XD.ACCEPTOR_NAME
, XD.ACCRUAL_FROM
, XD.ACCRUAL_TO
, XD.ACCRUED_INTEREST_PRICE
, XD.ACTION_STATUS
, XD.ARCHIVE_BY
, XD.ARCHIVE_DATE
, XD.ATTACHMENT_EXISTS
, XD.AUDIT_INDICATOR
, XD.BASE_DATE
, XD.BASE_RATE
, XD.BKGE_SETTLED_REFERENCE
, XD.BOND_ISSUE
, XD.BOND_PROFIT_LOSS
, XD.BOND_RENEG_DATE
, XD.BOND_RESALE_DATE
, XD.BOND_SALE_DATE
, XD.BROKER
, XD.BROKERAGE_AMOUNT
, XD.BROKERAGE_AMOUNT_HCE
, XD.BROKERAGE_CODE
, XD.BROKERAGE_CURRENCY
, XD.BROKERAGE_RATE
, XD.BUY_ACCOUNT_NO
, XD.BUY_AMOUNT
, XD.BUY_HCE_AMOUNT
, XD.CALC_BASIS
, XD.CAPITAL_PRICE
, XD.CAP_OR_FLOOR
, XD.CLIENT_ADVICE
, XD.CLIENT_CODE
, XD.CLIENT_REF
, XD.COMMENCE_DATE
, XD.COMMENTS
, XD.COMPANY_CODE
, XD.CONTRACT_COMMISSION
, XD.CONTRACT_FEES
, XD.CONTRACT_NOS
, XD.CONTRACT_RATE
, XD.COUPON_ACTION
, XD.COUPON_RATE
, XD.CPARTY_ADVICE
, XD.CPARTY_CODE
, XD.CPARTY_REF
, XD.CREATED_BY
, XD.CREATED_ON
, XD.CTY_CCY
, XD.CUM_COUPON_DATE
, XD.CURRENCY
, XD.CURRENCY_BUY
, XD.CURRENCY_SELL
, XD.DEALER_CODE
, XD.DEAL_DATE
, XD.DEAL_LINKING_CODE
, XD.DEAL_NO
, XD.DEAL_SUBTYPE
, XD.DEAL_TYPE
, XD.DISCOUNT
, XD.DRAWER_CODE
, XD.DRAWER_NAME
, XD.DUAL_AUTHORISATION_BY
, XD.DUAL_AUTHORISATION_ON
, XD.ENDORSER_CODE
, XD.ENDORSER_NAME
, XD.ENTER_INTO_SWAP
, XD.EXCHANGE_CODE
, XD.EXERCISE
, XD.EXPIRY_DATE
, XD.EXTERNAL_COMMENTS
, XD.EXTERNAL_CPARTY_NO
, XD.FACE_VALUE_AMOUNT
, XD.FACE_VALUE_HCE_AMOUNT
, XD.FIRST_REVAL
, XD.FIXED_OR_FLOATING_RATE
, XD.FIXED_TERM_MY
, XD.FORWARD_HCE_AMOUNT
, XD.FRA_DESCRIPTION
, XD.FREQUENCY
, XD.FXD_DEAL_NO
, XD.FXO_DEAL_NO
, XD.FX_COVER_CROSS_REF
, XD.FX_PD_DEAL_NO
, XD.FX_REVALUED_ON_DATE
, XD.FX_RO_DEAL_NO
, XD.FX_SUBSIDIARY_BALANCE_AMOUNT
, XD.FX_WHOLESALE_REF
, XD.INSERT_FOR_CASHFLOW
, XD.INTEREST_AMOUNT
, XD.INTEREST_CUTOFF
, XD.INTEREST_HCE_AMOUNT
, XD.INTEREST_RATE
, XD.INTERNAL_TICKET_NO
, XD.INT_SWAP_REF
, XD.KNOCK_EXECUTED_BY
, XD.KNOCK_EXECUTED_ON
, XD.KNOCK_INSERT_TYPE
, XD.KNOCK_LEVEL
, XD.KNOCK_TYPE
, XD.LIMIT_AMOUNT
, XD.LIMIT_CODE
, XD.MARGIN
, XD.MATURITY_ACCOUNT_NO
, XD.MATURITY_AMOUNT
, XD.MATURITY_BALANCE_AMOUNT
, XD.MATURITY_BALANCE_HCE_AMOUNT
, XD.MATURITY_DATE
, XD.MATURITY_HCE_AMOUNT
, XD.NEXT_COUPON_DATE
, XD.NI_DEAL_NO
, XD.NI_PROFIT_LOSS
, XD.NO_OF_DAYS
, XD.OPTION_AMOUNT
, XD.OPTION_COMMENCEMENT
, XD.OPTION_HCE_AMOUNT
, XD.OPTION_POINTS
, XD.OPTION_TYPE
, XD.PAYMENT_FREQ
, XD.PAYMENT_SCHEDULE_CODE
, XD.PI_AMOUNT_DUE
, XD.PORTFOLIO_AMOUNT
, XD.PORTFOLIO_CODE
, XD.PREMIUM_ACCOUNT_NO
, XD.PREMIUM_ACTION
, XD.PREMIUM_AMOUNT
, XD.PREMIUM_AMOUNT_TYPE
, XD.PREMIUM_CURRENCY
, XD.PREMIUM_DATE
, XD.PREMIUM_HCE_AMOUNT
, XD.PREMIUM_NO_OF_DAYS
, XD.PRINCIPAL_SETTLED_BY
, XD.PRINTED_CPARTY_ADVICE
, XD.PRINTED_YN
, XD.PRODUCT_TYPE
, XD.QUANTITY
, XD.QUICK_INPUT
, XD.RATE_BASIS
, XD.REF_CCY
, XD.REMAINING_QUANTITY
, XD.RENEG_DATE
, XD.RISKPARTY_CODE
, XD.RISKPARTY_LIMIT_CODE
, XD.SECURITY_NAME
, XD.SELL_ACCOUNT_NO
, XD.SELL_AMOUNT
, XD.SELL_HCE_AMOUNT
, XD.SETTLE_ACCOUNT_NO
, XD.SETTLE_ACTION
, XD.SETTLE_AMOUNT
, XD.SETTLE_AMOUNT_TYPE
, XD.SETTLE_DATE
, XD.SETTLE_DUAL_AUTHORISATION_BY
, XD.SETTLE_DUAL_AUTHORISATION_ON
, XD.SETTLE_HCE_AMOUNT
, XD.SETTLE_NO_OF_DAYS
, XD.SETTLE_RATE
, XD.SPOT_RATE_ON_VALUATION
, XD.START_ACCOUNT_NO
, XD.START_AMOUNT
, XD.START_DATE
, XD.START_HCE_AMOUNT
, XD.STATUS_CODE
, XD.SWAP_DEPO_ADJUSTMENT
, XD.SWAP_DEPO_FLAG
, XD.SWAP_DEPO_INT_RATE
, XD.SWAP_DEPO_TOTAL_RECEIPT
, XD.SWAP_REF
, XD.SYNTHETIC_PRINTED_YN
, XD.TAX_AMOUNT
, XD.TAX_AMOUNT_HCE
, XD.TAX_CODE
, XD.TAX_RATE
, XD.TAX_SETTLED_REFERENCE
, XD.INCOME_TAX_CODE
, XD.INCOME_TAX_RATE
, XD.TERM_MY
, XD.TOTAL_PRICE
, XD.TRANSACTION_CROSS_REF
, XD.TRANSACTION_NO
, XD.TRANSACTION_RATE
, XD.UPDATED_BY
, XD.UPDATED_ON
, XD.VALUE_DATE
, XD.YEAR_BASIS
, XD.YEAR_CALC_TYPE
, XD.YIELD_AMOUNT
, XD.YIELD_HCE_AMOUNT
, XD.RATE_FIXING_DATE
, XD.SECURITY_ID
, XD.EXERCISE_PRICE
, XD.PRICING_MODEL
, XD.MARKET_DATA_SET
, XD.INITIAL_FAIR_VALUE
, XD.EXCHANGE_RATE_ONE
, XD.EXCHANGE_RATE_TWO
, XD.FIRST_REVAL_BATCH_ID
, XD.LAST_REVAL_BATCH_ID
, XD.EXTERNAL_DEAL_ID
, XD.REQUEST_ID
, XD.PROGRAM_APPLICATION_ID
, XD.PROGRAM_ID
, XD.PROGRAM_UPDATE_DATE
, XD.ATTRIBUTE_CATEGORY
, XD.ATTRIBUTE1
, XD.ATTRIBUTE2
, XD.ATTRIBUTE3
, XD.ATTRIBUTE4
, XD.ATTRIBUTE5
, XD.ATTRIBUTE6
, XD.ATTRIBUTE7
, XD.ATTRIBUTE8
, XD.ATTRIBUTE9
, XD.ATTRIBUTE10
, XD.ATTRIBUTE11
, XD.ATTRIBUTE12
, XD.ATTRIBUTE13
, XD.ATTRIBUTE14
, XD.ATTRIBUTE15
, XD.KNOCK_EXECUTE_DATE
, XD.PROFIT_LOSS
, XD.FX_RO_PD_RATE
, XD.FX_M1_DEAL_NO
, XD.FORCE_MONTH_END
, XD.ROUNDING_TYPE
, XD.DAY_COUNT_TYPE
, XD.SETTLE_ROUNDING_TYPE
, XD.SETTLE_DAY_COUNT_TYPE
, XD.ORIGINAL_AMOUNT
, XD.PREPAID_INTEREST
, XD.INCOME_TAX_AMOUNT
, XD.INCOME_TAX_SETTLED_REF
, XD.CPARTY_ACCOUNT_NO
, XD.CLIENT_ACCOUNT_NO
, XD.MATURE_SETTLEMENT_BASIS
, XD.PAYMENT_SETTLEMENT_BASIS
FROM XTR_DEALS XD
WHERE COMPANY_CODE IN (SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
WHERE XCA.DEALER_CODE = XTR_USER_ACCESS.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' )