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_INCIDENTS_DIARY_V

Object Details

Object Name:	CS_INCIDENTS_DIARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_INCIDENTS_DIARY_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	Comments
SOURCE_TYPE	CHAR	(5)	Source Type
INCIDENT_ID	NUMBER	(15)	Service request identifier
INCIDENT_DATE	DATE		Service request date
OWNER	VARCHAR2	(100)	Owner
ACTION_ID	NUMBER		Action Id
LAST_UPDATE_DATE	DATE		Last Update Date
DETAILS	VARCHAR2	(4000)	Details
NOTE_STATUS	VARCHAR2	(1)	Status of Notes
SEVERITY_OLD	VARCHAR2	(40)	Old Severity
SEVERITY_NEW	VARCHAR2	(40)	New Severity
INCIDENT_SEVERITY_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
TYPE_OLD	VARCHAR2	(40)	Old Type
TYPE_NEW	VARCHAR2	(40)	New Type
INCIDENT_TYPE_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
STATUS_OLD	VARCHAR2	(40)	Old Status
STATUS_NEW	VARCHAR2	(40)	New Status
INCIDENT_STATUS_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
URGENCY_OLD	VARCHAR2	(40)	Old Urgency
URGENCY_NEW	VARCHAR2	(40)	New Urgency
INCIDENT_URGENCY_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
GROUP_OLD	VARCHAR2	(40)	Old Group
GROUP_NEW	VARCHAR2	(40)	New Group
RESPONSIBLE_GROUP_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
OWNER_OLD	VARCHAR2	(40)	Old Owner
OWNER_NEW	VARCHAR2	(40)	New Owner
INCIDENT_OWNER_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
DATE_OLD	VARCHAR2	(9)	Old Date
DATE_NEW	VARCHAR2	(9)	New Date
RESOLUTION_DATE_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
OBLIGATION_DATE_OLD	VARCHAR2	(9)	Old Obligation Date
OBLIGATION_DATE_NEW	VARCHAR2	(9)	New Obligation Date
OBLIGATION_DATE_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
SITE_ID_NEW	VARCHAR2	(40)	New Site Id
SITE_ID_OLD	VARCHAR2	(40)	Old Site Id
SITE_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
BILL_TO_CONTACT_ID_NEW	VARCHAR2	(40)	New Bill to Contact Id
BILL_TO_CONTACT_ID_OLD	VARCHAR2	(40)	Old Bill to Contact Id
BILL_TO_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
SHIP_TO_CONTACT_ID_NEW	VARCHAR2	(40)	New Ship to Contact Id
SHIP_TO_CONTACT_ID_OLD	VARCHAR2	(40)	Old Ship to Contact Id
SHIP_TO_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
PLATFORM_ID_NEW	VARCHAR2	(40)	New Platform Id
PLATFORM_ID_OLD	VARCHAR2	(40)	Old Platform Id
PLATFORM_ID_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
PLATFORM_VERSION_ID_NEW	VARCHAR2	(40)	New Platform version Id
PLATFORM_VERSION_ID_OLD	VARCHAR2	(40)	Old Platform version Id
PLAT_VER_ID_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
CUSTOMER_PRODUCT_ID_NEW	VARCHAR2	(40)	New Customer Product Id
CUSTOMER_PRODUCT_ID_OLD	VARCHAR2	(40)	Old Customer Product Id
CUSTOMER_PRODUCT_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
LANGUAGE_ID_NEW	VARCHAR2	(40)	New Language Id
LANGUAGE_ID_OLD	VARCHAR2	(40)	Old Language Id
LANGUAGE_ID_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.
OLD_SEVERITY_NAME	VARCHAR2	(90)	Old Severity Name
NEW_SEVERITY_NAME	VARCHAR2	(90)	New Severity Name
OLD_TYPE_NAME	VARCHAR2	(90)	Old Type Name
NEW_TYPE_NAME	VARCHAR2	(90)	New Type Name
OLD_STATUS_NAME	VARCHAR2	(90)	Old StatusName
NEW_STATUS_NAME	VARCHAR2	(90)	New StatusName
OLD_URGENCY_NAME	VARCHAR2	(90)	Old Urgency Name
NEW_URGENCY_NAME	VARCHAR2	(90)	New Urgency Name
OLD_OWNER	VARCHAR2	(360)	Old Owner
NEW_OWNER	VARCHAR2	(360)	New Owner
OLD_BILL_TO_CONTACT_NAME	VARCHAR2	(360)	Old Bill to Contact Name
NEW_BILL_TO_CONTACT_NAME	VARCHAR2	(360)	New Bill to Contact Name
OLD_SHIP_TO_CONTACT_NAME	VARCHAR2	(360)	Old Ship to Contact Name
NEW_SHIP_TO_CONTACT_NAME	VARCHAR2	(360)	New Ship to Contact Name
OLD_PLATFORM_NAME	VARCHAR2	(0)	Old Platform Name
NEW_PLATFORM_NAME	VARCHAR2	(0)	New Platform Name
OLD_PLATFORM_VERSION_NAME	VARCHAR2	(0)	Old Platform Version Name
NEW_PLATFORM_VERSION_NAME	VARCHAR2	(0)	New Platform Version Name
OLD_DESCRIPTION	VARCHAR2	(240)	Old Description
NEW_DESCRIPTION	VARCHAR2	(240)	New Description
OLD_LANGUAGE	VARCHAR2	(0)	Old Language
NEW_LANGUAGE	VARCHAR2	(0)	New Language
OLD_RESOURCE_TYPE	VARCHAR2	(30)	The Type of the resource.
RESOURCE_TYPE	VARCHAR2	(30)	The Type of the resource.
CHANGE_RESOURCE_TYPE_FLAG	VARCHAR2	(1)	The flag that indicates if this column in the record has changed.

