VIEW: APPS.IGCFV_MC_REL_SUM_PAY_FORECASTS

Source

View Text - Preformatted

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, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER, IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, ORU.NAME ORGANIZATION_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 RELEASE_ACCOUNT_LINE_ID, IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID SET_OF_BOOKS_ID FROM IGC_CC_ACCT_LINES IGCCAL,HR_ALL_ORGANIZATION_UNITS ORU,IGC_CC_PERIODS_ALL CCP,GL_PERIODS GL_PERIODS,IGC_CC_HEADERS_ALL IGC_CCH,GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS,IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF,IGC_CC_ACCT_LINES IGCCALP,IGC_CC_HEADERS_ALL IGC_CCHP,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 IGCCAL.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 and igc_cc_mc_det_pf.set_of_books_id= gl_sets_of_books.set_of_books_id 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, oru.name,gl_periods.period_year, igccal.parent_header_id, igc_cchp.cc_num,igccal.parent_acct_line_id, igccalp.cc_acct_line_num, igccal.cc_header_id,igc_cch.cc_num, igccal.cc_acct_line_id , igccal.cc_acct_line_num, igc_cc_mc_det_pf.conversion_type, igc_cc_mc_det_pf.conversion_date, igc_cc_mc_det_pf.conversion_rate WITH READ ONLY

View Text - HTML Formatted

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
, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER
, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER
, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, ORU.NAME ORGANIZATION_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 RELEASE_ACCOUNT_LINE_ID
, IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM IGC_CC_ACCT_LINES IGCCAL
, HR_ALL_ORGANIZATION_UNITS ORU
, IGC_CC_PERIODS_ALL CCP
, GL_PERIODS GL_PERIODS
, IGC_CC_HEADERS_ALL IGC_CCH
, GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS
, IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_HEADERS_ALL IGC_CCHP
, 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 IGCCAL.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
AND IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID= GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID 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
, ORU.NAME
, GL_PERIODS.PERIOD_YEAR
, IGCCAL.PARENT_HEADER_ID
, IGC_CCHP.CC_NUM
, IGCCAL.PARENT_ACCT_LINE_ID
, IGCCALP.CC_ACCT_LINE_NUM
, IGCCAL.CC_HEADER_ID
, IGC_CCH.CC_NUM
, IGCCAL.CC_ACCT_LINE_ID
, IGCCAL.CC_ACCT_LINE_NUM
, IGC_CC_MC_DET_PF.CONVERSION_TYPE
, IGC_CC_MC_DET_PF.CONVERSION_DATE
, IGC_CC_MC_DET_PF.CONVERSION_RATE WITH READ ONLY