View: IGC_CC_HDRS_MAX_DATES_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CC_HDRS_MAX_DATES_V

View Text

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

Columns