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: ISC.MLOG$_ISC_MAINT_WO_CST_SUM

Object Details

Object Name:	MLOG$_ISC_MAINT_WO_CST_SUM
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

snapshot log for master table ISC.ISC_MAINT_WO_CST_SUM_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
ACTUAL_EQP_COST_B	NUMBER
ACTUAL_LAB_COST_B	NUMBER
ACTUAL_MAT_COST_B	NUMBER
COMPLETION_DATE	DATE
CONVERSION_RATE1	NUMBER
CONVERSION_RATE2	NUMBER
DEPARTMENT_ID	NUMBER
ESTIMATED_EQP_COST_B	NUMBER
ESTIMATED_FLAG	VARCHAR2	(1)
ESTIMATED_LAB_COST_B	NUMBER
ESTIMATED_MAT_COST_B	NUMBER
MAINT_COST_CATEGORY	NUMBER
ORGANIZATION_ID	NUMBER
WORK_ORDER_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 ACTUAL_EQP_COST_B
,      ACTUAL_LAB_COST_B
,      ACTUAL_MAT_COST_B
,      COMPLETION_DATE
,      CONVERSION_RATE1
,      CONVERSION_RATE2
,      DEPARTMENT_ID
,      ESTIMATED_EQP_COST_B
,      ESTIMATED_FLAG
,      ESTIMATED_LAB_COST_B
,      ESTIMATED_MAT_COST_B
,      MAINT_COST_CATEGORY
,      ORGANIZATION_ID
,      WORK_ORDER_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_MAINT_WO_CST_SUM;

Dependencies

[top of page]

ISC.MLOG$_ISC_MAINT_WO_CST_SUM does not reference any database object

ISC.MLOG$_ISC_MAINT_WO_CST_SUM is referenced by following:

APPS: MLOG$_ISC_MAINT_WO_CST_SUM