View: IGCFV_CC_REL_SUM_PAY_FORECASTS

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

View Text

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
, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER
, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER
, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER
, ORU.NAME ORGANIZATION_NAME
, CCP.ORG_ID ORGANIZATION_ID
, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, CCDPF.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_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
, HR_ALL_ORGANIZATION_UNITS ORU
, IGC_CC_PERIODS CCP
, GL_PERIODS GL_PERIODS
, IGC_CC_HEADERS IGC_CCH
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_HEADERS IGC_CCHP
WHERE CCDPF.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID
AND CCDPF.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID
AND IGCCAL.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID
AND IGCCAL.PARENT_HEADER_ID=IGC_CCHP.CC_HEADER_ID
AND CCDPF.CC_DET_PF_DATE BETWEEN GL_PERIODS.START_DATE
AND GL_PERIODS.END_DATE
AND CCP.ORG_ID=ORU.ORGANIZATION_ID
AND CCP.PERIOD_NAME=GL_PERIODS.PERIOD_NAME
AND CCP.PERIOD_SET_NAME=GL_PERIODS.PERIOD_SET_NAME GROUP BY CCP.ORG_ID
, ORU.NAME
, GL_PERIODS.PERIOD_YEAR
, IGCCAL.PARENT_HEADER_ID
, IGC_CCHP.CC_NUM
, CCDPF.PARENT_ACCT_LINE_ID
, IGCCALP.CC_ACCT_LINE_NUM
, IGCCAL.CC_HEADER_ID
, IGC_CCH.CC_NUM
, CCDPF.CC_ACCT_LINE_ID
, IGCCAL.CC_ACCT_LINE_NUM WITH READ ONLY

Columns