[Home] [Help]
[Dependency Information]
MATERIALIZED VIEW: APPS.ISC_FS_001_MV
Object Details
Object Name: | ISC_FS_001_MV |
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
M-View Details
Container: | ISC_FS_001_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:
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES
[View Source Query]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
GCOUNT |
NUMBER |
|
|
Row Count |
GROUP_ID |
NUMBER |
|
Yes |
JTF RESOURCE GROUP Identifier |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT GCOUNT
, GROUP_ID
FROM APPS.ISC_FS_001_MV;
Dependencies
[top of page]
APPS.ISC_FS_001_MV references the following:
-
APPS
-
ISC_FS_001_MV
-
JTF
-
JTF_RS_GROUPS_DENORM
-
JTF_RS_GROUP_USAGES
APPS.ISC_FS_001_MV is referenced by following:
-
APPS
-
ISC_FS_002_MV