[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: | FAST |
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:
-
APPS
-
CSD_RO_PER_ITEM_MV
-
CSD
-
CSD_REPAIR_ORDERS_F
APPS.CSD_RO_PER_ITEM_MV is referenced by following:
-
APPS
-
CSD_DC_FREQ_SUM_MV
-
CSD_SC_FREQ_SUM_MV