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

TABLE: IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES

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


IGC_CBC_ARCHIVE_MC_JE_BATCHES temporarily stores the multiple reporting currency values for journal entry batches that have been archived.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CBC_ARCHIVE_MC_JE_BAT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCBC_JE_BATCH_ID
ColumnREPORTING_SET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CBC_JE_BATCH_ID NUMBER (15) Yes Journal entry batch defining column
REPORTING_SET_OF_BOOKS_ID NUMBER (15) Yes Reporting Set of Books defining column
REPORTING_CURRENCY_CODE VARCHAR2 (15) Yes Currency code for reporting Set of Books
RUNNING_TOTAL_DR NUMBER

Batch running total debit, entered currency
RUNNING_TOTAL_CR NUMBER

Batch running total credit, entered currency
CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CONVERSION_DATE DATE

Currency conversion date
CONVERSION_RATE NUMBER

Currency conversion rate
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT CBC_JE_BATCH_ID
,      REPORTING_SET_OF_BOOKS_ID
,      REPORTING_CURRENCY_CODE
,      RUNNING_TOTAL_DR
,      RUNNING_TOTAL_CR
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CREATION_DATE
,      CREATED_BY
FROM IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES;

Dependencies

[top of page]

IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES does not reference any database object

IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES is referenced by following:

SchemaAPPS
SynonymIGC_CBC_ARCHIVE_MC_JE_BATCHES