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


VIEW: APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS

Object Details
Object Name: IGCFV_CC_SUMMARY_PAY_FORECASTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGCFV_CC_SUMMARY_PAY_FORECASTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


IGCFV_CC_SUMMARY_PAY_FORECASTS displays 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 Comments
SUMMARY_PF_ENTERED_AMOUNT NUMBER

SUMMARY_PF_FUNCTIONAL_AMOUNT NUMBER

SUMMARY_PF_BILLED_AMOUNT NUMBER

SUMMARY_PF_UNBILLED_AMOUNT NUMBER

SUMMARY_PF_ENCUMBER_AMOUNT NUMBER

PERIOD_YEAR NUMBER (15) Yes
CONTRACT_COMMITMENT_NUMBER VARCHAR2 (20) Yes
ACCOUNT_LINE_NUMBER NUMBER
Yes
ORGANIZATION_NAME VARCHAR2 (240) Yes
ORGANIZATION_ID NUMBER (15) Yes
CONTRACT_COMMITMENT_ID NUMBER
Yes
ACCOUNT_LINE_ID NUMBER
Yes
Query Text

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


SELECT SUMMARY_PF_ENTERED_AMOUNT
,      SUMMARY_PF_FUNCTIONAL_AMOUNT
,      SUMMARY_PF_BILLED_AMOUNT
,      SUMMARY_PF_UNBILLED_AMOUNT
,      SUMMARY_PF_ENCUMBER_AMOUNT
,      PERIOD_YEAR
,      CONTRACT_COMMITMENT_NUMBER
,      ACCOUNT_LINE_NUMBER
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      CONTRACT_COMMITMENT_ID
,      ACCOUNT_LINE_ID
FROM APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS;

Dependencies

[top of page]

APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS references the following:

SchemaAPPS
SynonymGL_PERIODS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymIGC_CC_ACCT_LINES
SynonymIGC_CC_DET_PF
SynonymIGC_CC_HEADERS_ALL
SynonymIGC_CC_PERIODS_ALL

APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS is not referenced by any database object