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

MATERIALIZED VIEW: APPS.CSD_RO_PER_ITEM_MV

Object Details
Object Name: CSD_RO_PER_ITEM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: CSD_RO_PER_ITEM_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FORCE
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

CSD_REPAIR_ORDERS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TOTAL_RO_COUNT NUMBER

RO_INVENTORY_ITEM_ID NUMBER
Yes
Query Text

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


SELECT TOTAL_RO_COUNT
,      RO_INVENTORY_ITEM_ID
FROM APPS.CSD_RO_PER_ITEM_MV;

Dependencies

[top of page]

APPS.CSD_RO_PER_ITEM_MV references the following:

SchemaAPPS
TableCSD_RO_PER_ITEM_MV
SchemaCSD
TableCSD_REPAIR_ORDERS_F
APPS.CSD_RO_PER_ITEM_MV is referenced by following:

SchemaAPPS
Materialized ViewCSD_DC_FREQ_SUM_MV
Materialized ViewCSD_SC_FREQ_SUM_MV