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

MATERIALIZED VIEW: APPS.HRI_MDP_SUP_ABSNC_SUP_MV

Object Details
Object Name: HRI_MDP_SUP_ABSNC_SUP_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: HRI_MDP_SUP_ABSNC_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_MDP_SUP_ABSNC_CAT_MV
     HRI_MDP_SUP_ABSNC_OCC_CT

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_DATE DATE

DIRECT_RECORD_IND NUMBER

ABS_DRTN_DAYS NUMBER

ABS_DRTN_HRS NUMBER

ABS_DRTN_DAYS_PLND NUMBER

ABS_DRTN_DAYS_UNPLND NUMBER

ABS_DRTN_HRS_PLND NUMBER

ABS_DRTN_HRS_UNPLND NUMBER

ABS_START_BLNC NUMBER

ABS_NSTART_BLNC NUMBER

ABS_START_BLNC_PLND NUMBER

ABS_START_BLNC_UNPLND NUMBER

ABS_NSTART_BLNC_PLND NUMBER

ABS_NSTART_BLNC_UNPLND NUMBER

ABS_NTFCTN_DAYS_START_BLNC NUMBER

ABS_NTFCTN_DAYS_NSTART_BLNC NUMBER

ABS_NTFCTN_START_BLNC_PLND NUMBER

ABS_NTFCTN_START_BLNC_UNPLND NUMBER

ABS_NTFCTN_NSTART_BLNC_PLND NUMBER

ABS_NTFCTN_NSTART_BLNC_UNPLND NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_DATE
,      DIRECT_RECORD_IND
,      ABS_DRTN_DAYS
,      ABS_DRTN_HRS
,      ABS_DRTN_DAYS_PLND
,      ABS_DRTN_DAYS_UNPLND
,      ABS_DRTN_HRS_PLND
,      ABS_DRTN_HRS_UNPLND
,      ABS_START_BLNC
,      ABS_NSTART_BLNC
,      ABS_START_BLNC_PLND
,      ABS_START_BLNC_UNPLND
,      ABS_NSTART_BLNC_PLND
,      ABS_NSTART_BLNC_UNPLND
,      ABS_NTFCTN_DAYS_START_BLNC
,      ABS_NTFCTN_DAYS_NSTART_BLNC
,      ABS_NTFCTN_START_BLNC_PLND
,      ABS_NTFCTN_START_BLNC_UNPLND
,      ABS_NTFCTN_NSTART_BLNC_PLND
,      ABS_NTFCTN_NSTART_BLNC_UNPLND
FROM APPS.HRI_MDP_SUP_ABSNC_SUP_MV;

Dependencies

[top of page]

APPS.HRI_MDP_SUP_ABSNC_SUP_MV references the following:

SchemaAPPS
TableHRI_MDP_SUP_ABSNC_CAT_MV
Materialized ViewHRI_MDP_SUP_ABSNC_CAT_MV
TableHRI_MDP_SUP_ABSNC_SUP_MV

APPS.HRI_MDP_SUP_ABSNC_SUP_MV is not referenced by any database object