VIEW: APPS.IGCFV_CC_DETAIL_PAY_FORECASTS

Source

View Text - Preformatted

SELECT CCDPF.CC_DET_PF_LINE_NUM DETAIL_PF_LINE_NUMBER, CCDPF.CC_DET_PF_DATE DETAIL_PF_DATE, CCDPF.CC_DET_PF_ENTERED_AMT DETAIL_PF_ENTERED_AMOUNT, CCDPF.CC_DET_PF_FUNC_AMT DETAIL_PF_FUNCTIONAL_AMOUNT, CCDPF.CC_DET_PF_BILLED_AMT DETAIL_PF_BILLED_AMOUNT, CCDPF.CC_DET_PF_UNBILLED_AMT DETAIL_PF_UNBILLED_AMOUNT, CCDPF.CC_DET_PF_ENCMBRNC_AMT DETAIL_PF_ENCUMBER_AMOUNT, '_LA:CC_DET_PF_ENCMBRNC_STATUS:FND_LOOKUPS:IGC_CC_ENCUMBRANCE_STATUS:MEANING' , CCDPF.CC_DET_PF_ENCMBRNC_DATE DETAIL_PF_LAST_ENCUMBER_DATE, '_DF:IGC:IGC_CC_DET_PFS:CCDPF' , IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER, CCDPF.CC_ACCT_LINE_ID ACCOUNT_LINE_ID, CCDPF.CC_DET_PF_LINE_ID DETAIL_PF_LINE_ID, CCDPF.LAST_UPDATE_DATE LAST_UPDATE_DATE, CCDPF.LAST_UPDATED_BY LAST_UPDATED_BY, CCDPF.CREATION_DATE CREATION_DATE, CCDPF.CREATED_BY CREATED_BY FROM IGC_CC_DET_PF CCDPF,IGC_CC_ACCT_LINES IGCCAL WHERE 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
, CCDPF.CC_DET_PF_DATE DETAIL_PF_DATE
, CCDPF.CC_DET_PF_ENTERED_AMT DETAIL_PF_ENTERED_AMOUNT
, CCDPF.CC_DET_PF_FUNC_AMT DETAIL_PF_FUNCTIONAL_AMOUNT
, CCDPF.CC_DET_PF_BILLED_AMT DETAIL_PF_BILLED_AMOUNT
, CCDPF.CC_DET_PF_UNBILLED_AMT DETAIL_PF_UNBILLED_AMOUNT
, CCDPF.CC_DET_PF_ENCMBRNC_AMT DETAIL_PF_ENCUMBER_AMOUNT
, '_LA:CC_DET_PF_ENCMBRNC_STATUS:FND_LOOKUPS:IGC_CC_ENCUMBRANCE_STATUS:MEANING'
, CCDPF.CC_DET_PF_ENCMBRNC_DATE DETAIL_PF_LAST_ENCUMBER_DATE
, '_DF:IGC:IGC_CC_DET_PFS:CCDPF'
, IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER
, CCDPF.CC_ACCT_LINE_ID ACCOUNT_LINE_ID
, CCDPF.CC_DET_PF_LINE_ID DETAIL_PF_LINE_ID
, CCDPF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCDPF.LAST_UPDATED_BY LAST_UPDATED_BY
, CCDPF.CREATION_DATE CREATION_DATE
, CCDPF.CREATED_BY CREATED_BY
FROM IGC_CC_DET_PF CCDPF
, IGC_CC_ACCT_LINES IGCCAL
WHERE CCDPF.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID WITH READ ONLY