[Home] [Help] [Dependency Information]
Object Name: | XTR_NET_POSITIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_NET_POSITIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
XTR_NET_POSITIONS_V contains view information for your current net positions. Your position is derived from information in the XTR_MIRROR_DDA_LIMIT_ROW table. Each row in XTR_NET_POSITIONS_V corresponds to a net position grouped by company, counterparty, deal type, deal subtype, product type, portfolio, currency and currency combination.
This table corresponds to the Net Transaction Positions window.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_CODE | VARCHAR2 | (7) | Company code | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
USER_DEAL_TYPE | VARCHAR2 | (7) | Yes | User-defined deal type code |
CURRENCY | VARCHAR2 | (15) | Currency code | |
CONTRA_CCY | VARCHAR2 | (15) | Contra currency in a foreign exchange currency quote. | |
CURRENCY_COMBINATION | VARCHAR2 | (31) | Currency quotations which combine a base and a contra currency | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
USER_DEAL_SUBTYPE | VARCHAR2 | (7) | User-defined deal subtype code | |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
DEALER_CODE | VARCHAR2 | (10) | Dealer code | |
ACCOUNT_NO | VARCHAR2 | (20) | Account number | |
GROSS_PRINCIPAL | NUMBER | Gross principal amount | ||
DOMESTIC_CCY_PRIN | NUMBER | Gross principal amount in reporting currency equivalent | ||
WEIGHTED_AVG_PRINCIPAL | NUMBER | Average principal of face value amount times transaction rate | ||
NO_OF_DEALS | NUMBER | Number of deals (or transactions for short term money deals)of the net | ||
MIN_GROSS | NUMBER | Minimum amount | ||
MAX_GROSS | NUMBER | Maximum amount | ||
MIN_RATE | NUMBER | Minimum transaction rate | ||
MAX_RATE | NUMBER | Maximum transaction rate |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_CODE
, DEAL_TYPE
, USER_DEAL_TYPE
, CURRENCY
, CONTRA_CCY
, CURRENCY_COMBINATION
, DEAL_SUBTYPE
, USER_DEAL_SUBTYPE
, CPARTY_CODE
, PRODUCT_TYPE
, PORTFOLIO_CODE
, DEALER_CODE
, ACCOUNT_NO
, GROSS_PRINCIPAL
, DOMESTIC_CCY_PRIN
, WEIGHTED_AVG_PRINCIPAL
, NO_OF_DEALS
, MIN_GROSS
, MAX_GROSS
, MIN_RATE
, MAX_RATE
FROM APPS.XTR_NET_POSITIONS_V;
|
|
|