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_QUICK_INPUT_DEALS_V

Object Details

Object Name:	XTR_QUICK_INPUT_DEALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_QUICK_INPUT_DEALS_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
QUOTE_NO	NUMBER		Yes	Number identifier of the quote received from a counterparty for the quick input deal
DEAL_NO	NUMBER			Unique number assigned to each deal
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction
COMPANY_CODE	VARCHAR2	(7)		Company code
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
CLIENT_CODE	VARCHAR2	(7)		Client for which the deal is made
DEAL_TYPE	VARCHAR2	(7)		Code for high level deals
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
ISSUE_CODE	VARCHAR2	(7)		Not currently used
CURRENCY1	VARCHAR2	(15)		Buy currency for foreign exchange deals
CURRENCY2	VARCHAR2	(15)		Sell currency for foreign exchange deals
TRANSACTION_RATE	NUMBER			Transaction rate for the quick deal
FX_SWAP_RATE	NUMBER			Foreign exchange swap rate
AMOUNT_TYPE	VARCHAR2	(7)		Code that identifies the purpose of the amounts for a deal type
BASE_AMOUNT	NUMBER			Amount of deal
DEAL_DATE	DATE			Date the deal is made
VALUE_DATE	DATE			Date quick deal takes place
MATURITY_DATE	DATE			Date the deal matures or an action is required
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
CREATED_BY	VARCHAR2	(30)		User who created this record
CREATED_ON	DATE			Date this record was created
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
FULL_INPUT_COMPLETED	VARCHAR2	(1)		Flag to determine if all details have been entered in a quick input deal (Y), or not (N)
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PUT_CALL	VARCHAR2	(1)		Not currently used
PREMIUM_AMOUNT	NUMBER			Not currently used
YEAR_CALC_TYPE	VARCHAR2	(15)		Not currently used
ROUNDING_TYPE	VARCHAR2	(1)		Not currently used
DAY_COUNT_TYPE	VARCHAR2	(1)		Not currently used
PREPAID_INTEREST	VARCHAR2	(1)		Identify whether it is a prepaid interest deal

Query Text

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


SELECT QUOTE_NO
,      DEAL_NO
,      TRANSACTION_NUMBER
,      COMPANY_CODE
,      CPARTY_CODE
,      CLIENT_CODE
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      ISSUE_CODE
,      CURRENCY1
,      CURRENCY2
,      TRANSACTION_RATE
,      FX_SWAP_RATE
,      AMOUNT_TYPE
,      BASE_AMOUNT
,      DEAL_DATE
,      VALUE_DATE
,      MATURITY_DATE
,      DEALER_CODE
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      FULL_INPUT_COMPLETED
,      STATUS_CODE
,      PORTFOLIO_CODE
,      PUT_CALL
,      PREMIUM_AMOUNT
,      YEAR_CALC_TYPE
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      PREPAID_INTEREST
FROM APPS.XTR_QUICK_INPUT_DEALS_V;

Dependencies

[top of page]

APPS.XTR_QUICK_INPUT_DEALS_V references the following:

APPS: XTR_QUICK_INPUT_DEALS

APPS.XTR_QUICK_INPUT_DEALS_V is not referenced by any database object