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

VIEW: APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES

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

View Type

A Business Intelligence System view


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
RELEASE_ACCOUNT_LINE_NUMBER NUMBER
Yes
RELEASE_ACCT_FUNCTIONAL_AMOUNT NUMBER

REL_ACCT_ENCUMBRANCE_AMOUNT NUMBER

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
PARENT_CONTRACT_COMMITMENT_ID NUMBER

PARENT_ACCOUNT_LINE_ID NUMBER

RELEASE_CONTRACT_COMMITMENT_ID NUMBER
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 RELEASE_ACCOUNT_LINE_NUMBER
,      RELEASE_ACCT_FUNCTIONAL_AMOUNT
,      REL_ACCT_ENCUMBRANCE_AMOUNT
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      PARENT_CONTRACT_COMMITMENT_ID
,      PARENT_ACCOUNT_LINE_ID
,      RELEASE_CONTRACT_COMMITMENT_ID
,      RELEASE_ACCOUNT_LINE_ID
,      SET_OF_BOOKS_ID
FROM APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES;

Dependencies

[top of page]

APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES references the following:

SchemaAPPS
SynonymGL_SETS_OF_BOOKS_11I
SynonymIGC_CC_ACCT_LINES
SynonymIGC_CC_MC_ACCT_LINES

APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES is not referenced by any database object