[Home] [Help]
View: IGC_CC_SMRY_PF_VERSION_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_ENCMBRNC_AMT)
FROM IGC_CC_DET_PF_VERSION_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
Name |
CC_ACCT_LINE_ID |
CC_FISCAL_YEAR |
ORG_ID |
CC_SMRY_PF_ENT_AMT |
CC_SMRY_PF_FUNC_AMT |
CC_SMRY_PF_ENCMBRNC_AMT |