[Home] [Help] [Dependency Information]
Object Name: | XTR_AVG_RATES_RESULTS# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIQUE_ID | NUMBER | |||
P_I | VARCHAR2 | (1) | ||
PERIOD | VARCHAR2 | (15) | ||
DATE_FROM | DATE | |||
DATE_TO | DATE | |||
COMPANY_CODE | VARCHAR2 | (7) | ||
DEAL_TYPE | VARCHAR2 | (7) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
CPARTY_CODE | VARCHAR2 | (7) | ||
CURRENCY | VARCHAR2 | (15) | ||
CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
PRINCIPAL | NUMBER | |||
INTEREST | NUMBER | |||
AVERAGE_CONTRACT_RATE | NUMBER | |||
AVERAGE_SPOT_RATE | NUMBER | |||
MINIMUM_RATE | NUMBER | |||
MAXIMUM_RATE | NUMBER | |||
NUM_DEALS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UNIQUE_ID
, P_I
, PERIOD
, DATE_FROM
, DATE_TO
, COMPANY_CODE
, DEAL_TYPE
, PRODUCT_TYPE
, PORTFOLIO_CODE
, CPARTY_CODE
, CURRENCY
, CURRENCY_COMBINATION
, PRINCIPAL
, INTEREST
, AVERAGE_CONTRACT_RATE
, AVERAGE_SPOT_RATE
, MINIMUM_RATE
, MAXIMUM_RATE
, NUM_DEALS
FROM XTR.XTR_AVG_RATES_RESULTS#;
|
|
|