[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_A_ALL_CONTRACTS_V

Object Details

Object Name:	XTR_A_ALL_CONTRACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_A_ALL_CONTRACTS_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 CONTRACT_NO
,      ROLLOVER_TRANSACTION_NO
,      COMPANY
,      COUNTERPARTY
,      CLIENT
,      ACCEPTOR
,      ENDORSER
,      DRAWER
,      CONTRACT_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT
,      PORTFOLIO
,      CURRENCY
,      CURRENCY_SELL
,      CONTRACT_DEALT_ON
,      COMMENCE_DATE
,      MATURITY_DATE
,      SETTLEMENT_DATE
,      PREMIUM_DATE
,      OPTION_EXPIRY
,      AMOUNT
,      SELL_AMOUNT
,      CONSIDERATION_AMOUNT
,      SETTLEMENT_AMOUNT
,      PREMIUM_AMOUNT
,      BROKER_AMOUNT
,      TAX_AMOUNT
,      CONTRACT_RATE
,      COUPON_RATE
,      BROKER_RATE
,      TAX_RATE
,      SETTLEMENT_RATE
,      UPDATED_ON_DATE
,      UPDATED_BY_USER
,      COMPANY_DEALER
,      COMPANY_SETTLEMENT_ACCT
,      COUNTERPARTY_ACCT_REF
,      PREMIUM_ACCT
,      FX_BUY_SETTLEMENT_ACCT
,      FX_SELL_SETTLEMENT_ACCT
,      SETTLEMENT_ACCT
,      CONTRACT_STATUS
,      USER_STATUS_CODE
,      LIMIT_CODE
,      FIXED_FLOAT_BASIS
,      CONTRACT_LINK_CODE
,      BROKER_CODE
,      TAX_CODE
,      PAY_REC_SETTLEMENT
,      PAY_REC_PREMIUM
,      COMMENTS
,      AUDIT_DATE_STORED
,      ORDERING_COLUMN
,      CREATED_BY_USER
,      CREATED_ON_DATE
,      PRICING_MODEL
,      MARKET_DATA_SET
,      DAY_COUNT_TYPE
,      ROUNDING_TYPE
,      SETTLE_DAY_COUNT_TYPE
,      SETTLE_ROUNDING_TYPE
FROM APPS.XTR_A_ALL_CONTRACTS_V;

Dependencies

[top of page]

APPS

XTR_A_DEALS

XTR_A_ROLLOVER_TRANSACTIONS

XTR_DEALS_V

XTR_DEAL_STATUSES

XTR_DEAL_SUBTYPES

XTR_ROLLOVER_TRANSACTIONS_V

XTR_USER_ACCESS - show dependent code

APPS.XTR_A_ALL_CONTRACTS_V is not referenced by any database object