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

MATERIALIZED VIEW: APPS.HRI_MDP_SUP_WCNT_SUP_MV

Object Details
Object Name: HRI_MDP_SUP_WCNT_SUP_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: HRI_MDP_SUP_WCNT_SUP_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_MAP_SUP_WRKFC

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

WKTH_WKTYP_SK_FK VARCHAR2 (240)
WKTH_WKTYP_CODE VARCHAR2 (30)
TOTAL_HEADCOUNT NUMBER

DIRECT_HEADCOUNT NUMBER

TOTAL_PRIMARY_ASG_CNT NUMBER

DIRECT_PRIMARY_ASG_CNT NUMBER

TOTAL_PRIMARY_ASG_POW NUMBER

DIRECT_PRIMARY_ASG_POW NUMBER

TOTAL_EXTN_ASG_CNT NUMBER

TOTAL_PRIMARY_EXTN_POW NUMBER

DIRECT_PRIMARY_EXTN_POW NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      WKTH_WKTYP_SK_FK
,      WKTH_WKTYP_CODE
,      TOTAL_HEADCOUNT
,      DIRECT_HEADCOUNT
,      TOTAL_PRIMARY_ASG_CNT
,      DIRECT_PRIMARY_ASG_CNT
,      TOTAL_PRIMARY_ASG_POW
,      DIRECT_PRIMARY_ASG_POW
,      TOTAL_EXTN_ASG_CNT
,      TOTAL_PRIMARY_EXTN_POW
,      DIRECT_PRIMARY_EXTN_POW
FROM APPS.HRI_MDP_SUP_WCNT_SUP_MV;

Dependencies

[top of page]

APPS.HRI_MDP_SUP_WCNT_SUP_MV references the following:

SchemaAPPS
SynonymHRI_MAP_SUP_WRKFC
TableHRI_MDP_SUP_WCNT_SUP_MV
SchemaHRI
TableHRI_MAP_SUP_WRKFC
APPS.HRI_MDP_SUP_WCNT_SUP_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_DBI_WMV_COUNT_MV
Materialized ViewHRI_MDP_SUP_WMV_SUP_MV
Materialized ViewHRI_MDS_SUP_WMV_SUP_MV