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]

VIEW: APPS.EAM_WORK_REQUEST_ASSOC_V

Object Details

Object Name:	EAM_WORK_REQUEST_ASSOC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_WORK_REQUEST_ASSOC_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View shows all associated work requests and service requests for a work order.

[View Source]

Columns

Name	Datatype	Length	Comments
REQUEST_NUMBER	VARCHAR2	(64)	Work Request or Service Request Number
REQUEST_TYPE	VARCHAR2	(80)	Request Type: Work Request or Service Request
STATUS	VARCHAR2	(90)	Request Status
ASSET_NUMBER	VARCHAR2	(30)	Asset Number
ASSET_GROUP	VARCHAR2	(40)	Asset Group
DEPARTMENT_CODE	VARCHAR2	(10)	Department from bom_departments table
EXP_RESOLUTION_DATE	DATE		Expected Resolution Date
DESCRIPTION	VARCHAR2	(240)	Description
ORIGINATOR	VARCHAR2	(360)	Request Originator
REPORTED_DATE	DATE		Request Reported Date
ASSET_TYPE	VARCHAR2	(80)	Asset Type: Capital or Inventory
WIP_ENTITY_ID	NUMBER		Work Order ID
REQUEST_ID	NUMBER		Request ID
ORGANIZATION_ID	NUMBER		Maintenance Organization Id
DEPARTMENT_ID	NUMBER		Department ID
WR_CREATED_BY	NUMBER		Work Request Created By
WR_STATUS_ID	NUMBER		Work Request Status ID
WR_PRIORITY_ID	NUMBER		Work Request Priority ID
WR_TYPE_ID	NUMBER		Work Request Type ID
SR_CREATED_BY	NUMBER		Service Request Created By
SR_STATUS_ID	NUMBER		Service Request Status
SR_PRIORITY_ID	NUMBER		Service Request Priority ID
SR_TYPE_ID	NUMBER		Service Request Type
SR_CUSTOMER_TYPE	VARCHAR2	(30)	Customer Type
SR_CUSTOMER_ID	NUMBER		Service Request Customer ID
SR_CUSTOMER_NUMBER	VARCHAR2	(30)	Service Request Customer Number
SR_ACCOUNT_ID	NUMBER		Account ID
SR_CONTACT_TYPE	VARCHAR2	(30)	Service Request Contact Type
SR_CONTACT_PARTY_ID	NUMBER		Service Request Party ID
SR_CONTACT_NUMBER	VARCHAR2	(30)	Service Request Contact Number
REQUEST_TYPE_CODE	NUMBER		Request Type Code
SR_CLOSE_FLAG	VARCHAR2	(1)	Service Request Close Flag
ASSET_TYPE_CODE	NUMBER		Asset Type Code

Query Text

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


SELECT REQUEST_NUMBER
,      REQUEST_TYPE
,      STATUS
,      ASSET_NUMBER
,      ASSET_GROUP
,      DEPARTMENT_CODE
,      EXP_RESOLUTION_DATE
,      DESCRIPTION
,      ORIGINATOR
,      REPORTED_DATE
,      ASSET_TYPE
,      WIP_ENTITY_ID
,      REQUEST_ID
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      WR_CREATED_BY
,      WR_STATUS_ID
,      WR_PRIORITY_ID
,      WR_TYPE_ID
,      SR_CREATED_BY
,      SR_STATUS_ID
,      SR_PRIORITY_ID
,      SR_TYPE_ID
,      SR_CUSTOMER_TYPE
,      SR_CUSTOMER_ID
,      SR_CUSTOMER_NUMBER
,      SR_ACCOUNT_ID
,      SR_CONTACT_TYPE
,      SR_CONTACT_PARTY_ID
,      SR_CONTACT_NUMBER
,      REQUEST_TYPE_CODE
,      SR_CLOSE_FLAG
,      ASSET_TYPE_CODE
FROM APPS.EAM_WORK_REQUEST_ASSOC_V;

Dependencies

[top of page]

APPS.EAM_WORK_REQUEST_ASSOC_V references the following:

APPS: BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; CS_HZ_SR_CONTACT_POINTS; CS_INCIDENTS_B_SEC; CS_INCIDENTS_VL_SEC; CS_INCIDENT_STATUSES_B; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_VL_SEC; EAM_WO_SERVICE_ASSOCIATION; FND_USER; HZ_PARTIES; MFG_LOOKUPS; MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_KFV; WIP_EAM_WORK_REQUESTS

APPS.EAM_WORK_REQUEST_ASSOC_V is not referenced by any database object