Archives of the TeradataForum

Message Posted: Fri, 16 Jan 2009 @ 10:08:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

There is no need for bracket after select clause

FYI:

     SELECT
        a.OPR_ACCT_NR,
        a.FINAL_MATURITY_DT,
        m.END_OF_DRAW_DISP_CD,
        a.PORTFOLIO_CD,
        a.ESTM_MATURITY_DT EODDate,
        a.LOAN_TYPE_CD,
        m.CHRG_OFF_RCVRY_CD,
        m.Collectability_CD,
        a.CS_OVERRIDE_CD,
        m.PAST_DUE_AM,
        a.FINAL_MATURITY_DT,
        (substr(a.OPR_ACCT_NR,4,10)) UnivNum, ((current_date) - (a.ESTM_MATURITY_DT)) DPD,
        CASE
        WHEN m.PAST_DUE_DT IS NULL THEN 0
        ELSE ((Current_Date) - (m.PAST_DUE_DT))
        END Past_Due_Days,
        m.CURRENT_BAL_AM,
        a.CTP_CD,
        m.CTP_REASON_CD,
        a.CTP_DT,
        (COALESCE((SELECT
          (COALESCE(SUM(N.PRIN_BAL_AM + N.MISC_AM + N.INT_CHRG_AM),0) ))
         FROM
          HEIDS.DLY_ST_MONEY N
         WHERE
          N.CUST_ACCT_ID = A.CUST_ACCT_ID
          AND N.TRAN_CD IN ('30A', '30I', '30C')
          AND (N.PROCESS_DT = (SELECT (MAX(N2.PROCESS_DT)))
           FROM
            HEIDS.DLY_ST_MONEY N2
           WHERE
            N2.CUST_ACCT_ID = N.CUST_ACCT_ID
            AND N2.TRAN_CD IN ('30A', '30I', '30C'))
          ) ,0) PmtProcAM,
         (
         SELECT
          (MAX(N.PROCESS_DT))
         FROM
          HEIDS.DLY_ST_MONEY N
         WHERE
          N.CUST_ACCT_ID = A.CUST_ACCT_ID
          AND N.TRAN_CD IN ('30A', '30I', '30C')
         ) PmtProcDate,
        '' BK_File_Date
     FROM
        HEIDS.DLY_ACCOUNT a,
        HEIDS.DLY_ACCOUNT_MSR m,
        HEIDS.DLY_ACCT_CUSTOMER c

     WHERE
         a.CUST_ACCT_ID = m.CUST_ACCT_ID
        AND a.CUST_ACCT_ID = c.CUST_ACCT_ID
        AND a.ESTM_MATURITY_DT < Current_Date
        AND m.ACCT_STATUS_CD = 'OPEN'
        AND a.PORTFOLIO_CD IN('HEQ','PCM')
        AND a.LOAN_TYPE_CD = '8'
        AND m.CHRG_OFF_RCVRY_CD <> '0'

        
        AND (
         ('#EVENT#' = 'Bankruptcy' AND m.CHRG_OFF_RCVRY_CD = 'B' AND
     m.Collectability_CD NOT IN ('MO', 'MS', 'MB', 'FO', 'FS', 'FB', 'TO', 'TS', 'TB', 'F9'))
         OR
         ('#EVENT#' = 'Foreclosure' AND m.CHRG_OFF_RCVRY_CD = 'F' AND
     m.Collectability_CD <> 'F9')
         OR
         ('#EVENT#' = 'Pre-foreclosure' AND m.Collectability_CD = 'F9')
         OR
         ('#EVENT#' = 'Other' AND m.CHRG_OFF_RCVRY_CD NOT IN ('F', 'B') AND
     m.Collectability_CD <> 'F9')
         )
        

     ORDER BY a.ESTM_MATURITY_DT

	<Prev	Next>		<<First	<Prev	Next>	Last>>