[Home] [Help] [Dependency Information]
Object Name: | XTR_BIS_NET_POSITIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_BIS_NET_POSITIONS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows current net positions grouped by company, counterparty, deal type, deal subtype, product type, portfolio, currency, contra currency and currency combination.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY | VARCHAR2 | (7) | ||
COMPANY_NAME | VARCHAR2 | (20) | Yes | |
SYS_DEAL_TYPE | VARCHAR2 | (7) | Yes | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
CURR | VARCHAR2 | (15) | ||
CONTRA_CURR | VARCHAR2 | (15) | ||
CURR_COMBINATION | VARCHAR2 | (31) | ||
SYS_DEAL_SUBTYPE | VARCHAR2 | (7) | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
CPARTY | VARCHAR2 | (7) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
PORTFOLIO | VARCHAR2 | (7) | ||
GROSS_AMOUNT | NUMBER | |||
REPORTING_CURR_AMOUNT | NUMBER | |||
WEIGHTED_AMOUNT | NUMBER | |||
NO_OF_DEALS | NUMBER | |||
MIN_GROSS | NUMBER | |||
MAX_GROSS | NUMBER | |||
MIN_RATE | NUMBER | |||
MAX_RATE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY
, COMPANY_NAME
, SYS_DEAL_TYPE
, DEAL_TYPE
, CURR
, CONTRA_CURR
, CURR_COMBINATION
, SYS_DEAL_SUBTYPE
, DEAL_SUBTYPE
, CPARTY
, PRODUCT_TYPE
, PORTFOLIO
, GROSS_AMOUNT
, REPORTING_CURR_AMOUNT
, WEIGHTED_AMOUNT
, NO_OF_DEALS
, MIN_GROSS
, MAX_GROSS
, MIN_RATE
, MAX_RATE
FROM APPS.XTR_BIS_NET_POSITIONS_V;
APPS.XTR_BIS_NET_POSITIONS_V is not referenced by any database object
|
|
|