eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPS.MLOG$_ISC_DR_BKLG_01_MV

Object Details

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

snapshot log for master table APPS.ISC_DR_BKLG_01_MV

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
AGGREGATION_FLAG	NUMBER
CLOSE_COUNT	NUMBER
COMPLETE_WITH_PROMISE_DATE_CNT	NUMBER
COUNT_DAYS_LATE_MV	NUMBER
COUNT_MV	NUMBER
CUSTOMER_ID	NUMBER	(15)
DAYS_LATE	NUMBER
DAYS_LATE_AGE_B1	NUMBER
DAYS_LATE_AGE_B10	NUMBER
DAYS_LATE_AGE_B2	NUMBER
DAYS_LATE_AGE_B3	NUMBER
DAYS_LATE_AGE_B4	NUMBER
DAYS_LATE_AGE_B5	NUMBER
DAYS_LATE_AGE_B6	NUMBER
DAYS_LATE_AGE_B7	NUMBER
DAYS_LATE_AGE_B8	NUMBER
DAYS_LATE_AGE_B9	NUMBER
DAY_ID	NUMBER
GRP_ID_MV	NUMBER
ITEM_ORG_ID	VARCHAR2	(25)
LATE_COMPLETE_COUNT	NUMBER
MONTH_ID	NUMBER
OPEN_COUNT	NUMBER
PAST_DUE_OPEN_COUNT	NUMBER
PERIOD_TYPE_ID	NUMBER
PRODUCT_CATEGORY_ID	NUMBER
QTR_ID	NUMBER
REPAIR_ORGANIZATION_ID	NUMBER	(15)
REPAIR_TYPE_ID	NUMBER	(15)
TIME_ID	NUMBER
WEEK_ID	NUMBER
YEAR_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
,      CLOSE_COUNT
,      COMPLETE_WITH_PROMISE_DATE_CNT
,      COUNT_DAYS_LATE_MV
,      COUNT_MV
,      CUSTOMER_ID
,      DAYS_LATE
,      DAYS_LATE_AGE_B1
,      DAYS_LATE_AGE_B10
,      DAYS_LATE_AGE_B2
,      DAYS_LATE_AGE_B3
,      DAYS_LATE_AGE_B4
,      DAYS_LATE_AGE_B5
,      DAYS_LATE_AGE_B6
,      DAYS_LATE_AGE_B7
,      DAYS_LATE_AGE_B8
,      DAYS_LATE_AGE_B9
,      DAY_ID
,      GRP_ID_MV
,      ITEM_ORG_ID
,      LATE_COMPLETE_COUNT
,      MONTH_ID
,      OPEN_COUNT
,      PAST_DUE_OPEN_COUNT
,      PERIOD_TYPE_ID
,      PRODUCT_CATEGORY_ID
,      QTR_ID
,      REPAIR_ORGANIZATION_ID
,      REPAIR_TYPE_ID
,      TIME_ID
,      WEEK_ID
,      YEAR_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_ISC_DR_BKLG_01_MV;

Dependencies

[top of page]

APPS.MLOG$_ISC_DR_BKLG_01_MV does not reference any database object

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