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


TABLE: APPS.CSD_DC_FREQ_SUM_MV

Object Details
Object Name: CSD_DC_FREQ_SUM_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_CSD_DC_FREQ_SUM_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("RO_INVENTORY_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("TOTAL_RO_COUNT")
ColumnSYS_OP_MAP_NONNULL("DIAGNOSTIC_CODE_ID")
ColumnSYS_OP_MAP_NONNULL("DIAGNOSTIC_ITEM_ID")
Columns
Name Datatype Length Mandatory Comments
RO_INVENTORY_ITEM_ID NUMBER
Yes
TOTAL_RO_COUNT NUMBER

DIAGNOSTIC_CODE_ID NUMBER
Yes
DIAGNOSTIC_ITEM_ID NUMBER

DC_ONLY_RO_COUNT NUMBER

Query Text

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


SELECT RO_INVENTORY_ITEM_ID
,      TOTAL_RO_COUNT
,      DIAGNOSTIC_CODE_ID
,      DIAGNOSTIC_ITEM_ID
,      DC_ONLY_RO_COUNT
FROM APPS.CSD_DC_FREQ_SUM_MV;

Dependencies

[top of page]

APPS.CSD_DC_FREQ_SUM_MV does not reference any database object

APPS.CSD_DC_FREQ_SUM_MV is referenced by following:

SchemaAPPS
ViewCSD_DC_FREQUENCY_V
Materialized ViewCSD_DC_FREQ_SUM_MV