eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGCFV_MC_DETAIL_PAY_FORECASTS

Source

View Text - Preformatted


SELECT CCDPF.CC_DET_PF_LINE_NUM DETAIL_PF_LINE_NUMBER, IGC_CC_MC_DET_PF.CC_DET_PF_FUNC_AMT DETAIL_PF_FUNCTIONAL_AMOUNT, IGC_CC_MC_DET_PF.CC_DET_PF_ENCMBRNC_AMT DETAIL_PF_ENCUMBRANCE_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_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER, CCDPF.CC_ACCT_LINE_ID ACCOUNT_LINE_ID, IGC_CC_MC_DET_PF.CC_DET_PF_LINE_ID DETAIL_PF_LINE_ID, IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID SET_OF_BOOKS_ID FROM GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS,IGC_CC_DET_PF CCDPF,IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF,IGC_CC_ACCT_LINES IGCCAL WHERE IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID AND 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 WITH READ ONLY

View Text - HTML Formatted

SELECT CCDPF.CC_DET_PF_LINE_NUM DETAIL_PF_LINE_NUMBER
, IGC_CC_MC_DET_PF.CC_DET_PF_FUNC_AMT DETAIL_PF_FUNCTIONAL_AMOUNT
, IGC_CC_MC_DET_PF.CC_DET_PF_ENCMBRNC_AMT DETAIL_PF_ENCUMBRANCE_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_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER
, CCDPF.CC_ACCT_LINE_ID ACCOUNT_LINE_ID
, IGC_CC_MC_DET_PF.CC_DET_PF_LINE_ID DETAIL_PF_LINE_ID
, IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS
, IGC_CC_DET_PF CCDPF
, IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF
, IGC_CC_ACCT_LINES IGCCAL
WHERE IGC_CC_MC_DET_PF.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID
AND 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 WITH READ ONLY