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

Object Details

Object Name:	CSD_INCIDENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSD.CSD_INCIDENTS_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

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)		ROWID from CS_INCIDENTS_ALL_B
INCIDENT_ID	NUMBER	(15)	Yes	Service request identifier
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	Service request number
INCIDENT_STATUS_ID	NUMBER	(15)	Yes	Service request status identifier
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	Service request type identifier
INCIDENT_URGENCY_ID	NUMBER	(15)		Service request urgency identifier
INCIDENT_SEVERITY_ID	NUMBER	(15)	Yes	Service request severity identifier
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier
ITEM	VARCHAR2	(40)		Inventory item name
ITEM_DESC	VARCHAR2	(240)		Inventory item description
ITEM_REVISION	VARCHAR2	(240)		Item revsion code from Inventory. Only used if the item is revsion controlled.
INV_ORGANIZATION_ID	NUMBER			Inventory Organization ID
CUST_PHONE	VARCHAR2	(62)		Caller phone number
CUST_PHONE_LINE_TYPE	VARCHAR2	(80)		Caller phone type
CUST_PHONE_LINE_CODE	VARCHAR2	(30)		Caller phone type lookup code
EXT	VARCHAR2	(20)		Caller extension
CALLER	VARCHAR2	(301)		Caller
INCIDENT_DATE	DATE			Service request date
CUSTOMER_PRODUCT_ID	NUMBER			Customer product identifier
RECORD_IS_VALID_FLAG	VARCHAR2	(1)		Flag to denote if the service request is verified or not
ORG_ID	NUMBER			Organization identifier
OWNER_TYPE	VARCHAR2	(27)		Owner Type
INCIDENT_OWNER_ID	NUMBER	(15)		Incident Owner identifier
INCIDENT_OWNER	VARCHAR2	(4000)		Service request owner
CALLER_TYPE	VARCHAR2	(30)		Caller type
INCIDENT_TYPE	VARCHAR2	(90)	Yes	Service request type
SEVERITY	VARCHAR2	(90)	Yes	Service request severity
STATUS	VARCHAR2	(90)	Yes	Service request status
URGENCY	VARCHAR2	(90)		Service request urgency
CREATED_BY_NAME	VARCHAR2	(100)	Yes	Service request created by user name
FILED_BY_EMPLOYEE_FLAG	VARCHAR2	(1)		Indicates whether the request was made by an employee
CUSTOMER_ID	NUMBER			Customer identifier
EMPLOYEE_ID	NUMBER			Employee identifier
PARTY_NUMBER	VARCHAR2	(30)		Customer number
PARTY_NAME	VARCHAR2	(360)		Customer name
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the product
INSTALL_SITE_USE_ID	NUMBER	(15)		Site identifier from service request
CP_INSTALL_SITE_USE_ID	NUMBER			Site identifier from installed base
SITE	VARCHAR2	(30)		Site name
INCIDENT_ALLOWED_FLAG	VARCHAR2	(1)		Indicates whether service requests can be logged for the product
ADDRESS_STYLE	VARCHAR2	(30)		Site address style
ADDRESS1	VARCHAR2	(240)		Site address 1
ADDRESS2	VARCHAR2	(240)		Site address 2
ADDRESS3	VARCHAR2	(240)		Site address 3
ADDRESS4	VARCHAR2	(240)		Site address 4
ADDRESS_LINES_PHONETIC	VARCHAR2	(560)		Phonetic or Kana representation of the Kanji address lines (used in Japan)
CITY	VARCHAR2	(60)		Site city
COUNTY	VARCHAR2	(60)		Site county
POSTAL_CODE	VARCHAR2	(60)		Site postal code
PROVINCE	VARCHAR2	(60)		Site province
STATE	VARCHAR2	(60)		Site state
REFERENCE_NUMBER	VARCHAR2	(30)		Customer product reference number
DATE_CLOSED	DATE			Service request closed date
CLOSED_FLAG	VARCHAR2	(1)		Closed flag from service request status
LOGGED_BY_NAME	VARCHAR2	(100)	Yes	Service request logged by user name
PUBLISH_FLAG	VARCHAR2	(1)		Flag to denote whether the service request is published or not
CONTRACT_SERVICE_ID	NUMBER			Service line identifier
CONTRACT_NUMBER	VARCHAR2	(120)		Service contract number for the service request.
CONTRACT_ID	NUMBER			Service contract header id for the service request.
ACCOUNT_ID	NUMBER			Customer account identifier
CUSTOMER_PO_NUMBER	VARCHAR2	(50)		Customer purchase order number
ACCOUNT_NUMBER	VARCHAR2	(30)		Customer account number
SUMMARY	VARCHAR2	(240)	Yes	Summary Log for the Service Request
BILL_TO_ADDRESS	VARCHAR2	(812)		Bill to Address
SHIP_TO_ADDRESS	VARCHAR2	(812)		Ship to Address
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill to site use id
SHIP_TO_SITE_USE_ID	NUMBER	(15)		Ship to site use id
CONTACT_POINT_ID	NUMBER			Service Request Contact Point ID
CONTACT_TYPE	VARCHAR2	(30)		Contact Type for the Service Request
LAST_NAME	VARCHAR2	(150)		Last Name of the contact on the Service Request
FIRST_NAME	VARCHAR2	(150)		First Name of the contact on the Service Request
FULL_NAME	VARCHAR2	(360)		Full Name of the contact on the Service Request
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)		Relationship type code of the caller - SR
RELATIONSHIP_TYPE_NAME	VARCHAR2	(80)		Relationship type Name of the caller - SR
CONT_PARTY_NUMBER	VARCHAR2	(30)		Contact Party number - SR
CONT_PHONE	VARCHAR2	(62)		Contact Phone number for SR Contact
CONT_PHONE_LINE_CODE	VARCHAR2	(30)		Phone Type Code for the SR Contact
CONT_PHONE_LINE_TYPE	VARCHAR2	(80)		Phone Type meaning for the SR Contact
CONT_EMAIL	VARCHAR2	(2000)		Contact email for SR contact
PROBLEM_CODE	VARCHAR2	(30)		Problem code
PROBLEM_CODE_MEANING	VARCHAR2	(80)		Problem code meaning
PROBLEM_CODE_DESCRIPTION	VARCHAR2	(240)		Problem code description
EXTERNAL_CONTEXT	VARCHAR2	(30)
EXTERNAL_ATTRIBUTE_1	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_2	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_3	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_4	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_5	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_6	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_7	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_8	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_9	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_10	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_11	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_12	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_13	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_14	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_15	VARCHAR2	(150)

