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

MATERIALIZED VIEW: APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV

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

HRI_CAL_SNPSHT_WCNT_CHG
HRI_CAL_SNPSHT_WCNT_CHG
HRI_CL_PER_SNAP_PRDS_CT
HRI_CL_PER_SNAP_PRDS_CT
HRI_MDP_SUP_WCNT_TERM_ASG_MV
     HRI_MAP_SUP_WRKFC_ASG

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_DATE DATE

PERIOD_TYPE VARCHAR2 (30)
COMPARISON_TYPE VARCHAR2 (30)
WKTH_WKTYP_SK_FK VARCHAR2 (40)
DIRECT_IND NUMBER

GEO_AREA_CODE VARCHAR2 (40)
GEO_COUNTRY_CODE VARCHAR2 (70)
POW_DAYS NUMBER

POW_MONTHS NUMBER

SEPARATION_HDC NUMBER

SEP_INVOL_HDC NUMBER

SEP_VOL_HDC NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_DATE
,      PERIOD_TYPE
,      COMPARISON_TYPE
,      WKTH_WKTYP_SK_FK
,      DIRECT_IND
,      GEO_AREA_CODE
,      GEO_COUNTRY_CODE
,      POW_DAYS
,      POW_MONTHS
,      SEPARATION_HDC
,      SEP_INVOL_HDC
,      SEP_VOL_HDC
FROM APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV;

Dependencies

[top of page]

APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV references the following:

SchemaAPPS
SynonymHRI_CAL_SNPSHT_WCNT_CHG
SynonymHRI_CL_PER_SNAP_PRDS_CT
TableHRI_MDP_SUP_WCNT_TERM_ASG_MV
Materialized ViewHRI_MDP_SUP_WCNT_TERM_ASG_MV
TableHRI_MDS_SUP_WCNT_TERM_CTR_MV
SchemaHRI
TableHRI_CAL_SNPSHT_WCNT_CHG
TableHRI_CL_PER_SNAP_PRDS_CT

APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV is not referenced by any database object