VIEW: APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS

Source

View Text - Preformatted

SELECT sum(CCDPF.CC_DET_PF_ENTERED_AMT) REL_SUMMARY_PF_ENTERED_AMOUNT, sum(CCDPF.CC_DET_PF_FUNC_AMT) REL_SUM_PF_FUNCTIONAL_AMOUNT, sum(CCDPF.CC_DET_PF_BILLED_AMT) REL_SUMMARY_PF_BILLED_AMOUNT, sum(CCDPF.CC_DET_PF_UNBILLED_AMT) REL_SUMMARY_PF_UNBILLED_AMOUNT, sum(CCDPF.CC_DET_PF_ENCMBRNC_AMT) RELEASE_SUM_PF_ENCUMBER_AMOUNT, GL_PERIODS.PERIOD_YEAR PERIOD_YEAR, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID, CCDPF.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID, CCP.ORG_ID ORGANIZATION_ID, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID, CCDPF.CC_ACCT_LINE_ID RELEASE_ACCOUNT_LINE_ID FROM IGC_CC_DET_PF CCDPF,IGC_CC_ACCT_LINES IGCCAL,IGC_CC_PERIODS_ALL CCP,GL_PERIODS GL_PERIODS WHERE CCDPF.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID and ccdpf.cc_det_pf_date BETWEEN gl_periods.start_date AND gl_periods.end_date and ccp.period_name=gl_periods.period_name and ccp.period_set_name=gl_periods.period_set_name GROUP BY ccp.org_id, gl_periods.period_year,igccal.parent_header_id, ccdpf.parent_acct_line_id, igccal.cc_header_id, ccdpf.cc_acct_line_id WITH READ ONLY

View Text - HTML Formatted

SELECT SUM(CCDPF.CC_DET_PF_ENTERED_AMT) REL_SUMMARY_PF_ENTERED_AMOUNT
, SUM(CCDPF.CC_DET_PF_FUNC_AMT) REL_SUM_PF_FUNCTIONAL_AMOUNT
, SUM(CCDPF.CC_DET_PF_BILLED_AMT) REL_SUMMARY_PF_BILLED_AMOUNT
, SUM(CCDPF.CC_DET_PF_UNBILLED_AMT) REL_SUMMARY_PF_UNBILLED_AMOUNT
, SUM(CCDPF.CC_DET_PF_ENCMBRNC_AMT) RELEASE_SUM_PF_ENCUMBER_AMOUNT
, GL_PERIODS.PERIOD_YEAR PERIOD_YEAR
, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, CCDPF.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID
, CCP.ORG_ID ORGANIZATION_ID
, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, CCDPF.CC_ACCT_LINE_ID RELEASE_ACCOUNT_LINE_ID
FROM IGC_CC_DET_PF CCDPF
, IGC_CC_ACCT_LINES IGCCAL
, IGC_CC_PERIODS_ALL CCP
, GL_PERIODS GL_PERIODS
WHERE CCDPF.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID
AND CCDPF.CC_DET_PF_DATE BETWEEN GL_PERIODS.START_DATE
AND GL_PERIODS.END_DATE
AND CCP.PERIOD_NAME=GL_PERIODS.PERIOD_NAME
AND CCP.PERIOD_SET_NAME=GL_PERIODS.PERIOD_SET_NAME GROUP BY CCP.ORG_ID
, GL_PERIODS.PERIOD_YEAR
, IGCCAL.PARENT_HEADER_ID
, CCDPF.PARENT_ACCT_LINE_ID
, IGCCAL.CC_HEADER_ID
, CCDPF.CC_ACCT_LINE_ID WITH READ ONLY