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: ViewCS.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 Mandatory 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:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CUSTOMER_PRODUCTS_ALL
SynonymCS_INCIDENTS_ALL_B
ViewCS_INCIDENTS_AUDIT_VL
SynonymCS_INCIDENT_SEVERITIES
SynonymCS_INCIDENT_STATUSES
SynonymCS_INCIDENT_TYPES
SynonymCS_INCIDENT_URGENCIES
ViewCS_SR_OWNERS_V
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
PL/SQL PackageJTF_COMMON_PVT - show dependent code
PL/SQL PackageJTF_NOTES_PKG - show dependent code
ViewJTF_NOTES_VL
ViewJTF_OBJECTS_VL
ViewJTF_PARTIES_ALL_V
ViewJTF_TASKS_V
PL/SQL PackageJTF_TASK_UTL - show dependent code
PL/SQL PackageJTF_TASK_WORKFLOW_PKG - show dependent code
SynonymMTL_SYSTEM_ITEMS
APPS.CS_INCIDENTS_DIARY_V is referenced by following:

SchemaAPPS
Package BodyCS_SR_LOG_PKG - show dependent code