View: XTR_SETTLE_ROW_UTILISED_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.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