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_WORK_ORDERS_F

Object Details

Object Name:	ISC_MAINT_WORK_ORDERS_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_WORK_ORDERS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID WORK_ORDER_ID
ISC_MAINT_WORK_ORDERS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Maintenance Organization Id
INSTANCE_ID	NUMBER			Instance_Id from CII.Instance_id. This is the new foreign key to the Asset dimension
WORK_ORDER_ID	NUMBER		Yes	Work Order WIP_Entity_Id
WORK_ORDER_NAME	VARCHAR2	(240)	Yes	Work Order WIP_ENTITIY_NAME
DESCRIPTION	VARCHAR2	(240)		Work Order Description
ENTITY_TYPE	NUMBER		Yes	1: Maintenance job or 2: Closed maintenance
WORK_ORDER_TYPE	VARCHAR2	(30)		10: Routine, 20: Preventive, 30: Emergency
STATUS_TYPE	NUMBER			Stores the OLTP Job Status numbers such as 1:Unreleased, 4:Complete
DEPARTMENT_ID	NUMBER			Department responsible for the scheduling and execution of the Work Order. This Department is required when the work order is released
RELEASED_DATE	DATE			Work Order Released date
WO_CREATION_DATE	DATE			Creation date of the work order. It is GSD if it is before GSD to start counting backlog from GSD
WO_CREATION_DATETIME	DATE			Creation date of the work order with time component
DBI_COMPLETION_DATE	DATE			It is GSD if it is before GSD. To start counting completion of work orders from GSD
COMPLETION_DATE	DATE			Work Order Completion date
COMPLETION_DATETIME	DATE			Work Order Completion date with time component
CLOSED_DATE	DATE			Word Order Closed date
SCHEDULED_START_DATE	DATE			Date the Work Order is Scheduled to Start
DBI_SCHEDULED_COMPLETION_DATE	DATE			It is GSD if it is before GSD. To start counting past due work orders from GSD
SCHEDULED_COMPLETION_DATE	DATE			Date the Work Order is Scheduled to Complete
DAYS_LATE	NUMBER			Completion_date - Scheduled_Completion_date (Negative if completed before time, this measure is used several times in the Summarization)
INCLUDE_WO	NUMBER			Flag to determine if the work order should be included in the MVs
ASSET_GROUP_ID	NUMBER			Work order Asset Group ID
ASSET_NUMBER	VARCHAR2	(30)		Obseleted in DBI-EAM R12
USER_DEFINED_STATUS_ID	NUMBER			User defined status id. It is the Status Id in EAM_WO_STATUSES
ACTIVITY_ID	NUMBER			Work order Activity Id
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
LAST_ESTIMATION_DATE	DATE			Used by Work Order Costing ETL
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 ORGANIZATION_ID
,      INSTANCE_ID
,      WORK_ORDER_ID
,      WORK_ORDER_NAME
,      DESCRIPTION
,      ENTITY_TYPE
,      WORK_ORDER_TYPE
,      STATUS_TYPE
,      DEPARTMENT_ID
,      RELEASED_DATE
,      WO_CREATION_DATE
,      WO_CREATION_DATETIME
,      DBI_COMPLETION_DATE
,      COMPLETION_DATE
,      COMPLETION_DATETIME
,      CLOSED_DATE
,      SCHEDULED_START_DATE
,      DBI_SCHEDULED_COMPLETION_DATE
,      SCHEDULED_COMPLETION_DATE
,      DAYS_LATE
,      INCLUDE_WO
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      USER_DEFINED_STATUS_ID
,      ACTIVITY_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_ESTIMATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_MAINT_WORK_ORDERS_F;

Dependencies

[top of page]

ISC.ISC_MAINT_WORK_ORDERS_F does not reference any database object

ISC.ISC_MAINT_WORK_ORDERS_F is referenced by following:

APPS: ISC_MAINT_004_MV; ISC_MAINT_005_MV; ISC_MAINT_006_MV; ISC_MAINT_007_MV; ISC_MAINT_WORK_ORDERS_F