[Home] [Help]
View: XTR_EFT_CREDITS_V
View Text
SELECT SUM(CASHFLOW_AMOUNT) SETTLE_AMOUNT
, NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO) CPARTY_ACCOUNT_NO
, ACCOUNT_NO
, ACTUAL_SETTLEMENT_DATE
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE) SETTLE_PARTY
, CPARTY_CODE
FROM XTR_DEAL_DATE_AMOUNTS_V
WHERE NETOFF_NUMBER IS NOT NULL
AND TRANS_MTS = 'Y'
AND SETTLE = 'Y' HAVING SUM(CASHFLOW_AMOUNT) < 0 GROUP BY NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO)
, ACCOUNT_NO
, ACTUAL_SETTLEMENT_DATE
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE)
, CPARTY_CODE UNION ALL SELECT CASHFLOW_AMOUNT SETTLE_AMOUNT
, NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO) CPARTY_ACCOUNT_NO
, ACCOUNT_NO
, ACTUAL_SETTLEMENT_DATE
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE) SETTLE_PARTY
, CPARTY_CODE
FROM XTR_DEAL_DATE_AMOUNTS_V
WHERE NETOFF_NUMBER IS NULL
AND CASHFLOW_AMOUNT < 0
AND TRANS_MTS = 'Y'
AND SETTLE = 'Y'
Columns
Name |
SETTLE_AMOUNT |
CPARTY_ACCOUNT_NO |
ACCOUNT_NO |
ACTUAL_SETTLEMENT_DATE |
NETOFF_NUMBER |
NETOFF_GROUP_FLAG |
CURRENCY |
COMPANY_CODE |
SETTLEMENT_ACTIONED |
TRANS_MTS |
SETTLE_PARTY |
CPARTY_CODE |