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

VIEW: APPS.IGCFV_MC_RELEASES

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

View Type

A Business Intelligence System view


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
RELEASE_CONTRACT_NUMBER VARCHAR2 (20) Yes
RELEASE_VERSION_NUMBER NUMBER
Yes
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

SETS_OF_BOOKS_NAME VARCHAR2 (30) Yes
SETS_OF_BOOKS_SHORT_NAME VARCHAR2 (20) Yes
RATE_NAME VARCHAR2 (30)
RATE_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_NAME VARCHAR2 (240) Yes
PARENT_CONTRACT_NUMBER VARCHAR2 (20) Yes
ORGANIZATION_ID NUMBER (15) Yes
PARENT_CONTRACT_COMMITMENT_ID NUMBER

RELEASE_CONTRACT_COMMITMENT_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
Query Text

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


SELECT RELEASE_CONTRACT_NUMBER
,      RELEASE_VERSION_NUMBER
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      RATE_NAME
,      RATE_DESCRIPTION
,      ORGANIZATION_NAME
,      PARENT_CONTRACT_NUMBER
,      ORGANIZATION_ID
,      PARENT_CONTRACT_COMMITMENT_ID
,      RELEASE_CONTRACT_COMMITMENT_ID
,      SET_OF_BOOKS_ID
FROM APPS.IGCFV_MC_RELEASES;

Dependencies

[top of page]

APPS.IGCFV_MC_RELEASES references the following:

SchemaAPPS
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_SETS_OF_BOOKS_11I
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymIGC_CC_HEADERS_ALL
SynonymIGC_CC_MC_HEADERS

APPS.IGCFV_MC_RELEASES is not referenced by any database object