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]

TABLE: XTR.XTR_QUICK_INPUT_DEALS

Object Details

Object Name:	XTR_QUICK_INPUT_DEALS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_QUICK_INPUT_DEALS
Subobject Name:
Status:	VALID

XTR_QUICK_INPUT_DEALS contains the information for short term money or foreign exchange deals, that was entered in the Quick Deals window. Each row corresponds to either a complete or an incomplete deal. The only valid values for the DEAL_TYPE column are FX (for foreign exchange) or ONC (short term money).
This table corresponds to the Quick Deals window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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

Dependencies

[top of page]

XTR.XTR_QUICK_INPUT_DEALS does not reference any database object

XTR.XTR_QUICK_INPUT_DEALS is referenced by following:

XTR: XTR_QUICK_INPUT_DEALS#