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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS

Object Details

Object Name:	IGCBV_CC_REL_SUM_PAY_FORECASTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGC.IGCBV_CC_REL_SUM_PAY_FORECASTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

IGCFV_CC_SUMMARY_PAY_FORECASTS display a break out of the contract commitment account line into the amounts that are expected to be paid out. The payment forecast is at the summary level.

[View Source]

Columns

Name	Datatype	Length	Mandatory
REL_SUMMARY_PF_ENTERED_AMOUNT	NUMBER
REL_SUM_PF_FUNCTIONAL_AMOUNT	NUMBER
REL_SUMMARY_PF_BILLED_AMOUNT	NUMBER
REL_SUMMARY_PF_UNBILLED_AMOUNT	NUMBER
RELEASE_SUM_PF_ENCUMBER_AMOUNT	NUMBER
PERIOD_YEAR	NUMBER	(15)	Yes
PARENT_CONTRACT_COMMITMENT_ID	NUMBER
PARENT_ACCOUNT_LINE_ID	NUMBER
ORGANIZATION_ID	NUMBER	(15)	Yes
RELEASE_CONTRACT_COMMITMENT_ID	NUMBER		Yes
RELEASE_ACCOUNT_LINE_ID	NUMBER		Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REL_SUMMARY_PF_ENTERED_AMOUNT
,      REL_SUM_PF_FUNCTIONAL_AMOUNT
,      REL_SUMMARY_PF_BILLED_AMOUNT
,      REL_SUMMARY_PF_UNBILLED_AMOUNT
,      RELEASE_SUM_PF_ENCUMBER_AMOUNT
,      PERIOD_YEAR
,      PARENT_CONTRACT_COMMITMENT_ID
,      PARENT_ACCOUNT_LINE_ID
,      ORGANIZATION_ID
,      RELEASE_CONTRACT_COMMITMENT_ID
,      RELEASE_ACCOUNT_LINE_ID
FROM APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS;

Dependencies

[top of page]

APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS references the following:

APPS: GL_PERIODS; IGC_CC_ACCT_LINES; IGC_CC_DET_PF; IGC_CC_PERIODS_ALL

APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS is not referenced by any database object