VIEW: APPS.IGC_CC_HDRS_MAX_DATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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