View: IGCBV_MC_DETAIL_PAY_FORECASTS

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

View Text

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
, 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 GL_SETS_OF_BOOKS
, IGC_CC_DET_PF CCDPF
, IGC_CC_MC_DET_PF IGC_CC_MC_DET_PF
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 WITH READ ONLY

Columns