Query Text

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


SELECT ROW_ID
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_URGENCY_ID
,      INCIDENT_SEVERITY_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESC
,      ITEM_REVISION
,      INV_ORGANIZATION_ID
,      CUST_PHONE
,      CUST_PHONE_LINE_TYPE
,      CUST_PHONE_LINE_CODE
,      EXT
,      CALLER
,      INCIDENT_DATE
,      CUSTOMER_PRODUCT_ID
,      RECORD_IS_VALID_FLAG
,      ORG_ID
,      OWNER_TYPE
,      INCIDENT_OWNER_ID
,      INCIDENT_OWNER
,      CALLER_TYPE
,      INCIDENT_TYPE
,      SEVERITY
,      STATUS
,      URGENCY
,      CREATED_BY_NAME
,      FILED_BY_EMPLOYEE_FLAG
,      CUSTOMER_ID
,      EMPLOYEE_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      CURRENT_SERIAL_NUMBER
,      INSTALL_SITE_USE_ID
,      CP_INSTALL_SITE_USE_ID
,      SITE
,      INCIDENT_ALLOWED_FLAG
,      ADDRESS_STYLE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      CITY
,      COUNTY
,      POSTAL_CODE
,      PROVINCE
,      STATE
,      REFERENCE_NUMBER
,      DATE_CLOSED
,      CLOSED_FLAG
,      LOGGED_BY_NAME
,      PUBLISH_FLAG
,      CONTRACT_SERVICE_ID
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      ACCOUNT_ID
,      CUSTOMER_PO_NUMBER
,      ACCOUNT_NUMBER
,      SUMMARY
,      BILL_TO_ADDRESS
,      SHIP_TO_ADDRESS
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      CONTACT_POINT_ID
,      CONTACT_TYPE
,      LAST_NAME
,      FIRST_NAME
,      FULL_NAME
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_TYPE_NAME
,      CONT_PARTY_NUMBER
,      CONT_PHONE
,      CONT_PHONE_LINE_CODE
,      CONT_PHONE_LINE_TYPE
,      CONT_EMAIL
,      PROBLEM_CODE
,      PROBLEM_CODE_MEANING
,      PROBLEM_CODE_DESCRIPTION
,      EXTERNAL_CONTEXT
,      EXTERNAL_ATTRIBUTE_1
,      EXTERNAL_ATTRIBUTE_2
,      EXTERNAL_ATTRIBUTE_3
,      EXTERNAL_ATTRIBUTE_4
,      EXTERNAL_ATTRIBUTE_5
,      EXTERNAL_ATTRIBUTE_6
,      EXTERNAL_ATTRIBUTE_7
,      EXTERNAL_ATTRIBUTE_8
,      EXTERNAL_ATTRIBUTE_9
,      EXTERNAL_ATTRIBUTE_10
,      EXTERNAL_ATTRIBUTE_11
,      EXTERNAL_ATTRIBUTE_12
,      EXTERNAL_ATTRIBUTE_13
,      EXTERNAL_ATTRIBUTE_14
,      EXTERNAL_ATTRIBUTE_15
FROM APPS.CSD_INCIDENTS_V;

Dependencies

[top of page]

APPS.CSD_INCIDENTS_V references the following:

APPS: AR_LOOKUPS; CSD_PROCESS_UTIL - show dependent code; CSI_INSTANCE_STATUSES; CSI_ITEM_INSTANCES; CS_HZ_SR_CONTACT_POINTS; CS_INCIDENTS_VL_SEC; CS_INCIDENT_SEVERITIES_VL; CS_INCIDENT_STATUSES_VL; CS_INCIDENT_TYPES_VL; CS_INCIDENT_URGENCIES_B; CS_INCIDENT_URGENCIES_TL; CS_LOOKUPS; CS_STD - show dependent code; FND_GLOBAL - show dependent code; FND_USER; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOOKUPS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; HZ_CONTACT_POINTS; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; HZ_RELATIONSHIPS; HZ_TIMEZONES; JTF_CUST_ACCOUNTS_ALL_V; JTF_PARTIES_ALL_V; MTL_SYSTEM_ITEMS_VL; PER_ALL_PEOPLE_F; PER_EMPLOYEES_CURRENT_X; PER_PHONES

APPS.CSD_INCIDENTS_V is referenced by following:

APPS: CSD_BULK_RECEIVE_UTIL - show dependent code; CSD_DEPOT_UPDATE_PVT - show dependent code; CSD_ISUP_DEPOT_WF_PVT - show dependent code; CSD_REPAIRS_PVT - show dependent code; CSD_RULES_ENGINE_PVT - show dependent code; CSD_WF_PROCESS_PVT - show dependent code