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

MATERIALIZED VIEW: APPS.HRI_MDP_BEN_ELIGENRL_RPTP_MV

Object Details
Object Name: HRI_MDP_BEN_ELIGENRL_RPTP_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: HRI_MDP_BEN_ELIGENRL_RPTP_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_CS_CO_RPGH_PIRG_CT

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ASND_LF_EVT_DT DATE

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

PL_TYP_ID NUMBER (15)
RPTGTYP_ID NUMBER (15)
ELIG_COUNT NUMBER

ENRT_COUNT NUMBER

ENRT_PER NUMBER

WAIVE_EXPL_COUNT NUMBER

WAIVE_DFLT_COUNT NUMBER

WAIVE_TOTAL_COUNT NUMBER

WAIVE_EXPL_PER NUMBER

WAIVE_DFLT_PER NUMBER

WAIVE_TOTAL_PER NUMBER

Query Text

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


SELECT ASND_LF_EVT_DT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PL_TYP_ID
,      RPTGTYP_ID
,      ELIG_COUNT
,      ENRT_COUNT
,      ENRT_PER
,      WAIVE_EXPL_COUNT
,      WAIVE_DFLT_COUNT
,      WAIVE_TOTAL_COUNT
,      WAIVE_EXPL_PER
,      WAIVE_DFLT_PER
,      WAIVE_TOTAL_PER
FROM APPS.HRI_MDP_BEN_ELIGENRL_RPTP_MV;

Dependencies

[top of page]

APPS.HRI_MDP_BEN_ELIGENRL_RPTP_MV references the following:

SchemaAPPS
SynonymHRI_CS_COMPOBJ_CT
SynonymHRI_CS_CO_RPGH_PIRG_CT
SynonymHRI_MB_BEN_ELIGENRL_EVNT_CT
TableHRI_MDP_BEN_ELIGENRL_RPTP_MV
SchemaHRI
TableHRI_CS_COMPOBJ_CT
TableHRI_CS_CO_RPGH_PIRG_CT
TableHRI_MB_BEN_ELIGENRL_EVNT_CT

APPS.HRI_MDP_BEN_ELIGENRL_RPTP_MV is not referenced by any database object