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

TABLE: IMC.IMC_REPORTS_TEMPINFO

Object Details
Object Name: IMC_REPORTS_TEMPINFO
Object Type: TABLE
Owner: IMC
Subobject Name:
Status: VALID


This is an intermediary table populated during the concurrent processing for Reports summarization. This table might not contain the latest information, as its serves as a temporary storage only. IMC_REPORTS_SUMMARY is the only table used by Reports.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IMC_REPORTS_TEMPINFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnREPORT_NAME
ColumnREPORT_TYPE
IMC_REPORTS_TEMPINFO_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnREPORT_NAME
ColumnPARENT_CATEGORY
Columns
Name Datatype Length Mandatory Comments
REPORT_NAME VARCHAR2 (30)
Report Name
REPORT_TYPE VARCHAR2 (5)
Report Type
CATEGORY VARCHAR2 (80)
Various categories under which the party records can be grouped, for each report
PARENT_CATEGORY VARCHAR2 (30)
Parent Category to the Category value
PER_CNT NUMBER

Person Count
PER_PCT NUMBER

Person Percentage
REL_CNT NUMBER

Relationship Count
REL_PCT NUMBER

Relationship Percentage
ORG_CNT NUMBER

Organization Count
ORG_PCT NUMBER

Organization Percentage
TOTAL_CNT NUMBER

Total Count
TOTAL_PCT NUMBER

Total Percentage
TIME_STAMP DATE

Time Stamp information
Query Text

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


SELECT REPORT_NAME
,      REPORT_TYPE
,      CATEGORY
,      PARENT_CATEGORY
,      PER_CNT
,      PER_PCT
,      REL_CNT
,      REL_PCT
,      ORG_CNT
,      ORG_PCT
,      TOTAL_CNT
,      TOTAL_PCT
,      TIME_STAMP
FROM IMC.IMC_REPORTS_TEMPINFO;

Dependencies

[top of page]

IMC.IMC_REPORTS_TEMPINFO does not reference any database object

IMC.IMC_REPORTS_TEMPINFO is referenced by following:

SchemaIMC
ViewIMC_REPORTS_TEMPINFO#