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

TABLE: IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST

Object Details
Object Name: IGC_CC_ARC_MC_ACCT_LINE_HIST
Object Type: TABLE
Owner: IGC
FND Design Data: TableIGC.IGC_CC_ARC_MC_ACCT_LINE_HIST
Subobject Name:
Status: VALID


IGC_CC_ARC_MC_ACCT_LINE_HIST temporarily stores multiple reporting currency information on account line versions that have been archived.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_ARC_MC_ACCT_LINE_HIS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCC_ACCT_VERSION_NUM
ColumnCC_ACCT_LINE_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CC_ACCT_LINE_ID NUMBER
Yes Account line defining column
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting Set of Books defining column
CC_ACCT_FUNC_AMT NUMBER

Account line functional amount to be converted
CC_ACCT_ENCMBRNC_AMT NUMBER

Account line encumbrance amount to be converted
CC_ACCT_VERSION_NUM NUMBER
Yes Contract commitment version number
CC_ACCT_VERSION_ACTION VARCHAR2 (1) Yes Action corresponding to the creation of this version
CONVERSION_TYPE VARCHAR2 (30)
Conversion type used for converting between currencies
CONVERSION_DATE DATE

Conversion date used for converting the currencies
CONVERSION_RATE NUMBER

Conversion rate used for converting the currencies
CC_FUNC_WITHHELD_AMT NUMBER

Withheld Amount in the Functional Currency
Query Text

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


SELECT CC_ACCT_LINE_ID
,      SET_OF_BOOKS_ID
,      CC_ACCT_FUNC_AMT
,      CC_ACCT_ENCMBRNC_AMT
,      CC_ACCT_VERSION_NUM
,      CC_ACCT_VERSION_ACTION
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CC_FUNC_WITHHELD_AMT
FROM IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST;

Dependencies

[top of page]

IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST does not reference any database object

IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST is referenced by following:

SchemaAPPS
SynonymIGC_CC_ARC_MC_ACCT_LINE_HIST