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

MATERIALIZED VIEW: APPS.HRI_MDP_BEN_ENRLACTN_PGM_MV

Object Details
Object Name: HRI_MDP_BEN_ENRLACTN_PGM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: HRI_MDP_BEN_ENRLACTN_PGM_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_COMPOBJ_CT

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SSPND_COUNT NUMBER

ACTN_ITEM_IND NUMBER

ASND_LF_EVT_DT DATE

ACTN_TYP_CD VARCHAR2 (30)
PGM_ID NUMBER (15)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

Query Text

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


SELECT SSPND_COUNT
,      ACTN_ITEM_IND
,      ASND_LF_EVT_DT
,      ACTN_TYP_CD
,      PGM_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM APPS.HRI_MDP_BEN_ENRLACTN_PGM_MV;

Dependencies

[top of page]

APPS.HRI_MDP_BEN_ENRLACTN_PGM_MV references the following:

SchemaAPPS
SynonymHRI_CS_COMPOBJ_CT
SynonymHRI_MB_BEN_ENRLACTN_CT
TableHRI_MDP_BEN_ENRLACTN_PGM_MV
SchemaHRI
TableHRI_CS_COMPOBJ_CT
TableHRI_MB_BEN_ENRLACTN_CT

APPS.HRI_MDP_BEN_ENRLACTN_PGM_MV is not referenced by any database object