DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CS_SR_SERVICE_HISTORY_V

Object Details
Object Name: CS_SR_SERVICE_HISTORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_SERVICE_HISTORY_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 Service request number
INCIDENT_ID NUMBER (15) Yes Service request identifier.
CUSTOMER_ID NUMBER (15)
Customer identifier
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
PRODUCT_NAME VARCHAR2 (40)
Name of the product
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description for the product
DATE_OPENED DATE

Service request date
DATE_CLOSED DATE

Date when the Service Request closed.
STATUS_NAME VARCHAR2 (90) Yes Status of the service request
INCIDENT_STATUS_ID NUMBER (15) Yes Identifier for service request status
TYPE_NAME VARCHAR2 (90) Yes Type of the service request
INCIDENT_TYPE_ID NUMBER (15) Yes Identifier for service request type
SUMMARY VARCHAR2 (240) Yes Service request summary
SERIAL_NUMBER VARCHAR2 (30)
This value depends on customer_product_id ie If customer_product_id is null then it will be serial number for a product which is not in Installed Base otherwise it will be a serial number for a product which is in installed base.
PROBLEM_CODE_MEANING VARCHAR2 (80)
Meaning of the problem code
RESOLUTION_CODE_MEANING VARCHAR2 (80)
Meaning of the resolution code
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer Product Identifier
CP_COMPONENT_ID NUMBER

Identifier for Installed Base Component.
CP_SUBCOMPONENT_ID NUMBER

Identifier for Installed Base Sub-Component.
INVENTORY_ITEM_ID NUMBER (15)
Item identifier
INV_COMPONENT_ID NUMBER

Identifier for the Component for a product not in Installed Base.
INV_SUBCOMPONENT_ID NUMBER

Identifier for the Sub-Component for a product not in Installed Base.
GROUP_TYPE VARCHAR2 (30)
Service request group owner type.
GROUP_NAME VARCHAR2 (30)
Service request group owner.
INDIVIDUAL_TYPE VARCHAR2 (30)
Service request individual owner type.
INDIVIDUAL_NAME VARCHAR2 (30)
Service request individual owner.
OWNER_GROUP_ID NUMBER

The owner group identifier.
INCIDENT_OWNER_ID NUMBER (15)
The incident owner identifier.
GROUP_OWNER VARCHAR2 (60)
Name of the Group
OWNER VARCHAR2 (360)
Name of the Service Request Owner
Query Text

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


SELECT INCIDENT_NUMBER
,      INCIDENT_ID
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      DATE_OPENED
,      DATE_CLOSED
,      STATUS_NAME
,      INCIDENT_STATUS_ID
,      TYPE_NAME
,      INCIDENT_TYPE_ID
,      SUMMARY
,      SERIAL_NUMBER
,      PROBLEM_CODE_MEANING
,      RESOLUTION_CODE_MEANING
,      CUSTOMER_PRODUCT_ID
,      CP_COMPONENT_ID
,      CP_SUBCOMPONENT_ID
,      INVENTORY_ITEM_ID
,      INV_COMPONENT_ID
,      INV_SUBCOMPONENT_ID
,      GROUP_TYPE
,      GROUP_NAME
,      INDIVIDUAL_TYPE
,      INDIVIDUAL_NAME
,      OWNER_GROUP_ID
,      INCIDENT_OWNER_ID
,      GROUP_OWNER
,      OWNER
FROM APPS.CS_SR_SERVICE_HISTORY_V;

Dependencies

[top of page]

APPS.CS_SR_SERVICE_HISTORY_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_TL
ViewCS_INCIDENTS_B_SEC
SynonymCS_INCIDENT_STATUSES_TL
SynonymCS_INCIDENT_TYPES_TL
ViewCS_LOOKUPS
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_PARTIES
ViewJTF_OBJECTS_VL
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_SERVICE_HISTORY_V is not referenced by any database object