[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 |