[Home] [Help]
View: XTR_FX_POSI_V
Product: | XTR - Treasury |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CURRENCY_BUY CURRENCY
, BUY_AMOUNT AMOUNT
, COMPANY_CODE
, PORTFOLIO_CODE
FROM XTR_DEALS_V
WHERE DEAL_TYPE = 'FX'
AND STATUS_CODE = 'CURRENT'
AND VALUE_DATE >= TRUNC(SYSDATE) UNION SELECT CURRENCY_SELL CURRENCY
, -SELL_AMOUNT AMOUNT
, COMPANY_CODE
, PORTFOLIO_CODE
FROM XTR_DEALS_V
WHERE DEAL_TYPE = 'FX'
AND STATUS_CODE = 'CURRENT'
AND VALUE_DATE >= TRUNC(SYSDATE)
Columns
Name |
CURRENCY |
AMOUNT |
COMPANY_CODE |
PORTFOLIO_CODE |