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


TABLE: APPS.MLOG$_MTH_SHIFT_GREGORIAN_

Object Details
Object Name: MLOG$_MTH_SHIFT_GREGORIAN_
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.MTH_SHIFT_GREGORIAN_DENORM_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CALENDAR_MONTH_ID NUMBER

CALENDAR_MONTH_START_DATE DATE

CALENDAR_QUARTER_ID NUMBER

CALENDAR_QUARTER_START_DATE DATE

CALENDAR_YEAR_ID NUMBER

CALENDAR_YEAR_START_DATE DATE

DAY_ID NUMBER

FROM_DATE DATE

PLANT_FK_KEY NUMBER

ROWID_GC ROWID (10)
ROWID_WS ROWID (10)
SHIFT_DATE DATE

SHIFT_WORKDAY_PK_KEY NUMBER

SYSTEM_FK_KEY NUMBER

TO_DATE DATE

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT CALENDAR_MONTH_ID
,      CALENDAR_MONTH_START_DATE
,      CALENDAR_QUARTER_ID
,      CALENDAR_QUARTER_START_DATE
,      CALENDAR_YEAR_ID
,      CALENDAR_YEAR_START_DATE
,      DAY_ID
,      FROM_DATE
,      PLANT_FK_KEY
,      ROWID_GC
,      ROWID_WS
,      SHIFT_DATE
,      SHIFT_WORKDAY_PK_KEY
,      SYSTEM_FK_KEY
,      TO_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_MTH_SHIFT_GREGORIAN_;

Dependencies

[top of page]

APPS.MLOG$_MTH_SHIFT_GREGORIAN_ does not reference any database object

APPS.MLOG$_MTH_SHIFT_GREGORIAN_ is not referenced by any database object