FND Design Data [Home] [Help]

View: IGCBV_MC_REL_SUM_PAY_FORECASTS

Product: IGC - Contract Commitment
Description:
Implementation/DBA Data: ViewAPPS.IGCBV_MC_REL_SUM_PAY_FORECASTS
View Text

SELECT SUM(IGC_CC_MC_DET_PF.CC_DET_PF_FUNC_AMT) REL_SUM_PF_FUNCTIONAL_AMOUNT
, SUM(IGC_CC_MC_DET_PF.CC_DET_PF_ENCMBRNC_AMT) REL_SUMMARY_PF_ENCUMBER_AMOUNT
, IGC_CC_MC_DET_PF.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, IGC_CC_MC_DET_PF.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IGC_CC_MC_DET_PF.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GL_PERIODS.PERIOD_YEAR PERIOD_YEAR
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGCCAL.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID
, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, CCP.ORG_ID ORGANIZATION_ID
, IGCCAL.CC_ACCT_LINE_ID ACCOUNT_LINE_ID
, IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM IGC_CC_ACCT_LINES IGCCAL
, IGC_CC_PERIODS CCP
, GL_PERIODS GL_PERIODS
, IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, IGC_CC_DET_PF CCDPF
WHERE IGC_CC_MC_DET_PF.CC_DET_PF_LINE_ID=CCDPF.CC_DET_PF_LINE_ID
AND CCDPF.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID
AND IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_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 IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID
, GL_SETS_OF_BOOKS.NAME
, GL_SETS_OF_BOOKS.SHORT_NAME
, CCP.ORG_ID
, GL_PERIODS.PERIOD_YEAR
, IGCCAL.PARENT_HEADER_ID
, IGCCAL.PARENT_ACCT_LINE_ID
, IGCCAL.CC_HEADER_ID
, IGCCAL.CC_ACCT_LINE_ID
, IGC_CC_MC_DET_PF.CONVERSION_TYPE
, IGC_CC_MC_DET_PF.CONVERSION_DATE
, IGC_CC_MC_DET_PF.CONVERSION_RATE WITH READ ONLY

Columns

Name
REL_SUM_PF_FUNCTIONAL_AMOUNT
REL_SUMMARY_PF_ENCUMBER_AMOUNT
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
PERIOD_YEAR
SETS_OF_BOOKS_NAME
SETS_OF_BOOKS_SHORT_NAME
PARENT_CONTRACT_COMMITMENT_ID
PARENT_ACCOUNT_LINE_ID
RELEASE_CONTRACT_COMMITMENT_ID
ORGANIZATION_ID
RELEASE_ACCOUNT_LINE_ID
SET_OF_BOOKS_ID