Skip to content

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

MATERIALIZED VIEW: APPS.MTH_SHIFT_GREGORIAN_DENORM_MV

Object Details
Object Name: MTH_SHIFT_GREGORIAN_DENORM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MTH_SHIFT_GREGORIAN_DENORM_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_GREGORIAN_CALENDAR
MTH_WORKDAY_SHIFTS_D

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SHIFT_WORKDAY_PK_KEY NUMBER
Yes
SHIFT_DATE DATE
Yes
PLANT_FK_KEY NUMBER
Yes
SYSTEM_FK_KEY NUMBER
Yes
FROM_DATE DATE

TO_DATE DATE

DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

CALENDAR_QUARTER_ID NUMBER

CALENDAR_YEAR_ID NUMBER

CALENDAR_MONTH_START_DATE DATE

CALENDAR_QUARTER_START_DATE DATE

CALENDAR_YEAR_START_DATE DATE

ROWID_WS ROWID (10)
ROWID_GC ROWID (10)
Query Text

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


SELECT SHIFT_WORKDAY_PK_KEY
,      SHIFT_DATE
,      PLANT_FK_KEY
,      SYSTEM_FK_KEY
,      FROM_DATE
,      TO_DATE
,      DAY_ID
,      CALENDAR_MONTH_ID
,      CALENDAR_QUARTER_ID
,      CALENDAR_YEAR_ID
,      CALENDAR_MONTH_START_DATE
,      CALENDAR_QUARTER_START_DATE
,      CALENDAR_YEAR_START_DATE
,      ROWID_WS
,      ROWID_GC
FROM APPS.MTH_SHIFT_GREGORIAN_DENORM_MV;

Dependencies

[top of page]

APPS.MTH_SHIFT_GREGORIAN_DENORM_MV references the following:

SchemaAPPS
TableMTH_SHIFT_GREGORIAN_DENORM_MV
SchemaMTH
TableMTH_GREGORIAN_CALENDAR
TableMTH_WORKDAY_SHIFTS_D
APPS.MTH_SHIFT_GREGORIAN_DENORM_MV is referenced by following:

SchemaAPPS
Materialized ViewMTH_EQUIP_OP_SUM_DD_MV
Materialized ViewMTH_EQUIP_PROD_SCH_DD_MV
Materialized ViewMTH_EQUIP_SHFT_DD_MV
Materialized ViewMTH_EQUIP_ST_SUM_DD_MV