VIEW: APPS.IGCFV_MC_REL_DET_PAY_FORECASTS

Source

View Text - Preformatted

SELECT CCDPF.CC_DET_PF_LINE_NUM RELEASE_DETAIL_PF_LINE_NUMBER, IGC_CC_MC_DET_PF.CC_DET_PF_FUNC_AMT REL_DET_PF_FUNCTIONAL_AMOUNT, IGC_CC_MC_DET_PF.CC_DET_PF_ENCMBRNC_AMT REL_DET_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, IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER, CCDPFP.CC_DET_PF_LINE_NUM PARENT_DETAIL_PF_LINE_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, CCDPF.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID, CCDPF.PARENT_DET_PF_LINE_ID PARENT_DETAIL_PF_LINE_ID, CCDPF.CC_ACCT_LINE_ID RELEASE_ACCOUNT_LINE_ID, IGC_CC_MC_DET_PF.CC_DET_PF_LINE_ID RELEASE_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,IGC_CC_ACCT_LINES IGCCALP,IGC_CC_DET_PF CCDPFP 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 AND IGCCAL.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID AND CCDPF.PARENT_DET_PF_LINE_ID=CCDPFP.CC_DET_PF_LINE_ID AND IGCCAL.PARENT_ACCT_LINE_ID IS NOT NULL AND CCDPF.PARENT_DET_PF_LINE_ID IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT CCDPF.CC_DET_PF_LINE_NUM RELEASE_DETAIL_PF_LINE_NUMBER
, IGC_CC_MC_DET_PF.CC_DET_PF_FUNC_AMT REL_DET_PF_FUNCTIONAL_AMOUNT
, IGC_CC_MC_DET_PF.CC_DET_PF_ENCMBRNC_AMT REL_DET_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
, IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER
, CCDPFP.CC_DET_PF_LINE_NUM PARENT_DETAIL_PF_LINE_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
, CCDPF.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID
, CCDPF.PARENT_DET_PF_LINE_ID PARENT_DETAIL_PF_LINE_ID
, CCDPF.CC_ACCT_LINE_ID RELEASE_ACCOUNT_LINE_ID
, IGC_CC_MC_DET_PF.CC_DET_PF_LINE_ID RELEASE_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
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_DET_PF CCDPFP
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
AND IGCCAL.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID
AND CCDPF.PARENT_DET_PF_LINE_ID=CCDPFP.CC_DET_PF_LINE_ID
AND IGCCAL.PARENT_ACCT_LINE_ID IS NOT NULL
AND CCDPF.PARENT_DET_PF_LINE_ID IS NOT NULL WITH READ ONLY