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

TABLE: MTH.MLOG$_MTH_EQUIPMENT_DENORM

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

snapshot log for master table MTH.MTH_EQUIPMENT_DENORM_D

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

EQUIPMENT_EXPIRATION_DATE DATE

EQUIPMENT_FK_KEY NUMBER

EQUIPMENT_HIERARCHY_KEY NUMBER

LEVEL8_EFFECTIVE_DATE DATE

LEVEL8_EXPIRATION_DATE DATE

LEVEL8_HIERARCHY_KEY NUMBER

LEVEL8_ID NUMBER

LEVEL8_LEVEL_KEY NUMBER

LEVEL8_PARENT_KEY NUMBER

LEVEL9_EFFECTIVE_DATE DATE

LEVEL9_EXPIRATION_DATE DATE

LEVEL9_HIERARCHY_KEY NUMBER

LEVEL9_ID NUMBER

LEVEL9_LEVEL_KEY NUMBER

LEVEL9_PARENT_KEY 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 EQUIPMENT_EFFECTIVE_DATE
,      EQUIPMENT_EXPIRATION_DATE
,      EQUIPMENT_FK_KEY
,      EQUIPMENT_HIERARCHY_KEY
,      LEVEL8_EFFECTIVE_DATE
,      LEVEL8_EXPIRATION_DATE
,      LEVEL8_HIERARCHY_KEY
,      LEVEL8_ID
,      LEVEL8_LEVEL_KEY
,      LEVEL8_PARENT_KEY
,      LEVEL9_EFFECTIVE_DATE
,      LEVEL9_EXPIRATION_DATE
,      LEVEL9_HIERARCHY_KEY
,      LEVEL9_ID
,      LEVEL9_LEVEL_KEY
,      LEVEL9_PARENT_KEY
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM MTH.MLOG$_MTH_EQUIPMENT_DENORM;

Dependencies

[top of page]

MTH.MLOG$_MTH_EQUIPMENT_DENORM does not reference any database object

MTH.MLOG$_MTH_EQUIPMENT_DENORM is referenced by following:

SchemaAPPS
SynonymMLOG$_MTH_EQUIPMENT_DENORM