[Home] [Help]
View: 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
Name |
CC_ACCT_LINE_ID |
CC_FISCAL_YEAR |
ORG_ID |
CC_SMRY_PF_ENT_AMT |
CC_SMRY_PF_FUNC_AMT |
CC_SMRY_PF_BILLED_AMT |
CC_SMRY_PF_ENCMBRNC_AMT |
CC_SMRY_PF_UNENCMBRD_AMT |