VIEW: APPS.XTR_SETTLEMENT_LETTERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'