Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_SETTLEMENT_LETTERS_V |
SELECT SUM(CASHFLOW_AMOUNT) SETTLE_AMOUNT
, NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO) CPARTY_ACCOUNT_NO
, ACCOUNT_NO
, NVL(ACTUAL_SETTLEMENT_DATE
, AMOUNT_DATE) ACTUAL_SETTLEMENT_DATE
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE) SETTLE_PARTY
, CPARTY_CODE
, DIRECT_DEBIT
, CHQ_REQD
FROM XTR_DEAL_DATE_AMOUNTS_V
WHERE NETOFF_NUMBER IS NOT NULL
AND SETTLE = 'Y' HAVING SUM(CASHFLOW_AMOUNT) <> 0 GROUP BY NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO)
, ACCOUNT_NO
, NVL(ACTUAL_SETTLEMENT_DATE
, AMOUNT_DATE)
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE)
, CPARTY_CODE
, DIRECT_DEBIT
, CHQ_REQD UNION ALL SELECT CASHFLOW_AMOUNT SETTLE_AMOUNT
, NVL(BENEFICIARY_ACCOUNT_NO
, CPARTY_ACCOUNT_NO) CPARTY_ACCOUNT_NO
, ACCOUNT_NO
, NVL(ACTUAL_SETTLEMENT_DATE
, AMOUNT_DATE) ACTUAL_SETTLEMENT_DATE
, NETOFF_NUMBER
, NETOFF_GROUP_FLAG
, CURRENCY
, COMPANY_CODE
, SETTLEMENT_ACTIONED
, TRANS_MTS
, NVL(BENEFICIARY_PARTY
, CPARTY_CODE) SETTLE_PARTY
, CPARTY_CODE
, DIRECT_DEBIT
, CHQ_REQD
FROM XTR_DEAL_DATE_AMOUNTS_V
WHERE NETOFF_NUMBER IS NULL
AND CASHFLOW_AMOUNT <> 0
AND SETTLE = 'Y'