SELECT CC_HDR_ID , MAX (ACTIVITY_DATE) MAX_ACTIVITY_DATE FROM ( SELECT ICH.CC_HEADER_ID CC_HDR_ID , MAX (ICH.LAST_UPDATE_DATE) ACTIVITY_DATE FROM IGC_CC_HEADERS ICH GROUP BY CC_HEADER_ID UNION SELECT ICHH.CC_HEADER_ID , MAX (ICHH.LAST_UPDATE_DATE) FROM IGC_CC_HEADER_HISTORY ICHH GROUP BY ICHH.CC_HEADER_ID UNION SELECT ICAL.CC_HEADER_ID , MAX (ICAL.LAST_UPDATE_DATE) FROM IGC_CC_ACCT_LINES ICAL GROUP BY ICAL.CC_HEADER_ID UNION SELECT ICALH.CC_HEADER_ID , MAX (ICALH.LAST_UPDATE_DATE) FROM IGC_CC_ACCT_LINE_HISTORY ICALH GROUP BY ICALH.CC_HEADER_ID UNION SELECT ICAL.CC_HEADER_ID , MAX (ICDP.LAST_UPDATE_DATE) FROM IGC_CC_ACCT_LINES ICAL , IGC_CC_DET_PF ICDP WHERE ICAL.CC_ACCT_LINE_ID = ICDP.CC_ACCT_LINE_ID GROUP BY ICAL.CC_HEADER_ID UNION SELECT ICAL.CC_HEADER_ID , MAX (ICDPH.LAST_UPDATE_DATE) FROM IGC_CC_ACCT_LINES ICAL , IGC_CC_DET_PF_HISTORY ICDPH WHERE ICAL.CC_ACCT_LINE_ID = ICDPH.CC_ACCT_LINE_ID GROUP BY ICAL.CC_HEADER_ID ) GROUP BY CC_HDR_ID