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


TABLE: MTH.MLOG$_MTH_PRODUCTION_SCHED

Object Details
Object Name: MLOG$_MTH_PRODUCTION_SCHED
Object Type: TABLE
Owner: MTH
Subobject Name:
Status: VALID

snapshot log for master table MTH.MTH_PRODUCTION_SCHEDULES_F

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTUAL_COMPLETION_DATE DATE

ACTUAL_START_DATE DATE

PLANNED_COMPLETION_DATE DATE

PLANNED_START_DATE DATE

STATUS_CODE NUMBER

WORKORDER_NAME VARCHAR2 (240)
WORKORDER_PK VARCHAR2 (240)
WORKORDER_PK_KEY NUMBER

WORKORDER_TYPE NUMBER

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 ACTUAL_COMPLETION_DATE
,      ACTUAL_START_DATE
,      PLANNED_COMPLETION_DATE
,      PLANNED_START_DATE
,      STATUS_CODE
,      WORKORDER_NAME
,      WORKORDER_PK
,      WORKORDER_PK_KEY
,      WORKORDER_TYPE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM MTH.MLOG$_MTH_PRODUCTION_SCHED;

Dependencies

[top of page]

MTH.MLOG$_MTH_PRODUCTION_SCHED does not reference any database object

MTH.MLOG$_MTH_PRODUCTION_SCHED is referenced by following:

SchemaAPPS
SynonymMLOG$_MTH_PRODUCTION_SCHED