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

VIEW: APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS

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

View Type

A Business Intelligence System view


IGCBV_MC_REL_SUM_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release summaryl payment forecast based on the set of books.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REL_SUM_PF_FUNCTIONAL_AMOUNT NUMBER

REL_SUMMARY_PF_ENCUMBER_AMOUNT NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

PERIOD_YEAR NUMBER (15) Yes
SETS_OF_BOOKS_NAME VARCHAR2 (30) Yes
SETS_OF_BOOKS_SHORT_NAME VARCHAR2 (20) Yes
PARENT_CONTRACT_COMMITMENT_ID NUMBER

PARENT_ACCOUNT_LINE_ID NUMBER

RELEASE_CONTRACT_COMMITMENT_ID NUMBER
Yes
ORGANIZATION_ID NUMBER (15) Yes
RELEASE_ACCOUNT_LINE_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
Query Text

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


SELECT REL_SUM_PF_FUNCTIONAL_AMOUNT
,      REL_SUMMARY_PF_ENCUMBER_AMOUNT
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      PERIOD_YEAR
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      PARENT_CONTRACT_COMMITMENT_ID
,      PARENT_ACCOUNT_LINE_ID
,      RELEASE_CONTRACT_COMMITMENT_ID
,      ORGANIZATION_ID
,      RELEASE_ACCOUNT_LINE_ID
,      SET_OF_BOOKS_ID
FROM APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS;

Dependencies

[top of page]

APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS references the following:

SchemaAPPS
SynonymGL_PERIODS
SynonymGL_SETS_OF_BOOKS_11I
SynonymIGC_CC_ACCT_LINES
SynonymIGC_CC_DET_PF
SynonymIGC_CC_MC_DET_PF
SynonymIGC_CC_PERIODS_ALL

APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS is not referenced by any database object