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

TABLE: IGC.IGC_CC_ARC_MC_DET_PF_HIST

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


IGC_CC_ARC_MC_DET_PF_HIST temporarily stores multiple reporting currency information on detail payment forecast 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_DET_PF_HIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCC_DET_PF_VERSION_NUM
ColumnCC_DET_PF_LINE_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CC_DET_PF_LINE_ID NUMBER
Yes Detail payment forecast line defining column
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting Set of Books defining column
CC_DET_PF_FUNC_AMT NUMBER

Detail payment forecast functional amount to be converted
CC_DET_PF_ENCMBRNC_AMT NUMBER

Detail payment forecast encumbrance amount to be converted
CC_DET_PF_VERSION_NUM NUMBER
Yes Contract commitment version number
CC_DET_PF_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
Query Text

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


SELECT CC_DET_PF_LINE_ID
,      SET_OF_BOOKS_ID
,      CC_DET_PF_FUNC_AMT
,      CC_DET_PF_ENCMBRNC_AMT
,      CC_DET_PF_VERSION_NUM
,      CC_DET_PF_VERSION_ACTION
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
FROM IGC.IGC_CC_ARC_MC_DET_PF_HIST;

Dependencies

[top of page]

IGC.IGC_CC_ARC_MC_DET_PF_HIST does not reference any database object

IGC.IGC_CC_ARC_MC_DET_PF_HIST is referenced by following:

SchemaIGC
ViewIGC_CC_ARC_MC_DET_PF_HIST#