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.ISC_MAINT_ASSET_DOWN_F

Object Details

Object Name:	ISC_MAINT_ASSET_DOWN_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_MAINT_ASSET_DOWN_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ASSET_STATUS_ID
ISC_MAINT_ASSET_DOWN_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	WORK_ORDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSET_STATUS_ID	NUMBER		Yes	Asset status identifier from EAM_ASSET_STATUS_HISTORY.ASSET_STATUS_ID
INSTANCE_ID	NUMBER		Yes	Instance identifier from EAM_ASSET_STATUS_HISTORY.MAINTENANCE_OBJECT_ID
ASSET_NUMBER	VARCHAR2	(30)		Obseleted in EAM-IB R12
ASSET_GROUP_ID	NUMBER		Yes	Asset group identifier from EAM_ASSET_STATUS_HISTORY.ASSET_GROUP_ID
CATEGORY_ID	NUMBER			Category Identifier from MTL_SERIAL_NUMBERS.CATEGORY_ID
ASSET_CRITICALITY_CODE	VARCHAR2	(30)		Asset criticality code from MTL_SERIAL_NUMBERS.ASSET_CRITICALITY_CODE
ORGANIZATION_ID	NUMBER		Yes	Organization identifier from EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID
DEPARTMENT_ID	NUMBER			Owning Department Identifier from MTL_SERIAL_NUMBERS.OWNING_DEPARTMENT_ID
WORK_ORDER_ID	NUMBER			Work order identifier from EAM_ASSET_STATUS_HISTORY.WIP_ENTITY_ID
OPERATION_SEQ_NUMBER	NUMBER			Operation identifier from EAM_ASSET_STATUS_HISTORY.OPERATION_SEQ_NUMBER
DESCRIPTION	VARCHAR2	(240)		Shutdown description from EAM_ASSET_STATUS_HISTORY.DESCRIPTION
START_DATE	DATE		Yes	Shutdown start date from EAM_ASSET_STATUS_HISTORY.START_DATE
END_DATE	DATE		Yes	Shutdown end date from EAM_ASSET_STATUS_HISTORY.END_DATE
DBI_START_DATE	DATE		Yes	Start date for calculating the shutdown history for dbi calculations
EFFECTIVE_START_DATE	DATE			Effective start date of the asset after removing overlapping
EFFECTIVE_END_DATE	DATE			Effective end date of the asset after removing overlapping
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
ENABLE_FLAG	VARCHAR2	(1)		Flag to identify whether a downtime row is valid or not
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSET_STATUS_ID
,      INSTANCE_ID
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      CATEGORY_ID
,      ASSET_CRITICALITY_CODE
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      WORK_ORDER_ID
,      OPERATION_SEQ_NUMBER
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      DBI_START_DATE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLE_FLAG
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_MAINT_ASSET_DOWN_F;

Dependencies

[top of page]

ISC.ISC_MAINT_ASSET_DOWN_F does not reference any database object

ISC.ISC_MAINT_ASSET_DOWN_F is referenced by following:

APPS: ISC_MAINT_001_MV; ISC_MAINT_ASSET_DOWN_F