View: XTR_DEALS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_DEALS_V

View Text

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' )

Columns