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

Object Details

Object Name:	CSF_SR_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSF.CSF_SR_HIST_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
ROW_ID	ROWID	(10)		Row Identification
INCIDENT_ID	NUMBER	(15)	Yes	Incident Id
ORG_ID	NUMBER			Organization Id
CREATION_DATE	DATE		Yes	Service Request Creation Date
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	Service Request Number
INCIDENT_NUMBER_N	VARCHAR2	(64)	Yes	Service Request Number
SUMMARY	VARCHAR2	(240)	Yes	Summary
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item Id
INSTALL_SITE_USE_ID	NUMBER	(15)		Install Site Use Id
PROBLEM_CODE	VARCHAR2	(50)		Problem Code
EXPECTED_RESOLUTION_DATE	DATE			Expected Resolution Date
INCIDENT_DATE	DATE			Incident Date
CUSTOMER_PRODUCT_ID	NUMBER	(15)		Customer Product Id
REFERENCE_NUMBER	VARCHAR2	(30)		Reference Number
RESOLUTION_CODE	VARCHAR2	(50)		Resolution Code
INCIDENT_TYPE	VARCHAR2	(90)		Incident Type
SEVERITY	VARCHAR2	(90)		Severity
STATUS_CODE	VARCHAR2	(90)		Status Code
URGENCY	VARCHAR2	(90)		Urgency
CUSTOMER_ID	NUMBER	(15)		Customer Id
EMPLOYEE_ID	NUMBER	(15)		Employee id
EMPLOYEE_NAME	VARCHAR2	(0)		Employee Name
CONTRACT_SERVICE_ID	NUMBER			Contract Service id
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	Customer Number
CALLER_TYPE	VARCHAR2	(30)	Yes	Caller Type
PRODUCT_NAME	VARCHAR2	(40)		Product Name
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Product Description
OWNER	VARCHAR2	(360)		Owner
COMPANY_NAME	VARCHAR2	(360)	Yes	Company Name
CONTACT_NAME	VARCHAR2	(301)		Contact Name
PHONE	VARCHAR2	(40)		Phone
EMAIL	VARCHAR2	(2000)		Email Address
TIME_ZONE_NAME	VARCHAR2	(50)		Time zone Name
COUNTRY	VARCHAR2	(60)		Country
CONTRACT_NUMBER	VARCHAR2	(120)		Contract Number
CONTACT_TYPE	VARCHAR2	(30)		Contact Type
CONTACT_NUMBER	VARCHAR2	(30)		Contact Number
GROUP_TYPE	VARCHAR2	(30)		Group Type
TEXT_INDEX	VARCHAR2	(1)		Text Index used for Text summary

Query Text

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


SELECT ROW_ID
,      INCIDENT_ID
,      ORG_ID
,      CREATION_DATE
,      INCIDENT_NUMBER
,      INCIDENT_NUMBER_N
,      SUMMARY
,      INVENTORY_ITEM_ID
,      INSTALL_SITE_USE_ID
,      PROBLEM_CODE
,      EXPECTED_RESOLUTION_DATE
,      INCIDENT_DATE
,      CUSTOMER_PRODUCT_ID
,      REFERENCE_NUMBER
,      RESOLUTION_CODE
,      INCIDENT_TYPE
,      SEVERITY
,      STATUS_CODE
,      URGENCY
,      CUSTOMER_ID
,      EMPLOYEE_ID
,      EMPLOYEE_NAME
,      CONTRACT_SERVICE_ID
,      CUSTOMER_NUMBER
,      CALLER_TYPE
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      OWNER
,      COMPANY_NAME
,      CONTACT_NAME
,      PHONE
,      EMAIL
,      TIME_ZONE_NAME
,      COUNTRY
,      CONTRACT_NUMBER
,      CONTACT_TYPE
,      CONTACT_NUMBER
,      GROUP_TYPE
,      TEXT_INDEX
FROM APPS.CSF_SR_HIST_V;

Dependencies

[top of page]

APPS.CSF_SR_HIST_V references the following:

APPS: CSI_ITEM_INSTANCES; CS_HZ_SR_CONTACT_POINTS; CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; HZ_CONTACT_POINTS; HZ_PARTIES; HZ_TIMEZONES; MTL_SYSTEM_ITEMS_KFV

APPS.CSF_SR_HIST_V is not referenced by any database object