SELECT DISTINCT                                                              

CASE WHEN COALESCE(JOB.OU_ID,0) = 0 THEN LO_SMY.EMP_OU_ID ELSE COALESCE(JOB.OU_ID,0) END AS OU_ID,
LO_SMY.EMP_OU_ID,
ORGANIZATION_UNIT.NAME AS JOB_OU_DESCR,
LO_SMY.EMP_ID,
EMPLOYEE.LAST_NAME || ', ' || EMPLOYEE.FIRST_NAME AS EMP_NAME,
COALESCE(JOB.JT_CD,'NONE') AS JT_CD,
COALESCE(LO_SMY.REG_RATE,0) AS REG_RATE,
SUM(COALESCE(LO_SMY.REG_HRS + LO_SMY.TH_HRS + LO_SMY.DT_HRS,0)) AS WORK_HRS,
COALESCE(UDF_DATA.NUMBER_VALUE,1.28) AS B_RATE,
SUM(ROUND(COALESCE((REG_HRS + DT_HRS + TH_HRS)*LO_SMY.REG_RATE*UDF_DATA.NUMBER_VALUE,0),2)) AS B_AMT
FROM LO_SMY 
LEFT OUTER JOIN EMPLOYEE ON (LO_SMY.EMP_ID = EMPLOYEE.EMP_ID)
LEFT OUTER JOIN JOB ON (LO_SMY.JOB_ID = JOB.JOB_ID)
LEFT OUTER JOIN ORGANIZATION_UNIT ON (JOB.OU_ID = ORGANIZATION_UNIT.OU_ID)
LEFT OUTER JOIN UDF_DATA ON (EMPLOYEE.UDF_ROW_ID = UDF_DATA.UDF_ROW_ID AND UDF_DATA.UDF_COLUMN_NAME = 'EMPLOYEE_BURDEN_RATE')
LEFT OUTER JOIN REV_DTL_DATA ON LO_SMY.PROCESS_REQ_NUM = REV_DTL_DATA.REF_PR_NUM AND
LO_SMY.SEQ_NUM = REV_DTL_DATA.REF_SEQ_NUM AND REV_DTL_DATA.DISTR_TYPE_CD = 'P'
WHERE
((LO_SMY.COST_TYPE_CD LIKE 'L') OR (LO_SMY.COST_TYPE_CD LIKE 'LO') OR 
(LO_SMY.COST_TYPE_CD LIKE 'CL') OR (LO_SMY.COST_TYPE_CD IS NULL)) AND 
(REG_HRS + DT_HRS + TH_HRS) IS NOT NULL AND LO_SMY.REG_RATE>0 AND
(LO_SMY.EMP_ID IS NOT NULL) AND (ACCT_NUM <> '5510')"
GROUP BY (LO_SMY.EMP_ID, JOB.OU_ID, LO_SMY.EMP_OU_ID, ORGANIZATION_UNIT.NAME, EMPLOYEE.LAST_NAME, EMPLOYEE.FIRST_NAME, JOB.JT_CD, LO_SMY.REG_RATE, UDF_DATA.NUMBER_VALUE)

SUM(COALESCE(LO_SMY.REG_HRS+LO_SMY.TH_HRS+LO_SMY.DT_HRS,0)) AS BILL_HRS,
SUM(COALESCE(REV_DTL_DATA.REVENUE_AMT,0)) AS BILL_AMT
FROM LO_SMY
LEFT OUTER JOIN JOB ON (LO_SMY.JOB_ID=JOB.JOB_ID)
LEFT OUTER JOIN REV_DTL_DATA ON (LO_SMY.PROCESS_REQ_NUM = REV_DTL_DATA.REF_PR_NUM AND
             LO_SMY.SEQ_NUM = REV_DTL_DATA.REF_SEQ_NUM AND REV_DTL_DATA.DISTR_TYPE_CD = 'P')
WHERE (JOB.JT_CD BETWEEN '2' AND '8' OR JOB.JT_CD='13')