eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length
CONTRACT_NO	NUMBER
ROLLOVER_TRANSACTION_NO	NUMBER
COMPANY	VARCHAR2	(7)
COUNTERPARTY	VARCHAR2	(7)
CLIENT	VARCHAR2	(7)
ACCEPTOR	VARCHAR2	(20)
ENDORSER	VARCHAR2	(20)
DRAWER	VARCHAR2	(20)
CONTRACT_TYPE	VARCHAR2	(7)
USER_DEAL_TYPE	VARCHAR2	(7)
CONTRACT_SUBTYPE	VARCHAR2	(7)
USER_DEAL_SUBTYPE	VARCHAR2	(7)
PRODUCT	VARCHAR2	(10)
PORTFOLIO	VARCHAR2	(10)
CURRENCY	VARCHAR2	(15)
CURRENCY_SELL	VARCHAR2	(15)
CONTRACT_DEALT_ON	DATE
AUTHORISED_ON	DATE
COMMENCE_DATE	DATE
MATURITY_DATE	DATE
SETTLEMENT_DATE	DATE
PREMIUM_DATE	DATE
OPTION_EXPIRY	DATE
AMOUNT	NUMBER
SELL_AMOUNT	NUMBER
CONSIDERATION_AMOUNT	NUMBER
SETTLEMENT_AMOUNT	NUMBER
PREMIUM_AMOUNT	NUMBER
BROKER_AMOUNT	NUMBER
TAX_AMOUNT	NUMBER
CONTRACT_RATE	NUMBER
COUPON_RATE	NUMBER
BROKER_RATE	NUMBER
TAX_RATE	NUMBER
SETTLEMENT_RATE	NUMBER
ENTERED_INTO_SYSTEM_ON	DATE
ENTERED_INTO_SYSTEM_BY	VARCHAR2	(30)
COMPANY_DEALER	VARCHAR2	(10)
AUTHORISED_BY	VARCHAR2	(30)
COMPANY_SETTLEMENT_ACCT	VARCHAR2	(20)
COUNTERPARTY_ACCT_REF	VARCHAR2	(80)
PREMIUM_ACCT	VARCHAR2	(20)
FX_BUY_SETTLEMENT_ACCT	VARCHAR2	(20)
FX_SELL_SETTLEMENT_ACCT	VARCHAR2	(20)
SETTLEMENT_ACCT	VARCHAR2	(20)
CONTRACT_STATUS	VARCHAR2	(10)
USER_STATUS_CODE	VARCHAR2	(10)
LIMIT_CODE	VARCHAR2	(7)
FIXED_FLOAT_BASIS	VARCHAR2	(5)
CONTRACT_LINK_CODE	VARCHAR2	(8)
LETTER_PRINTED_YN	VARCHAR2	(1)
BROKER_CODE	VARCHAR2	(7)
TAX_CODE	VARCHAR2	(7)
PAY_REC_SETTLEMENT	VARCHAR2	(7)
PAY_REC_PREMIUM	VARCHAR2	(7)
ROLLED_FROM_FX_CONTRACT	NUMBER
PREDELIVERED_FROM_FX_CONTRACT	NUMBER
COMMENTS	VARCHAR2	(255)
ACTION_STATUS	VARCHAR2	(20)
CONTRACT_TYPE_NAME	VARCHAR2	(80)
ISSUE_CODE	VARCHAR2	(30)
PRICE	NUMBER
QUANTITY	NUMBER
INCOME_TAX_CODE	VARCHAR2	(7)
INCOME_TAX_RATE	NUMBER
INCOME_TAX_AMOUNT	NUMBER
INTEREST_DUE_ON	DATE
MATURE_SETTLEMENT_BASIS	VARCHAR2	(2)
PAYMENT_SETTLEMENT_BASIS	VARCHAR2	(2)
CPARTY_ACCOUNT_NO	VARCHAR2	(20)
ACTION	VARCHAR2	(7)

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_REVIEW_ALL_CONTRACTS_V references the following:

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_REVIEW_ALL_CONTRACTS_V is referenced by following:

APPS: XTR_TRANS_VALIDATIONS_V