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

TABLE: APPS.MLOG$_ISC_DR_MTTR_01_MV

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

snapshot log for master table APPS.ISC_DR_MTTR_01_MV

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

CUSTOMER_ID NUMBER (15)
DAY_ID NUMBER

ITEM_ORG_ID VARCHAR2 (25)
MONTH_ID NUMBER

PERIOD_TYPE_ID NUMBER

PRODUCT_CATEGORY_ID NUMBER

QTR_ID NUMBER

REPAIR_ORGANIZATION_ID NUMBER (15)
REPAIR_TYPE_ID NUMBER (15)
RO_COUNT NUMBER

TIME_ID NUMBER

TIME_TO_REPAIR NUMBER

TIME_TO_REPAIR_B1 NUMBER

TIME_TO_REPAIR_B10 NUMBER

TIME_TO_REPAIR_B2 NUMBER

TIME_TO_REPAIR_B3 NUMBER

TIME_TO_REPAIR_B4 NUMBER

TIME_TO_REPAIR_B5 NUMBER

TIME_TO_REPAIR_B6 NUMBER

TIME_TO_REPAIR_B7 NUMBER

TIME_TO_REPAIR_B8 NUMBER

TIME_TO_REPAIR_B9 NUMBER

WEEK_ID 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 AGGREGATION_FLAG
,      CUSTOMER_ID
,      DAY_ID
,      ITEM_ORG_ID
,      MONTH_ID
,      PERIOD_TYPE_ID
,      PRODUCT_CATEGORY_ID
,      QTR_ID
,      REPAIR_ORGANIZATION_ID
,      REPAIR_TYPE_ID
,      RO_COUNT
,      TIME_ID
,      TIME_TO_REPAIR
,      TIME_TO_REPAIR_B1
,      TIME_TO_REPAIR_B10
,      TIME_TO_REPAIR_B2
,      TIME_TO_REPAIR_B3
,      TIME_TO_REPAIR_B4
,      TIME_TO_REPAIR_B5
,      TIME_TO_REPAIR_B6
,      TIME_TO_REPAIR_B7
,      TIME_TO_REPAIR_B8
,      TIME_TO_REPAIR_B9
,      WEEK_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_ISC_DR_MTTR_01_MV;

Dependencies

[top of page]

APPS.MLOG$_ISC_DR_MTTR_01_MV does not reference any database object

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