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_DEALS_INTERFACE_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is created in association with the base table Xtr_Deals_Interface. The table is designed to hold as much common deal information as possible.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXTERNAL_DEAL_ID	VARCHAR2	(240)	Yes	This stores the external unique primary identifier for each deal.
DEAL_TYPE	VARCHAR2	(7)	Yes	Code to identify a deal or instrument type.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
LOAD_STATUS_CODE	VARCHAR2	(30)		Flag that denotes the transfer status of the deal in this record. 'NEW' or null = New deal. 'UPDATED' = Updated Deal. 'ERROR' = Error deal. 'SUBMIT' = Submitted Deal. 'DEAL_TYPE_ERROR' = for non-supported deal type for transfer 'DUPLICATE_DEAL_ID' = for duplicate import deals.
BROKERAGE_CODE	VARCHAR2	(7)		Brokerage code.
BROKERAGE_CURRENCY	VARCHAR2	(15)		Currency code of brokerage amount.
ACCOUNT_NO_A	VARCHAR2	(20)		First account number.
ACCOUNT_NO_B	VARCHAR2	(80)		Second account number.
CLIENT_CODE	VARCHAR2	(7)		Client code.
COMMENTS	VARCHAR2	(255)		Internal comments.
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code.
CPARTY_CODE	VARCHAR2	(7)		Counterparty code. This column is also used to store THIRDPARTY_CODE for EXP deals.
CPARTY_ACCOUNT_NO	VARCHAR2	(20)		Counterparty bank account number
CPARTY_REF	VARCHAR2	(80)		Counterparty account reference code.
CURRENCY_A	VARCHAR2	(15)		First currency.
CURRENCY_B	VARCHAR2	(15)		Second currency.
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users.
DEAL_LINKING_CODE	VARCHAR2	(8)		Code to identify the group of linked deals.
DEAL_SUBTYPE	VARCHAR2	(7)		Code to sub-categorize deals within each deal type.
EXTERNAL_COMMENTS	VARCHAR2	(255)		External comments.
EXTERNAL_CPARTY_NO	VARCHAR2	(15)		External reference.
INTERNAL_TICKET_NO	VARCHAR2	(15)		Internal reference.
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions.
PORTFOLIO_CODE	VARCHAR2	(7)	Yes	Code for grouping deals under a single portfolio.
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type.
STATUS_CODE	VARCHAR2	(10)	Yes	Code for the execution status of deals and transactions.
AMOUNT_A	NUMBER			First amount.
AMOUNT_B	NUMBER			Second amount.
AMOUNT_C	NUMBER			Third amount.
RATE_A	NUMBER			First rate.
RATE_B	NUMBER			Second rate.
RATE_C	NUMBER			Third rate.
DATE_A	DATE			First date.
DATE_B	DATE			Second date.
NO_OF_DAYS	NUMBER			Number of days used to calculate interest.
ACTION_CODE	VARCHAR2	(7)		Amount action.
AMOUNT_TYPE	VARCHAR2	(7)		Amount type.
AMOUNT_HCE	NUMBER			Reporting currency amount.
EXPOSURE_TYPE	VARCHAR2	(10)		Exposure type.
SETTLE_ACTION_REQD	VARCHAR2	(80)		Flag that indicates whether Treasury to settle the transaction.
BANK_CODE_FROM	VARCHAR2	(7)		Stores the origin bank code.
BANK_CODE_TO	VARCHAR2	(7)		Stores the destination bank code.
MARKET_DATA_SET	VARCHAR2	(30)		Market Data Set.
PRICING_MODEL	VARCHAR2	(80)		Pricing Model.
OVERRIDE_LIMIT	VARCHAR2	(1)		Override Limit Flag 'Y' or NULL = override, 'N' = do not override limit, limit is flagged as error.
DUAL_AUTHORIZATION_BY	VARCHAR2	(30)		Validator.
DUAL_AUTHORIZATION_ON	DATE			Date of deal validation.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Category for Descriptive Flexfields.
ATTRIBUTE1	VARCHAR2	(150)		Flexfield.
ATTRIBUTE2	VARCHAR2	(150)		Flexfield.
ATTRIBUTE3	VARCHAR2	(150)		Flexfield.
ATTRIBUTE4	VARCHAR2	(150)		Flexfield.
ATTRIBUTE5	VARCHAR2	(150)		Flexfield.
ATTRIBUTE6	VARCHAR2	(150)		Flexfield.
ATTRIBUTE7	VARCHAR2	(150)		Flexfield.
ATTRIBUTE8	VARCHAR2	(150)		Flexfield.
ATTRIBUTE9	VARCHAR2	(150)		Flexfield.
ATTRIBUTE10	VARCHAR2	(150)		Flexfield.
ATTRIBUTE11	VARCHAR2	(150)		Flexfield.
ATTRIBUTE12	VARCHAR2	(150)		Flexfield.
ATTRIBUTE13	VARCHAR2	(150)		Flexfield.
ATTRIBUTE14	VARCHAR2	(150)		Flexfield.
ATTRIBUTE15	VARCHAR2	(150)		Flexfield.
LIMIT_CODE_B	VARCHAR2	(7)		The user-defined invest limit types assigned to the deals and transactions.
MIRROR_PORTFOLIO_CODE	VARCHAR2	(7)		Portfolio code for the mirror transaction.
MIRROR_PRODUCT_TYPE	VARCHAR2	(10)		Product type for the mirror transaction.
MIRROR_PRICING_MODEL	VARCHAR2	(80)		Mirror pricing model
MIRROR_LIMIT_CODE_FUND	VARCHAR2	(7)		Funding limit code for the mirror.
MIRROR_LIMIT_CODE_INVEST	VARCHAR2	(7)		Investment limit code for the mirror
ROUNDING_TYPE	VARCHAR2	(80)		Not currently used
DAY_COUNT_TYPE	VARCHAR2	(80)		Not currently used
ORIGINAL_AMOUNT	NUMBER			Not currently used
YEAR_CALC_TYPE	VARCHAR2	(80)		Field for year calculation type. See documentation for more details
DATE_C	DATE			Generic field for holding dates. See documentation for field field mappings for each deal type
BASIS_TYPE	VARCHAR2	(80)		Field for holding calculation basis. See documentation for more details
SECURITY_ID	VARCHAR2	(10)		Field for holding security id. See documentation for more details
ACCEPTOR_CODE	VARCHAR2	(7)		Field for holding risk party acceptor code. See documentation for more details
DRAWER_CODE	VARCHAR2	(7)		Field for holding risk party drawer code. See documentation for more details
ENDORSER_CODE	VARCHAR2	(7)		Field for holding risk party endorser code. See documentation for more details
SCHEDULE_A	VARCHAR2	(7)		Generic field for holding schedule codes. See documentation for field mappings for each deal type
SCHEDULE_B	VARCHAR2	(7)		Generic field for holding schedule codes. See documentation for field mappings for each deal type
OPTION_A	VARCHAR2	(1)		Generic field for holding options. See documentation for field mappings for each deal type
MIRROR_DEAL_LINKING_CODE	VARCHAR2	(8)		Code to identify the group of linked deals
MIRROR_DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
EXTERNAL_SOURCE	VARCHAR2	(30)		The source of the transactions
SETTLEMENT_FLAG	VARCHAR2	(1)		Flag for settlement
VALIDATION_FLAG	VARCHAR2	(1)		Flag for validation

