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


TABLE: APPS.MTH_SHIFT_REFERENCE_MV

Object Details
Object Name: MTH_SHIFT_REFERENCE_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableMTH.MTH_SHIFT_REFERENCE_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLANT_FK_KEY NUMBER
Yes
SHIFT_DATE DATE

TO_DATE DATE

Query Text

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


SELECT PLANT_FK_KEY
,      SHIFT_DATE
,      TO_DATE
FROM APPS.MTH_SHIFT_REFERENCE_MV;

Dependencies

[top of page]

APPS.MTH_SHIFT_REFERENCE_MV does not reference any database object

APPS.MTH_SHIFT_REFERENCE_MV is referenced by following:

SchemaAPPS
Materialized ViewMTH_SHIFT_REFERENCE_MV
Package BodyMTH_UTIL_PKG - show dependent code