View: IGC_CC_SMRY_PF_V

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

View Text

SELECT CCDPF.CC_ACCT_LINE_ID
, CP.PERIOD_YEAR
, CP.ORG_ID
, SUM(CCDPF.CC_DET_PF_ENTERED_AMT)
, SUM(CCDPF.CC_DET_PF_FUNC_AMT)
, SUM(CCDPF.CC_DET_PF_BILLED_AMT)
, SUM(CCDPF.CC_DET_PF_ENCMBRNC_AMT)
, SUM(NVL(CCDPF.CC_DET_PF_COMP_FUNC_AMT
, 0) - NVL(CCDPF.CC_DET_PF_ENCMBRNC_AMT
, 0))
FROM IGC_CC_DET_PF_V CCDPF
, IGC_CC_PERIODS_V CP
WHERE CCDPF.CC_DET_PF_DATE BETWEEN CP.START_DATE
AND CP.END_DATE GROUP BY CCDPF.CC_ACCT_LINE_ID
, CP.PERIOD_YEAR
, CP.ORG_ID

Columns