View: IGCFV_CC_REL_DET_PAY_FORECASTS

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

View Text

SELECT CCDPF.CC_DET_PF_LINE_NUM RELEASE_DETAIL_PF_LINE_NUMBER
, CCDPF.CC_DET_PF_DATE RELEASE_DETAIL_PF_DATE
, CCDPF.CC_DET_PF_ENTERED_AMT REL_DETAIL_PF_ENTERED_AMOUNT
, CCDPF.CC_DET_PF_FUNC_AMT REL_DET_PF_FUNCTIONAL_AMOUNT
, CCDPF.CC_DET_PF_BILLED_AMT REL_DETAIL_PF_BILLED_AMOUNT
, CCDPF.CC_DET_PF_UNBILLED_AMT REL_DET_PF_UNBILLED_AMOUNT
, '_DF:IGC:IGC_CC_DET_PFS:CCDPF' "_DF"
, 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
, 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
, CCDPF.CC_DET_PF_LINE_ID RELEASE_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
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_DET_PF CCDPFP
WHERE CCDPF.CC_ACCT_LINE_ID = IGCCAL.CC_ACCT_LINE_ID
AND CCDPF.PARENT_ACCT_LINE_ID = IGCCALP.CC_ACCT_LINE_ID
AND CCDPF.PARENT_DET_PF_LINE_ID = CCDPFP.CC_DET_PF_LINE_ID
AND CCDPF.PARENT_ACCT_LINE_ID IS NOT NULL
AND CCDPF.PARENT_DET_PF_LINE_ID IS NOT NULL WITH READ ONLY

Columns