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_SERVICE_REQUEST_DETAILS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER	(15)	Yes	Service Request Identifier
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	Service Request Number
INCIDENT_STATUS_ID	NUMBER	(15)	Yes	Identifier for Service Request Status
STATUS	VARCHAR2	(30)		Status
INCIDENT_SEVERITY_ID	NUMBER	(15)	Yes	Identifier for Service Request Severity
SEVERITY	VARCHAR2	(30)		Severity
ORG_ID	NUMBER			Operating Unit Identifier
INV_ORGANIZATION_ID	NUMBER			Identifier for Inventory Organization
INVENTORY_ITEM_ID	NUMBER	(15)		Identifier for Inventory Item
OPERATING_UNIT	NUMBER			Operating Unit
ITEM_NAME	VARCHAR2	(40)		Inventory Item
REQUEST_DATE	DATE		Yes	Creation Date of Service Request
REQUEST_BY_DATE	DATE			Expected Resolution Date
SUMMARY	VARCHAR2	(240)	Yes	Summary of Service Request
DEPARTMENT	VARCHAR2	(10)		Department Name
OWNING_DEPARTMENT_ID	NUMBER			Department Id
STATUS_FLAG	VARCHAR2	(3)	Yes
MAINTENANCE_FLAG	VARCHAR2	(3)
MAINT_ORGANIZATION_ID	NUMBER			Maintenance Organization Id
MAINTENANCE_OBJECT_TYPE	NUMBER			Maintenance Object Type
MAINTENANCE_OBJECT_ID	NUMBER			Maintenance Object Id
ASSET_NUMBER	VARCHAR2	(30)		Instance Number

Query Text

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


SELECT INCIDENT_ID
,      INCIDENT_NUMBER
,      INCIDENT_STATUS_ID
,      STATUS
,      INCIDENT_SEVERITY_ID
,      SEVERITY
,      ORG_ID
,      INV_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      OPERATING_UNIT
,      ITEM_NAME
,      REQUEST_DATE
,      REQUEST_BY_DATE
,      SUMMARY
,      DEPARTMENT
,      OWNING_DEPARTMENT_ID
,      STATUS_FLAG
,      MAINTENANCE_FLAG
,      MAINT_ORGANIZATION_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      ASSET_NUMBER
FROM APPS.EAM_SERVICE_REQUEST_DETAILS_V;

Dependencies

[top of page]

APPS.EAM_SERVICE_REQUEST_DETAILS_V references the following:

APPS: BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; CS_INCIDENTS_VL_SEC; CS_INCIDENT_SEVERITIES_B; CS_INCIDENT_STATUSES_B; CS_INCIDENT_TYPES_VL_SEC; MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_SERVICE_REQUEST_DETAILS_V is not referenced by any database object