|
SELECT A.TXN_KEY , SUM(A.AMOUNT) , SUM(CASE WHEN A.CAPITALIZE_SW = 'N' THEN A.OBLIGATION_REDUCE ELSE CASE WHEN A.ASSET_CLASSIFY = 'C' THEN A.AMOUNT - A.INTEREST_AMOUNT ELSE A.OBLIGATION_REDUCE END END) , SUM(A.INTEREST_AMOUNT) FROM PS_RE_LS_AM_SCH_VW A LEFT OUTER JOIN PS_RE_LS_DS_RND_VW B ON (B.LS_KEY = A.LS_KEY AND B.AMND_NBR = A.AMND_NBR AND A.ASSET_SEQ_NBR = B.ASSET_SEQ_NBR AND A.DISTRIBUTION_ID = B.DISTRIBUTION_ID) WHERE A.ROUNDING_APPLIED <> 'Y' AND (B.DISTRIBUTION_ID IS NOT NULL OR A.DISTRIBUTION_ID IS NULL) GROUP BY A.TXN_KEY
|