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

MATERIALIZED VIEW: APPS.ISC_FS_002_MV

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

ISC_FS_001_MV
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RECORD_TYPE VARCHAR2 (8)
Record type idendifier. GROUP or RESOURCE
RG_ID NUMBER

JTF RESOURCE GROUP Identifier
PRG_ID NUMBER

Parent JTF RESOURCE GROUP Identifier
PARENT_PRG_ID NUMBER

Parent of Parent JTF RESOURCE GROUP Identifier
IMMEDIATE_PARENT_FLAG VARCHAR2 (1)
Indicates whether the value in PRG_ID is the identifier of immediate parent group
MV_COUNT NUMBER

Row Count
Query Text

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


SELECT RECORD_TYPE
,      RG_ID
,      PRG_ID
,      PARENT_PRG_ID
,      IMMEDIATE_PARENT_FLAG
,      MV_COUNT
FROM APPS.ISC_FS_002_MV;

Dependencies

[top of page]

APPS.ISC_FS_002_MV references the following:

SchemaAPPS
TableISC_FS_001_MV
Materialized ViewISC_FS_001_MV
TableISC_FS_002_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES
APPS.ISC_FS_002_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_FS_004_MV
Materialized ViewISC_FS_006_MV
Materialized ViewISC_FS_008_MV
Materialized ViewISC_FS_010_MV
Materialized ViewISC_FS_012_MV
Materialized ViewISC_FS_013_MV
Materialized ViewISC_FS_014_MV
Materialized ViewISC_FS_015_MV
Materialized ViewISC_FS_016_MV
Materialized ViewISC_FS_017_MV
Materialized ViewISC_FS_018_MV
Materialized ViewISC_FS_019_MV
Materialized ViewISC_FS_020_MV