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

MATERIALIZED VIEW: APPS.MTH_EQUIP_SHFT_DD_MV

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

MTH_EQUIPMENT_DENORM_D
MTH_EQUIPMENT_DENORM_D
MTH_EQUIPMENT_SHIFTS_D
MTH_EQUIPMENT_SHIFTS_D
MTH_SHIFT_GREGORIAN_DENORM_MV
     MTH_GREGORIAN_CALENDAR
     MTH_GREGORIAN_CALENDAR
     MTH_WORKDAY_SHIFTS_D
     MTH_WORKDAY_SHIFTS_D

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

DEPT_KEY NUMBER

DEPT_EFF_DATE DATE

CUST_LEVEL9_KEY NUMBER

CUST_LEVEL9_EFF_DATE DATE

EQUIP_CAL_TIME NUMBER

EQUIP_CAL_TIME_COUNT NUMBER

EQUIP_CAL_TIME_VAL NUMBER

EQUIP_CAL_TIME_VAL_COUNT NUMBER

EQUIP_SCH_TIME NUMBER

EQUIP_SCH_TIME_COUNT NUMBER

EQUIP_SCH_TIME_VAL NUMBER

EQUIP_SCH_TIME_VAL_COUNT NUMBER

TOTAL_COUNT NUMBER

Query Text

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


SELECT DAY_ID
,      CALENDAR_MONTH_ID
,      DEPT_KEY
,      DEPT_EFF_DATE
,      CUST_LEVEL9_KEY
,      CUST_LEVEL9_EFF_DATE
,      EQUIP_CAL_TIME
,      EQUIP_CAL_TIME_COUNT
,      EQUIP_CAL_TIME_VAL
,      EQUIP_CAL_TIME_VAL_COUNT
,      EQUIP_SCH_TIME
,      EQUIP_SCH_TIME_COUNT
,      EQUIP_SCH_TIME_VAL
,      EQUIP_SCH_TIME_VAL_COUNT
,      TOTAL_COUNT
FROM APPS.MTH_EQUIP_SHFT_DD_MV;

Dependencies

[top of page]

APPS.MTH_EQUIP_SHFT_DD_MV references the following:

SchemaAPPS
SynonymMTH_EQUIPMENT_DENORM_D
SynonymMTH_EQUIPMENT_SHIFTS_D
TableMTH_EQUIP_SHFT_DD_MV
TableMTH_SHIFT_GREGORIAN_DENORM_MV
Materialized ViewMTH_SHIFT_GREGORIAN_DENORM_MV
SchemaMTH
TableMTH_EQUIPMENT_DENORM_D
TableMTH_EQUIPMENT_SHIFTS_D
APPS.MTH_EQUIP_SHFT_DD_MV is referenced by following:

SchemaAPPS
Materialized ViewMTH_EQUIP_SHFT_PM_MV