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


TABLE: APPS.ISC_FS_001_MV

Object Details
Object Name: ISC_FS_001_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_FS_001_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_ISC_FS_001_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("GROUP_ID")
ISC_FS_001_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGCOUNT
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 does not reference any database object

APPS.ISC_FS_001_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_FS_001_MV
Materialized ViewISC_FS_002_MV