VIEW: APPS.IGC_CC_SMRY_PF_VERSION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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