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_DET_PAY_FORECASTS

Object Details

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

View Type

A Business Intelligence System view

IGCBV_CC_REL_DET_PAY_FORECASTS display a break out of the contract commitment release summary payment forecast into the amounts that are expected to be paid out. Payment forecast is shown at any detail level desired as determined by the payment forecast date.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
RELEASE_DETAIL_PF_LINE_NUMBER	NUMBER	Yes
RELEASE_DETAIL_PF_DATE	DATE	Yes
REL_DETAIL_PF_ENTERED_AMOUNT	NUMBER
REL_DET_PF_FUNCTIONAL_AMOUNT	NUMBER
REL_DETAIL_PF_BILLED_AMOUNT	NUMBER
REL_DET_PF_UNBILLED_AMOUNT	NUMBER
PARENT_ACCOUNT_LINE_ID	NUMBER
PARENT_DETAIL_PF_LINE_ID	NUMBER
RELEASE_ACCOUNT_LINE_ID	NUMBER	Yes
RELEASE_DETAIL_PF_LINE_ID	NUMBER	Yes
LAST_UPDATE_DATE	DATE	Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE	Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT RELEASE_DETAIL_PF_LINE_NUMBER
,      RELEASE_DETAIL_PF_DATE
,      REL_DETAIL_PF_ENTERED_AMOUNT
,      REL_DET_PF_FUNCTIONAL_AMOUNT
,      REL_DETAIL_PF_BILLED_AMOUNT
,      REL_DET_PF_UNBILLED_AMOUNT
,      PARENT_ACCOUNT_LINE_ID
,      PARENT_DETAIL_PF_LINE_ID
,      RELEASE_ACCOUNT_LINE_ID
,      RELEASE_DETAIL_PF_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCBV_CC_REL_DET_PAY_FORECASTS;

Dependencies

[top of page]

APPS.IGCBV_CC_REL_DET_PAY_FORECASTS references the following:

APPS: IGC_CC_DET_PF

APPS.IGCBV_CC_REL_DET_PAY_FORECASTS is not referenced by any database object