View: IGC_CC_CLOSED_CANC_HDRS_V

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

View Text

SELECT DATE_V.CC_HDR_ID CC_HD_ID
, ICH.CC_NUM CC_NUM_VAL
, ICAL.CC_ACCT_LINE_ID CC_ACT_ID
, ICDP.CC_DET_PF_LINE_ID CC_PF_ID
, DATE_V.MAX_ACTIVITY_DATE MAX_DT
FROM IGC_CC_HEADERS ICH
, IGC_CC_HDRS_MAX_DATES_V DATE_V
, IGC_CC_ACCT_LINES ICAL
, IGC_CC_DET_PF ICDP
WHERE ICH.CC_HEADER_ID = DATE_V.CC_HDR_ID
AND ICH.CC_STATE IN ('CL'
, 'CT')
AND ICH.CC_APPRVL_STATUS = 'AP'
AND DATE_V.CC_HDR_ID = ICAL.CC_HEADER_ID
AND ICAL.CC_ACCT_LINE_ID = ICDP.CC_ACCT_LINE_ID

Columns