[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_REVIEW_ALL_CONTRACTS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[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_TYPE
,      USER_DEAL_TYPE
,      CONTRACT_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT
,      PORTFOLIO
,      CURRENCY
,      CURRENCY_SELL
,      CONTRACT_DEALT_ON
,      AUTHORISED_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
,      ENTERED_INTO_SYSTEM_ON
,      ENTERED_INTO_SYSTEM_BY
,      COMPANY_DEALER
,      AUTHORISED_BY
,      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
,      LETTER_PRINTED_YN
,      BROKER_CODE
,      TAX_CODE
,      PAY_REC_SETTLEMENT
,      PAY_REC_PREMIUM
,      ROLLED_FROM_FX_CONTRACT
,      PREDELIVERED_FROM_FX_CONTRACT
,      COMMENTS
,      ACTION_STATUS
,      CONTRACT_TYPE_NAME
,      ISSUE_CODE
,      PRICE
,      QUANTITY
,      INCOME_TAX_CODE
,      INCOME_TAX_RATE
,      INCOME_TAX_AMOUNT
,      INTEREST_DUE_ON
,      MATURE_SETTLEMENT_BASIS
,      PAYMENT_SETTLEMENT_BASIS
,      CPARTY_ACCOUNT_NO
,      ACTION
FROM APPS.XTR_REVIEW_ALL_CONTRACTS_V;

Dependencies

[top of page]

APPS

XTR_BANK_ACCOUNTS

XTR_DEALS_V

XTR_DEAL_STATUSES

XTR_DEAL_SUBTYPES

XTR_DEAL_TYPES

XTR_EXPOSURE_TRANSACTIONS_V

XTR_INTERACCT_TRANSFERS

XTR_ROLLOVER_TRANSACTIONS_V

XTR_USER_ACCESS - show dependent code

APPS

XTR_TRANS_VALIDATIONS_V