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: WIP.WIP_EAM_WORK_REQUESTS

Object Details

Object Name:	WIP_EAM_WORK_REQUESTS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_EAM_WORK_REQUESTS
Subobject Name:
Status:	VALID

This table stores work request information. It stores work request attributes like priority, contact person, owning department ID etc.
Please note that the details of the work request will be held in WIP_EAM_WORK_REQ_NOTES table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_EAM_WORK_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORK_REQUEST_NUMBER
WIP_EAM_WORK_REQUESTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORK_REQUEST_ID
WIP_EAM_WORK_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID ASSET_GROUP ASSET_NUMBER
WIP_EAM_WORK_REQUESTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID
WIP_EAM_WORK_REQUESTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID WORK_REQUEST_STATUS_ID
WIP_EAM_WORK_REQUESTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
WIP_EAM_WORK_REQUESTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORK_REQUEST_ID	NUMBER		Yes	System generated sequence number assigned to a Work Request.
WORK_REQUEST_NUMBER	VARCHAR2	(64)	Yes	Currently the value of this column is same as the WORK_REQUEST_ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
ASSET_NUMBER	VARCHAR2	(30)		Asset Number against which the Work Request is created.
ASSET_GROUP	NUMBER			Asset Group to which the Asset Number belongs
ORGANIZATION_ID	NUMBER		Yes	Current Organization Identification
WORK_REQUEST_STATUS_ID	NUMBER		Yes	Identifier corresponding to the status of a Work Request
WORK_REQUEST_PRIORITY_ID	NUMBER			Identifier corresponding to the priority of a Work Request
WORK_REQUEST_OWNING_DEPT	NUMBER			Department Number to which the Work Request is assigned.
EXPECTED_RESOLUTION_DATE	DATE			Date by which the Work Request should be resolved.
WIP_ENTITY_ID	NUMBER			Foreign key reference column to link the Work Request to a Work Order.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute column
ATTRIBUTE1	VARCHAR2	(150)		Attribute column
ATTRIBUTE2	VARCHAR2	(150)		Attribute column
ATTRIBUTE3	VARCHAR2	(150)		Attribute column
ATTRIBUTE4	VARCHAR2	(150)		Attribute column
ATTRIBUTE5	VARCHAR2	(150)		Attribute column
ATTRIBUTE6	VARCHAR2	(150)		Attribute column
ATTRIBUTE7	VARCHAR2	(150)		Attribute column
ATTRIBUTE8	VARCHAR2	(150)		Attribute column
ATTRIBUTE9	VARCHAR2	(150)		Attribute column
ATTRIBUTE10	VARCHAR2	(150)		Attribute column
ATTRIBUTE11	VARCHAR2	(150)		Attribute column
ATTRIBUTE12	VARCHAR2	(150)		Attribute column
ATTRIBUTE13	VARCHAR2	(150)		Attribute column
ATTRIBUTE14	VARCHAR2	(150)		Attribute column
ATTRIBUTE15	VARCHAR2	(150)		Attribute column
DESCRIPTION	VARCHAR2	(240)		Brief description of the Work Request
WORK_REQUEST_TYPE_ID	NUMBER			Reserved for Future Oracle Use.
WORK_REQUEST_CREATED_BY	NUMBER			Standard WHO Column
WORK_REQUEST_AUTO_APPROVE	VARCHAR2	(1)		Flag to identify if this Work Request can be approved automatically or not
MAINTENANCE_OBJECT_TYPE	NUMBER			Maintenance Object Type
MAINTENANCE_OBJECT_ID	NUMBER			Maintenance Object Id - Genealogy Object Id for Serialized rebuilds and asset numbers and inventory item id for non-serialized rebuilds
CREATED_FOR	NUMBER			Created For
PHONE_NUMBER	VARCHAR2	(4000)		Phone Number of the contact person
E_MAIL	VARCHAR2	(240)		E-mail of the contact person
CONTACT_PREFERENCE	NUMBER	(30)		Method of Contacting Work Request Originator
NOTIFY_ORIGINATOR	NUMBER			Notify Originator Flag
WF_ITEM_TYPE	VARCHAR2	(8)		Workflow Item Type
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Item Key
EAM_LINEAR_LOCATION_ID	NUMBER			Linear Asset Location Identifier

Query Text

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


SELECT WORK_REQUEST_ID
,      WORK_REQUEST_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ASSET_NUMBER
,      ASSET_GROUP
,      ORGANIZATION_ID
,      WORK_REQUEST_STATUS_ID
,      WORK_REQUEST_PRIORITY_ID
,      WORK_REQUEST_OWNING_DEPT
,      EXPECTED_RESOLUTION_DATE
,      WIP_ENTITY_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DESCRIPTION
,      WORK_REQUEST_TYPE_ID
,      WORK_REQUEST_CREATED_BY
,      WORK_REQUEST_AUTO_APPROVE
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      CREATED_FOR
,      PHONE_NUMBER
,      E_MAIL
,      CONTACT_PREFERENCE
,      NOTIFY_ORIGINATOR
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      EAM_LINEAR_LOCATION_ID
FROM WIP.WIP_EAM_WORK_REQUESTS;

Dependencies

[top of page]

WIP.WIP_EAM_WORK_REQUESTS does not reference any database object

WIP.WIP_EAM_WORK_REQUESTS is referenced by following:

APPS: WIP_EAM_WORK_REQUESTS