[Home] [Help] [Dependency Information]
Object Name: | IGCFV_CC_REL_DET_PAY_FORECASTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGC.IGCFV_CC_REL_DET_PAY_FORECASTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
IGCFV_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.
Name | Datatype | Length | 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 | |||
_DF | CHAR | (28) | ||
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Yes | ||
PARENT_DETAIL_PF_LINE_NUMBER | NUMBER | Yes | ||
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Yes | ||
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). |
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
, _DF
, RELEASE_ACCOUNT_LINE_NUMBER
, PARENT_DETAIL_PF_LINE_NUMBER
, PARENT_ACCOUNT_LINE_NUMBER
, 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.IGCFV_CC_REL_DET_PAY_FORECASTS;
APPS.IGCFV_CC_REL_DET_PAY_FORECASTS is not referenced by any database object
|
|
|