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_REQ_WO_F

Object Details

Object Name:	ISC_MAINT_REQ_WO_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_REQ_WO_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	REQUEST_TYPE MAINT_REQUEST_ID ASSOCIATION_ID
ISC_MAINT_REQ_WO_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COMPLETION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_TYPE	VARCHAR2	(30)	Yes	Request Type identifier: 1 = Work Request, 2 = Service Request
MAINT_REQUEST_ID	NUMBER		Yes	Work Request or Service Request internal identifier
ASSOCIATION_ID	NUMBER		Yes	Work Request internal identifier or Service Request Association internal identifier
REQUEST_NUMBER	VARCHAR2	(64)	Yes	Work Request or Service Request external identifier
ORGANIZATION_ID	NUMBER		Yes	Maintenance Organization Id
DEPARTMENT_ID	NUMBER		Yes	Work Request or Service Request: Owning Department
ASSET_GROUP_ID	NUMBER		Yes	Work Request or Service Request: Asset Group
ASSET_NUMBER	VARCHAR2	(30)		Obseleted in DBI-EAM R12
INSTANCE_ID	NUMBER		Yes	Work Request or Service Request: Instance_id
REQUEST_START_DATE	DATE		Yes	Work Request creation date or Service Request incident date
REQUEST_SEVERITY_ID	NUMBER		Yes	Work Request or Service Request: Severity
WORK_ORDER_ID	NUMBER			Work Order internal identifier
COMPLETION_DATE	DATE			Work Order completion date if this is the last completed Work Order associated with the Work Request or Service Request
RESPONSE_DAYS	NUMBER			Elapsed days - Work Request creation date or Service Request incident date to Work Order creation date if this is the last completed Work Order associated with the Work Request or Service Request
COMPLETION_DAYS	NUMBER			Elapsed days - Work Request creation date or Service Request incident date to Work Order completion date if this is the last completed Work Order associated with the Work Request or Service Request
WORK_ORDER_COUNT	NUMBER			Number of Work Order associated with the Work Request or Service Request if this is the last completed Work Order associated with Work Request or Service Request
CREATION_DATE	DATE		Yes	Who Column
CREATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER			Who Column
PROGRAM_ID	NUMBER			Who Column
PROGRAM_LOGIN_ID	NUMBER			Who Column
PROGRAM_APPLICATION_ID	NUMBER			Who Column
REQUEST_ID	NUMBER			Who Column

Query Text

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


SELECT REQUEST_TYPE
,      MAINT_REQUEST_ID
,      ASSOCIATION_ID
,      REQUEST_NUMBER
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      INSTANCE_ID
,      REQUEST_START_DATE
,      REQUEST_SEVERITY_ID
,      WORK_ORDER_ID
,      COMPLETION_DATE
,      RESPONSE_DAYS
,      COMPLETION_DAYS
,      WORK_ORDER_COUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_MAINT_REQ_WO_F;

Dependencies

[top of page]

ISC.ISC_MAINT_REQ_WO_F does not reference any database object

ISC.ISC_MAINT_REQ_WO_F is referenced by following:

APPS: ISC_MAINT_003_MV; ISC_MAINT_REQ_WO_F