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_DUPLICATE_CHECK_V

Object Details

Object Name:	CS_SR_DUPLICATE_CHECK_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_DUPLICATE_CHECK_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

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER	(15)	Yes	This column will store the service request id (incident id)
SUMMARY	VARCHAR2	(240)	Yes	This column stores the summary of the Service Request
STATUS	VARCHAR2	(90)	Yes	This column stores the service request status
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	This column stores the service request number (incident number)
CREATION_DATE	DATE		Yes	This column stores the creation date of the Service Request
TYPE	VARCHAR2	(90)	Yes	This column stores the type of the Service Request
PROBLEM_CODE	VARCHAR2	(50)		This column stores the problem code associated to the Service Request
PARTY_NAME	VARCHAR2	(360)	Yes	This column stores the customer name of the Service Request customer
CUSTOMER_PRODUCT_ID	NUMBER	(15)		This column stores the internal id of the instance associated to the SR
INVENTORY_ITEM_ID	NUMBER	(15)		This column stores the internal id of the product associated to the Service Request
MAINTENANCE_FLAG	VARCHAR2	(3)		This column is set to 'Y' for eAM products in SR
INV_ORGANIZATION_ID	NUMBER			This column stores the inventory organization id

Query Text

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


SELECT INCIDENT_ID
,      SUMMARY
,      STATUS
,      INCIDENT_NUMBER
,      CREATION_DATE
,      TYPE
,      PROBLEM_CODE
,      PARTY_NAME
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      MAINTENANCE_FLAG
,      INV_ORGANIZATION_ID
FROM APPS.CS_SR_DUPLICATE_CHECK_V;

Dependencies

[top of page]

APPS.CS_SR_DUPLICATE_CHECK_V references the following:

APPS: CS_INCIDENTS_ALL_VL; CS_INCIDENT_STATUSES_VL; CS_INCIDENT_TYPES_VL; HZ_PARTIES

APPS.CS_SR_DUPLICATE_CHECK_V is not referenced by any database object