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_DETAIL_PAY_FORECASTS

Object Details

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

View Type

A Business Intelligence System view

IGCBV_CC_DETAIL_PAY_FORECASTS display a break out of the contract commitment 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 which is determined by the general ledger period.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DETAIL_PF_LINE_NUMBER	NUMBER		Yes
DETAIL_PF_DATE	DATE		Yes
DETAIL_PF_ENTERED_AMOUNT	NUMBER
DETAIL_PF_FUNCTIONAL_AMOUNT	NUMBER
DETAIL_PF_BILLED_AMOUNT	NUMBER
DETAIL_PF_UNBILLED_AMOUNT	NUMBER
DETAIL_PF_ENCUMBER_AMOUNT	NUMBER
_LA:DETAIL_PF_ENCUMBR_STATUS	CHAR	(75)
DETAIL_PF_LAST_ENCUMBER_DATE	DATE
ACCOUNT_LINE_ID	NUMBER		Yes
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 DETAIL_PF_LINE_NUMBER
,      DETAIL_PF_DATE
,      DETAIL_PF_ENTERED_AMOUNT
,      DETAIL_PF_FUNCTIONAL_AMOUNT
,      DETAIL_PF_BILLED_AMOUNT
,      DETAIL_PF_UNBILLED_AMOUNT
,      DETAIL_PF_ENCUMBER_AMOUNT
,      _LA:DETAIL_PF_ENCUMBR_STATUS
,      DETAIL_PF_LAST_ENCUMBER_DATE
,      ACCOUNT_LINE_ID
,      DETAIL_PF_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCBV_CC_DETAIL_PAY_FORECASTS;

Dependencies

[top of page]

APPS.IGCBV_CC_DETAIL_PAY_FORECASTS references the following:

APPS: IGC_CC_DET_PF

APPS.IGCBV_CC_DETAIL_PAY_FORECASTS is not referenced by any database object