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


TABLE: APPS.HRI_DBI_WMV_COUNT_MV

Object Details
Object Name: HRI_DBI_WMV_COUNT_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_DBI_WMV_COUNT_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_ID
ColumnCOUNT_TYPE
ColumnEFFECTIVE_DATE
Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_ID NUMBER

EFFECTIVE_DATE DATE

WMV_COUNT NUMBER

COUNT_TYPE CHAR (15)
Query Text

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


SELECT SUPERVISOR_ID
,      EFFECTIVE_DATE
,      WMV_COUNT
,      COUNT_TYPE
FROM APPS.HRI_DBI_WMV_COUNT_MV;

Dependencies

[top of page]

APPS.HRI_DBI_WMV_COUNT_MV does not reference any database object

APPS.HRI_DBI_WMV_COUNT_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_DBI_WMV_COUNT_MV