[Home] [Help] [Dependency Information]
Object Name: | CS_INCIDENTS_DIARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_INCIDENTS_DIARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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. |
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;
|
|
|