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

TABLE: IGC.IGC_CC_MC_DET_PF

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


IGC_CC_MC_DET_PF stores reporting currency information for each account line in the IGC_CC_DET_PF table. There is an optional one to many relationship between IGC_CC_DET_PF and this table. For each detail payment forecast line, there can be several lines in the IGC_CC_MC_DET_PF table with the same CC_DET_PF_LINE_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_DET_PF table corresponds with the number of Reporting Sets of Books that have been defined.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_MC_DET_PF_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX 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
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
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
FROM IGC.IGC_CC_MC_DET_PF;

Dependencies

[top of page]

IGC.IGC_CC_MC_DET_PF does not reference any database object

IGC.IGC_CC_MC_DET_PF is referenced by following:

SchemaIGC
ViewIGC_CC_MC_DET_PF#