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.CS_SERVICE_REQUEST_PUB_V

Object Details

Object Name:	CS_SERVICE_REQUEST_PUB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SERVICE_REQUEST_PUB_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Service Request Public View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
SERVICE_REQUEST_NUMBER	VARCHAR2	(64)	Yes	Service Request Number from cs_incidents_all_b table
SERVICE_REQUEST_ID	NUMBER	(15)	Yes	Service Request ID from cs_incidents_all_b table.
SERVICE_REQUEST_SUMMARY	VARCHAR2	(240)	Yes	Service Request Summary from cs_incidents_all_b table.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number from cs_incidents_all_b table
RESOLVE_BY_DATE	DATE			Incident Resolved by Date
REPORTED_DATE	DATE			Incident Reported date
INCIDENT_LAST_MODIFIED_DATE	DATE			Incident Last Modified date
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
GROUP_OWNER_NAME	VARCHAR2	(60)		Service Request Group Owner Name
OWNER_NAME	VARCHAR2	(360)		Service Request Resource Owner Name
INCIDENT_DATE	DATE			Incident Occurred Date
RESOLVED_ON_DATE	DATE			Service Request Resolved on Date
RESPONDED_ON_DATE	DATE			Service Request Responded on Date
DATE_CLOSED	DATE			Date service request closed
RESPOND_BY_DATE	DATE			Service Request responded by date
SR_CREATION_CHANNEL	VARCHAR2	(50)		Service Request Creation Channel
INCIDENT_LOCATION_TYPE	VARCHAR2	(30)		Service Request Incident Location Type
INCIDENT_LOCATION_ID	NUMBER			Service Request Incident Location ID
SERVICE_REQUEST_TYPE	VARCHAR2	(90)	Yes	Service Request Type
SEVERITY	VARCHAR2	(90)	Yes	Service Request Severity
STATUS	VARCHAR2	(90)	Yes	Service Request Status
OPEN_FLAG	VARCHAR2	(3)	Yes	Service Request Open/Close flag indicator
URGENCY	VARCHAR2	(90)		Service Request Urgency
ITEM_NUMBER	VARCHAR2	(40)		Service Request Inventory Item
ITEM_REVISION	VARCHAR2	(240)		Service Request Inventory Item Revision
CUSTOMER_ID	NUMBER	(15)	Yes	Service Request Customer ID
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Service Request Customer Name
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	Service Request Customer Number
CUSTOMER_TYPE	VARCHAR2	(30)	Yes	Service Request Customer Type
ACCOUNT_NUMBER	VARCHAR2	(30)		Customer Account Number
PROBLEM_CODE	VARCHAR2	(80)		Service Request Problem Code
RESOLUTION_CODE	VARCHAR2	(80)		Service Request Resolution Code
ITEM_INSTANCE_ID	VARCHAR2	(30)		Install Base Instance Number
INSTANCE_REVISION	VARCHAR2	(240)		Install Base Item revision from cs_incidents_all_b table

Query Text

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


SELECT ROW_ID
,      SERVICE_REQUEST_NUMBER
,      SERVICE_REQUEST_ID
,      SERVICE_REQUEST_SUMMARY
,      OBJECT_VERSION_NUMBER
,      RESOLVE_BY_DATE
,      REPORTED_DATE
,      INCIDENT_LAST_MODIFIED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      GROUP_OWNER_NAME
,      OWNER_NAME
,      INCIDENT_DATE
,      RESOLVED_ON_DATE
,      RESPONDED_ON_DATE
,      DATE_CLOSED
,      RESPOND_BY_DATE
,      SR_CREATION_CHANNEL
,      INCIDENT_LOCATION_TYPE
,      INCIDENT_LOCATION_ID
,      SERVICE_REQUEST_TYPE
,      SEVERITY
,      STATUS
,      OPEN_FLAG
,      URGENCY
,      ITEM_NUMBER
,      ITEM_REVISION
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_TYPE
,      ACCOUNT_NUMBER
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      ITEM_INSTANCE_ID
,      INSTANCE_REVISION
FROM APPS.CS_SERVICE_REQUEST_PUB_V;

Dependencies

[top of page]

APPS.CS_SERVICE_REQUEST_PUB_V references the following:

APPS: CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_TL; CS_INCIDENTS_B_SEC; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; FND_LOOKUP_VALUES; HZ_CUST_ACCOUNTS; HZ_PARTIES; JTF_RS_GROUPS_TL; JTF_RS_RESOURCE_EXTNS_TL; MTL_SYSTEM_ITEMS_KFV

APPS.CS_SERVICE_REQUEST_PUB_V is not referenced by any database object