[Home] [Help]
View: XTR_SETTLE_ROW_UTILISED_V
View Text
SELECT NVL(SUM(ROUND(ABS(A.CASHFLOW_AMOUNT) / M.HCE_RATE
, 0))
, 0)
, A.CPARTY
, A.COMPANY
, NVL(A.AMOUNT_DATE
, TRUNC(SYSDATE)) FROM XTR_SETTLEMENTS_V A
, XTR_MASTER_CURRENCIES M WHERE A.AMOUNT_DATE = TRUNC(SYSDATE)
AND A.CASHFLOW_AMOUNT <> 0
AND M.CURRENCY = A.CURRENCY GROUP BY A.CPARTY
, A.COMPANY
, NVL(A.AMOUNT_DATE
, TRUNC(SYSDATE))
Columns
Name |
UTILISED_AMOUNT |
CPARTY_CODE |
COMPANY_CODE |
EFFECTIVE_DATE |