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


TABLE: APPS.HRI_MDP_BEN_ELCTN_PGMV_MV

Object Details
Object Name: HRI_MDP_BEN_ELCTN_PGMV_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_MDP_BEN_ELCTN_PGMV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnASND_LF_EVT_DT
ColumnPGM_ID
Columns
Name Datatype Length Mandatory Comments
REC_TYPE VARCHAR2 (8)
ASND_LF_EVT_DT DATE

PGM_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
,      PGM_ID
,      CNT_ALL
FROM APPS.HRI_MDP_BEN_ELCTN_PGMV_MV;

Dependencies

[top of page]

APPS.HRI_MDP_BEN_ELCTN_PGMV_MV does not reference any database object

APPS.HRI_MDP_BEN_ELCTN_PGMV_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_BEN_ELCTN_PGMV_MV