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

MATERIALIZED VIEW: APPS.HRI_MDP_BEN_ELCTN_RPTGV_MV

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

HRI_MDP_BEN_ELCTN_RPTG_MV
     HRI_CS_CO_RPGH_PIRG_CT

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
REC_TYPE VARCHAR2 (8)
ASND_LF_EVT_DT DATE

RPTGTYP_ID NUMBER (15)
CNT_ALL NUMBER

Query Text

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


SELECT REC_TYPE
,      ASND_LF_EVT_DT
,      RPTGTYP_ID
,      CNT_ALL
FROM APPS.HRI_MDP_BEN_ELCTN_RPTGV_MV;

Dependencies

[top of page]

APPS.HRI_MDP_BEN_ELCTN_RPTGV_MV references the following:

SchemaAPPS
TableHRI_MDP_BEN_ELCTN_RPTGV_MV
TableHRI_MDP_BEN_ELCTN_RPTG_MV
Materialized ViewHRI_MDP_BEN_ELCTN_RPTG_MV

APPS.HRI_MDP_BEN_ELCTN_RPTGV_MV is not referenced by any database object