Query Text

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


SELECT SOURCE_TYPE
,      INCIDENT_ID
,      INCIDENT_DATE
,      OWNER
,      ACTION_ID
,      LAST_UPDATE_DATE
,      DETAILS
,      NOTE_STATUS
,      SEVERITY_OLD
,      SEVERITY_NEW
,      INCIDENT_SEVERITY_FLAG
,      TYPE_OLD
,      TYPE_NEW
,      INCIDENT_TYPE_FLAG
,      STATUS_OLD
,      STATUS_NEW
,      INCIDENT_STATUS_FLAG
,      URGENCY_OLD
,      URGENCY_NEW
,      INCIDENT_URGENCY_FLAG
,      GROUP_OLD
,      GROUP_NEW
,      RESPONSIBLE_GROUP_FLAG
,      OWNER_OLD
,      OWNER_NEW
,      INCIDENT_OWNER_FLAG
,      DATE_OLD
,      DATE_NEW
,      RESOLUTION_DATE_FLAG
,      OBLIGATION_DATE_OLD
,      OBLIGATION_DATE_NEW
,      OBLIGATION_DATE_FLAG
,      SITE_ID_NEW
,      SITE_ID_OLD
,      SITE_FLAG
,      BILL_TO_CONTACT_ID_NEW
,      BILL_TO_CONTACT_ID_OLD
,      BILL_TO_FLAG
,      SHIP_TO_CONTACT_ID_NEW
,      SHIP_TO_CONTACT_ID_OLD
,      SHIP_TO_FLAG
,      PLATFORM_ID_NEW
,      PLATFORM_ID_OLD
,      PLATFORM_ID_FLAG
,      PLATFORM_VERSION_ID_NEW
,      PLATFORM_VERSION_ID_OLD
,      PLAT_VER_ID_FLAG
,      CUSTOMER_PRODUCT_ID_NEW
,      CUSTOMER_PRODUCT_ID_OLD
,      CUSTOMER_PRODUCT_FLAG
,      LANGUAGE_ID_NEW
,      LANGUAGE_ID_OLD
,      LANGUAGE_ID_FLAG
,      OLD_SEVERITY_NAME
,      NEW_SEVERITY_NAME
,      OLD_TYPE_NAME
,      NEW_TYPE_NAME
,      OLD_STATUS_NAME
,      NEW_STATUS_NAME
,      OLD_URGENCY_NAME
,      NEW_URGENCY_NAME
,      OLD_OWNER
,      NEW_OWNER
,      OLD_BILL_TO_CONTACT_NAME
,      NEW_BILL_TO_CONTACT_NAME
,      OLD_SHIP_TO_CONTACT_NAME
,      NEW_SHIP_TO_CONTACT_NAME
,      OLD_PLATFORM_NAME
,      NEW_PLATFORM_NAME
,      OLD_PLATFORM_VERSION_NAME
,      NEW_PLATFORM_VERSION_NAME
,      OLD_DESCRIPTION
,      NEW_DESCRIPTION
,      OLD_LANGUAGE
,      NEW_LANGUAGE
,      OLD_RESOURCE_TYPE
,      RESOURCE_TYPE
,      CHANGE_RESOURCE_TYPE_FLAG
FROM APPS.CS_INCIDENTS_DIARY_V;

Dependencies

[top of page]

APPS.CS_INCIDENTS_DIARY_V references the following:

APPS: CSICUMPI_PUB - show dependent code; CS_CUSTOMER_PRODUCTS_ALL; CS_INCIDENTS_ALL_B; CS_INCIDENTS_AUDIT_VL; CS_INCIDENT_SEVERITIES; CS_INCIDENT_STATUSES; CS_INCIDENT_TYPES; CS_INCIDENT_URGENCIES; CS_SR_OWNERS_V; FND_GLOBAL - show dependent code; FND_USER; JTF_COMMON_PVT - show dependent code; JTF_NOTES_PKG - show dependent code; JTF_NOTES_VL; JTF_OBJECTS_VL; JTF_PARTIES_ALL_V; JTF_TASKS_V; JTF_TASK_UTL - show dependent code; JTF_TASK_WORKFLOW_PKG - show dependent code; MTL_SYSTEM_ITEMS

APPS.CS_INCIDENTS_DIARY_V is referenced by following:

APPS: CS_SR_LOG_PKG - show dependent code