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_EXPOSURE_TRANSACTIONS_V

Object Details

Object Name:	XTR_EXPOSURE_TRANSACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_EXPOSURE_TRANSACTIONS_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	Mandatory	Comments
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
EXPOSURE_TYPE	VARCHAR2	(10)	Yes	User-defined exposure type code
CURRENCY	VARCHAR2	(15)	Yes	Currency code
VALUE_DATE	DATE			Actual date of settlement
AMOUNT	NUMBER			Actual exposure amount
SETTLE_ACTION_REQD	VARCHAR2	(1)	Yes	Y or N indicates if exposure cashflow was created for settlement
AMOUNT_HCE	NUMBER		Yes	Exposure amount in reporting currency equivalent
CREATED_BY	VARCHAR2	(30)	Yes	User who created the exposure
CREATED_ON	DATE		Yes	Date on which the exposure was generated
UPDATED_BY	VARCHAR2	(30)		User who last updated the exposure transaction
UPDATED_ON	DATE			Date on which the exposure transaction was updated
THIRDPARTY_CODE	VARCHAR2	(7)		Settlement counterparty
ACTION_CODE	VARCHAR2	(7)		Code for actions involved in executing deals
AMOUNT_TYPE	VARCHAR2	(7)		Code that identifies the purpose of the amounts for an exposure type
ACCOUNT_NO	VARCHAR2	(20)		Settlement account number
COMMENTS	VARCHAR2	(255)		Comments
CPARTY_REF	VARCHAR2	(7)		Counterparty account reference code
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
TAX_BROKERAGE_TYPE	VARCHAR2	(1)		Not currently used
ARCHIVE_DATE	DATE			Not currently used
ARCHIVE_BY	VARCHAR2	(30)		Not currently used
PURCHASING_MODULE	VARCHAR2	(1)		Not currently used
BENEFICIARY_CODE	VARCHAR2	(7)		Not currently used
NZD_AMOUNT	NUMBER			Not currently used
FIS_FOB	VARCHAR2	(3)		Not currently used
SUBSIDIARY_REF	VARCHAR2	(10)		Not currently used
INTERMEDIARY_BANK_DETAILS	VARCHAR2	(62)		Not currently used
DEAL_STATUS	VARCHAR2	(1)		Code for the execution status of deals and transactions
WHOLESALE_REFERENCE	NUMBER			Not currently used
SELECT_REFERENCE	NUMBER			Not currently used
PROFIT_LOSS	NUMBER			Not currently used
SELECT_ACTION	VARCHAR2	(1)		Not currently used
PAYMENT_AMOUNT	NUMBER			Not currently used
BALANCE	NUMBER			Not currently used
AVG_RATE	NUMBER			Currency exchange rate
CONTRA_NZD_AMOUNT	NUMBER			Not currently used
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
PAYMENT_STATUS	VARCHAR2	(1)		Not currently used
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
ESTIMATE_DATE	DATE			Estimated exposure date
ESTIMATE_AMOUNT	NUMBER			Estimated exposure amount
COVERED_BY_FX_CONTRACT	NUMBER			Reference to foreign exchange deal number
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		For Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
EXTERNAL_COMMENTS	VARCHAR2	(255)		External Comments corresponding to an exposure transaction.
INTERNAL_COMMENTS	VARCHAR2	(255)		Internal Comments corresponding to an exposure transaction.
DEAL_LINK_CODE	VARCHAR2	(8)		Deal Linking Code corresponding to an exposure transaction.
CPARTY_ACCOUNT_NO	VARCHAR2	(20)		Counterparty bank account number
DUAL_AUTHORISATION_BY	VARCHAR2	(30)		Login name of the user who created the deal (applies only if the Treasury DUAL_AUTHORISE system parameter is set to Y)
DUAL_AUTHORISATION_ON	DATE			Date that the user created the deal (applies only if the Treasury DUAL_AUTHORISE system parameter is set to Y)
CASH_POSITION_EXPOSURE	VARCHAR2	(1)		Y or N indicates if the exposure transation was generated through cash positioning

Query Text

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


SELECT TRANSACTION_NUMBER
,      COMPANY_CODE
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      EXPOSURE_TYPE
,      CURRENCY
,      VALUE_DATE
,      AMOUNT
,      SETTLE_ACTION_REQD
,      AMOUNT_HCE
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      THIRDPARTY_CODE
,      ACTION_CODE
,      AMOUNT_TYPE
,      ACCOUNT_NO
,      COMMENTS
,      CPARTY_REF
,      PORTFOLIO_CODE
,      TAX_BROKERAGE_TYPE
,      ARCHIVE_DATE
,      ARCHIVE_BY
,      PURCHASING_MODULE
,      BENEFICIARY_CODE
,      NZD_AMOUNT
,      FIS_FOB
,      SUBSIDIARY_REF
,      INTERMEDIARY_BANK_DETAILS
,      DEAL_STATUS
,      WHOLESALE_REFERENCE
,      SELECT_REFERENCE
,      PROFIT_LOSS
,      SELECT_ACTION
,      PAYMENT_AMOUNT
,      BALANCE
,      AVG_RATE
,      CONTRA_NZD_AMOUNT
,      CPARTY_CODE
,      PAYMENT_STATUS
,      AUDIT_INDICATOR
,      ESTIMATE_DATE
,      ESTIMATE_AMOUNT
,      COVERED_BY_FX_CONTRACT
,      STATUS_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXTERNAL_COMMENTS
,      INTERNAL_COMMENTS
,      DEAL_LINK_CODE
,      CPARTY_ACCOUNT_NO
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      CASH_POSITION_EXPOSURE
FROM APPS.XTR_EXPOSURE_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.XTR_EXPOSURE_TRANSACTIONS_V references the following:

APPS: XTR_EXPOSURE_TRANSACTIONS

APPS.XTR_EXPOSURE_TRANSACTIONS_V is referenced by following:

APPS: XTR_LINKED_TRANSACTIONS_V; XTR_REVIEW_ALL_CONTRACTS_V