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

TABLE: ENG.MLOG$_ENG_CHANGE_LINES

Object Details
Object Name: MLOG$_ENG_CHANGE_LINES
Object Type: TABLE
Owner: ENG
Subobject Name:
Status: VALID

snapshot log for master table ENG.ENG_CHANGE_LINES

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
APPROVAL_DATE DATE

APPROVAL_STATUS_TYPE NUMBER

ASSIGNEE_ID NUMBER

CANCELATION_DATE DATE

CHANGE_ID NUMBER

CHANGE_LINE_ID NUMBER

CHANGE_TYPE_ID NUMBER

COMPLETE_BEFORE_STATUS_CODE NUMBER

CREATION_DATE DATE

IMPLEMENTATION_DATE DATE

NEED_BY_DATE DATE

OBJECT_ID NUMBER

PK1_VALUE VARCHAR2 (100)
PK2_VALUE VARCHAR2 (100)
PK3_VALUE VARCHAR2 (100)
PK4_VALUE VARCHAR2 (100)
PK5_VALUE VARCHAR2 (100)
REQUIRED_FLAG VARCHAR2 (1)
ROUTE_ID NUMBER

SCHEDULED_DATE DATE

SEQUENCE_NUMBER NUMBER

START_AFTER_STATUS_CODE NUMBER

STATUS_CODE VARCHAR2 (30)
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 APPROVAL_DATE
,      APPROVAL_STATUS_TYPE
,      ASSIGNEE_ID
,      CANCELATION_DATE
,      CHANGE_ID
,      CHANGE_LINE_ID
,      CHANGE_TYPE_ID
,      COMPLETE_BEFORE_STATUS_CODE
,      CREATION_DATE
,      IMPLEMENTATION_DATE
,      NEED_BY_DATE
,      OBJECT_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      REQUIRED_FLAG
,      ROUTE_ID
,      SCHEDULED_DATE
,      SEQUENCE_NUMBER
,      START_AFTER_STATUS_CODE
,      STATUS_CODE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ENG.MLOG$_ENG_CHANGE_LINES;

Dependencies

[top of page]

ENG.MLOG$_ENG_CHANGE_LINES does not reference any database object

ENG.MLOG$_ENG_CHANGE_LINES is referenced by following:

SchemaAPPS
SynonymMLOG$_ENG_CHANGE_LINES