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_SR_REPORT_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER	(15)	Yes	Incident_id from cs_incidents_all_b
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	Service request Incident Number
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item Id from cs_incidents_all_b
PRODUCT_NAME	VARCHAR2	(40)		Product name from mtl_system_items_kfv
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Product description from mtl_system_items_kfv
INCIDENT_DATE	DATE			Incident date from cs_incidents_all_b
CUSTOMER_ID	NUMBER	(15)		Customer Id
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number from hz_parties
COMPANY_NAME	VARCHAR2	(360)		Customer Name from hz_parties
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Serial number
CUSTOMER_PRODUCT_ID	NUMBER	(15)		Customer Product Id
REFERENCE_NUMBER	VARCHAR2	(30)		Reference Number from CS_CUSTOMER_PRODUCTS
PROBLEM_CODE	VARCHAR2	(30)		Problem Code
PROBLEM_CODE_MEANING	VARCHAR2	(80)		Problem meaning
PROBLEM_CODE_DESCRIPTION	VARCHAR2	(240)		Problem description
RESOLUTION_CODE	VARCHAR2	(30)		Resolution code
RESOLUTION_CODE_MEANING	VARCHAR2	(80)		Resolution meaning
RESOLUTION_CODE_DESCRIPTION	VARCHAR2	(240)		Resolution description
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	Service Request Type Id
INCIDENT_TYPE	VARCHAR2	(90)	Yes	Service Request Type Name
INCIDENT_SEVERITY_ID	NUMBER	(15)	Yes	Service Request Severity Id
SEVERITY	VARCHAR2	(90)	Yes	Service Request Severity name
INCIDENT_STATUS_ID	NUMBER	(15)	Yes	Service Request Status Id
STATUS_CODE	VARCHAR2	(90)	Yes	Service Request Status Code
INCIDENT_URGENCY_ID	NUMBER	(15)		Service Request Urgency Id
URGENCY	VARCHAR2	(90)		Service Request Urgency name
OWNER	VARCHAR2	(360)		Service Request Owner
SUMMARY	VARCHAR2	(240)	Yes	Summary
DATE_CLOSED	DATE			Date Service Request Closed
CLOSED_FLAG	VARCHAR2	(1)		Service Request Closed Flag
LOGGED_BY_NAME	VARCHAR2	(100)	Yes	Service Request Logged by name
RECORD_IS_VALID_FLAG	VARCHAR2	(1)		Record valid flag

Query Text

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


SELECT INCIDENT_ID
,      INCIDENT_NUMBER
,      INVENTORY_ITEM_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      INCIDENT_DATE
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      COMPANY_NAME
,      CURRENT_SERIAL_NUMBER
,      CUSTOMER_PRODUCT_ID
,      REFERENCE_NUMBER
,      PROBLEM_CODE
,      PROBLEM_CODE_MEANING
,      PROBLEM_CODE_DESCRIPTION
,      RESOLUTION_CODE
,      RESOLUTION_CODE_MEANING
,      RESOLUTION_CODE_DESCRIPTION
,      INCIDENT_TYPE_ID
,      INCIDENT_TYPE
,      INCIDENT_SEVERITY_ID
,      SEVERITY
,      INCIDENT_STATUS_ID
,      STATUS_CODE
,      INCIDENT_URGENCY_ID
,      URGENCY
,      OWNER
,      SUMMARY
,      DATE_CLOSED
,      CLOSED_FLAG
,      LOGGED_BY_NAME
,      RECORD_IS_VALID_FLAG
FROM APPS.CS_SR_REPORT_V;

Dependencies

[top of page]

APPS.CS_SR_REPORT_V references the following:

APPS: CSICUMPI_PUB - show dependent code; CS_CUSTOMER_PRODUCTS; CS_INCIDENTS_ALL_VL; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_VL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; CS_LOOKUPS; FND_GLOBAL - show dependent code; FND_USER; HZ_PARTIES; JTF_RS_RESOURCE_EXTNS_VL; MTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_REPORT_V is not referenced by any database object