[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_R_DEALS_V

Object Details

Object Name:	XTR_R_DEALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_R_DEALS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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 APPS.XTR_R_DEALS_V;

Dependencies

[top of page]

APPS

XTR_R_DEALS

APPS.XTR_R_DEALS_V is not referenced by any database object