[Home] [Help]
View: XTR_FX_EXPOSURES_VIEW_V
View Text
SELECT B.PARTY_CODE COMPANY
, P.SHORT_NAME COMPANY_NAME
, B.CURRENCY CCY
, 'CA' DEAL_TYPE
, 'N/A' DEAL_SUBTYPE
, 0 TOTAL_EXP
, 0 FX_COVER
, NVL(ROUND( SUM( NVL(B.OPENING_BALANCE
, 0))
, 0)
, 0) CASH_ON_HAND FROM XTR_BANK_ACCOUNTS B
, XTR_PARTIES_V P WHERE B.PARTY_CODE = P.PARTY_CODE AND P.PARTY_TYPE = 'C'
AND NVL(B.SETOFF_ACCOUNT_YN
, 'N') <> 'Y' GROUP BY B.PARTY_CODE
, P.SHORT_NAME
, B.CURRENCY UNION ALL SELECT D.COMPANY_CODE COMPANY
, P.SHORT_NAME COMPANY_NAME
, D.CURRENCY_CODE CCY
, D.DDA_DEAL_TYPE DEAL_TYPE
, D.DDA_DEAL_SUBTYPE DEAL_SUBTYPE
, NVL(DECODE(SIGN(D.TRX_DATE-TRUNC(SYSDATE))
, -1
, 0
, DECODE(D.DDA_DEAL_TYPE
, 'FX'
, 0
, 'FXO'
, 0
, D.AMOUNT))
, 0) TOTAL_EXP
, NVL(DECODE(SIGN(D.TRX_DATE-TRUNC(SYSDATE))
, -1
, 0
, DECODE(D.DDA_DEAL_TYPE
, 'FX'
, D.AMOUNT
, 'FXO'
, D.AMOUNT
, 0))
, 0) FX_COVER
, NVL(DECODE(D.DDA_DEAL_TYPE
, 'ONC'
, DECODE(SIGN(D.TRX_DATE-TRUNC(SYSDATE))
, -1
, DECODE(D.AMOUNT_TYPE
, 'MATURE'
, 0
, -D.AMOUNT)
, 0)
, 0)
, 0) CASH_ON_HAND
FROM XTR_CASHFLOWS_V D
, XTR_PARTIES_V P
WHERE D.STATUS_CODE = 'CURRENT'
AND D.COMPANY_CODE = P.PARTY_CODE
Columns
Name |
COMPANY |
COMPANY_NAME |
CCY |
DEAL_TYPE |
DEAL_SUBTYPE |
TOTAL_EXP |
FX_COVER |
CASH_ON_HAND |