Query Text

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


SELECT EXTERNAL_DEAL_ID
,      DEAL_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOAD_STATUS_CODE
,      BROKERAGE_CODE
,      BROKERAGE_CURRENCY
,      ACCOUNT_NO_A
,      ACCOUNT_NO_B
,      CLIENT_CODE
,      COMMENTS
,      COMPANY_CODE
,      CPARTY_CODE
,      CPARTY_ACCOUNT_NO
,      CPARTY_REF
,      CURRENCY_A
,      CURRENCY_B
,      DEALER_CODE
,      DEAL_LINKING_CODE
,      DEAL_SUBTYPE
,      EXTERNAL_COMMENTS
,      EXTERNAL_CPARTY_NO
,      INTERNAL_TICKET_NO
,      LIMIT_CODE
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      STATUS_CODE
,      AMOUNT_A
,      AMOUNT_B
,      AMOUNT_C
,      RATE_A
,      RATE_B
,      RATE_C
,      DATE_A
,      DATE_B
,      NO_OF_DAYS
,      ACTION_CODE
,      AMOUNT_TYPE
,      AMOUNT_HCE
,      EXPOSURE_TYPE
,      SETTLE_ACTION_REQD
,      BANK_CODE_FROM
,      BANK_CODE_TO
,      MARKET_DATA_SET
,      PRICING_MODEL
,      OVERRIDE_LIMIT
,      DUAL_AUTHORIZATION_BY
,      DUAL_AUTHORIZATION_ON
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LIMIT_CODE_B
,      MIRROR_PORTFOLIO_CODE
,      MIRROR_PRODUCT_TYPE
,      MIRROR_PRICING_MODEL
,      MIRROR_LIMIT_CODE_FUND
,      MIRROR_LIMIT_CODE_INVEST
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      ORIGINAL_AMOUNT
,      YEAR_CALC_TYPE
,      DATE_C
,      BASIS_TYPE
,      SECURITY_ID
,      ACCEPTOR_CODE
,      DRAWER_CODE
,      ENDORSER_CODE
,      SCHEDULE_A
,      SCHEDULE_B
,      OPTION_A
,      MIRROR_DEAL_LINKING_CODE
,      MIRROR_DEALER_CODE
,      EXTERNAL_SOURCE
,      SETTLEMENT_FLAG
,      VALIDATION_FLAG
FROM APPS.XTR_DEALS_INTERFACE_V;

Dependencies

[top of page]

APPS.XTR_DEALS_INTERFACE_V references the following:

APPS: XTR_DEALS_INTERFACE; XTR_PARTIES_V; XTR_PARTY_INFO; XTR_USER_ACCESS - show dependent code

APPS.XTR_DEALS_INTERFACE_V is not referenced by any database object