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_KB_SOLUTION_LINKS_V

Object Details

Object Name:	CS_SR_KB_SOLUTION_LINKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_KB_SOLUTION_LINKS_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_NUMBER	VARCHAR2	(64)	Yes	This column stores the SR number (incident number)
SET_ID	NUMBER	(15)	Yes	This column stores the solution id
SET_NUMBER	VARCHAR2	(30)	Yes	This column stores the solution number
SET_NAME	VARCHAR2	(500)	Yes	This column stores the solution name
SET_VISIBILITY_ID	NUMBER	(15)	Yes	This column stores thevisibility id of the solution
SET_LINK_TYPE	VARCHAR2	(30)	Yes	This column stores the link type of the solution
SET_LINK_TYPE_MEANING	VARCHAR2	(80)		This column stores the outcome of the solution
SET_PUBLISHED_STATUS	VARCHAR2	(6)		This column storesthe status of the solution
SET_LAST_UPDATE_DATE	DATE		Yes	This column stores the last update date of the solution
OBJECT_CODE	VARCHAR2	(30)	Yes	This column stores thesource object code
OTHER_ID	NUMBER		Yes	This column stores thesource_object_id
SET_TYPE_NAME	VARCHAR2	(100)	Yes	This column stores the solution_type
VISIBILITY_NAME	VARCHAR2	(80)	Yes	This column stores the access level of the solution.
CREATION_DATE	DATE		Yes	The value in this column stores the creation date of the link

Query Text

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


SELECT INCIDENT_NUMBER
,      SET_ID
,      SET_NUMBER
,      SET_NAME
,      SET_VISIBILITY_ID
,      SET_LINK_TYPE
,      SET_LINK_TYPE_MEANING
,      SET_PUBLISHED_STATUS
,      SET_LAST_UPDATE_DATE
,      OBJECT_CODE
,      OTHER_ID
,      SET_TYPE_NAME
,      VISIBILITY_NAME
,      CREATION_DATE
FROM APPS.CS_SR_KB_SOLUTION_LINKS_V;

Dependencies

[top of page]

APPS.CS_SR_KB_SOLUTION_LINKS_V references the following:

APPS: CS_INCIDENTS_ALL_B; CS_KB_LINKED_SOLUTIONS_VIEW; CS_KB_SECURITY_PVT - show dependent code; CS_KB_SET_LINKS; FND_GLOBAL - show dependent code

APPS.CS_SR_KB_SOLUTION_LINKS_V is not referenced by any database object