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

TABLE: IGC.IGC_CC_MC_HEADERS

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


IGC_CC_MC_HEADERS stores reporting currency information for each contract in the IGC_CC_HEADERS table. There is an optional one to many relationship between IGC_CC_HEADERS and this table. For each contract, there can be several lines in the IGC_CC_MC_HEADERS table with the same CC_HEADER_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_HEADERS 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_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_HEADER_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CC_HEADER_ID NUMBER
Yes Contract commitment defining column
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting Set of Books defining column
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_HEADER_ID
,      SET_OF_BOOKS_ID
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
FROM IGC.IGC_CC_MC_HEADERS;

Dependencies

[top of page]

IGC.IGC_CC_MC_HEADERS does not reference any database object

IGC.IGC_CC_MC_HEADERS is referenced by following:

SchemaAPPS
SynonymIGC_CC_MC_HEADERS