[Home] [Help] [Dependency Information]
Object Name: | CS_SR_REPORT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SR_REPORT_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 |
---|---|---|---|---|
INCIDENT_ID | NUMBER | (15) | Yes | Incident_id from cs_incidents_all_b |
INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Service request Incident Number |
INVENTORY_ITEM_ID | NUMBER | (15) | Inventory Item Id from cs_incidents_all_b | |
PRODUCT_NAME | VARCHAR2 | (40) | Product name from mtl_system_items_kfv | |
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Product description from mtl_system_items_kfv | |
INCIDENT_DATE | DATE | Incident date from cs_incidents_all_b | ||
CUSTOMER_ID | NUMBER | (15) | Customer Id | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number from hz_parties | |
COMPANY_NAME | VARCHAR2 | (360) | Customer Name from hz_parties | |
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
CUSTOMER_PRODUCT_ID | NUMBER | (15) | Customer Product Id | |
REFERENCE_NUMBER | VARCHAR2 | (30) | Reference Number from CS_CUSTOMER_PRODUCTS | |
PROBLEM_CODE | VARCHAR2 | (30) | Problem Code | |
PROBLEM_CODE_MEANING | VARCHAR2 | (80) | Problem meaning | |
PROBLEM_CODE_DESCRIPTION | VARCHAR2 | (240) | Problem description | |
RESOLUTION_CODE | VARCHAR2 | (30) | Resolution code | |
RESOLUTION_CODE_MEANING | VARCHAR2 | (80) | Resolution meaning | |
RESOLUTION_CODE_DESCRIPTION | VARCHAR2 | (240) | Resolution description | |
INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Service Request Type Id |
INCIDENT_TYPE | VARCHAR2 | (90) | Yes | Service Request Type Name |
INCIDENT_SEVERITY_ID | NUMBER | (15) | Yes | Service Request Severity Id |
SEVERITY | VARCHAR2 | (90) | Yes | Service Request Severity name |
INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Service Request Status Id |
STATUS_CODE | VARCHAR2 | (90) | Yes | Service Request Status Code |
INCIDENT_URGENCY_ID | NUMBER | (15) | Service Request Urgency Id | |
URGENCY | VARCHAR2 | (90) | Service Request Urgency name | |
OWNER | VARCHAR2 | (360) | Service Request Owner | |
SUMMARY | VARCHAR2 | (240) | Yes | Summary |
DATE_CLOSED | DATE | Date Service Request Closed | ||
CLOSED_FLAG | VARCHAR2 | (1) | Service Request Closed Flag | |
LOGGED_BY_NAME | VARCHAR2 | (100) | Yes | Service Request Logged by name |
RECORD_IS_VALID_FLAG | VARCHAR2 | (1) | Record valid flag |
Cut, paste (and edit) the following text to query this object:
SELECT INCIDENT_ID
, INCIDENT_NUMBER
, INVENTORY_ITEM_ID
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, INCIDENT_DATE
, CUSTOMER_ID
, CUSTOMER_NUMBER
, COMPANY_NAME
, CURRENT_SERIAL_NUMBER
, CUSTOMER_PRODUCT_ID
, REFERENCE_NUMBER
, PROBLEM_CODE
, PROBLEM_CODE_MEANING
, PROBLEM_CODE_DESCRIPTION
, RESOLUTION_CODE
, RESOLUTION_CODE_MEANING
, RESOLUTION_CODE_DESCRIPTION
, INCIDENT_TYPE_ID
, INCIDENT_TYPE
, INCIDENT_SEVERITY_ID
, SEVERITY
, INCIDENT_STATUS_ID
, STATUS_CODE
, INCIDENT_URGENCY_ID
, URGENCY
, OWNER
, SUMMARY
, DATE_CLOSED
, CLOSED_FLAG
, LOGGED_BY_NAME
, RECORD_IS_VALID_FLAG
FROM APPS.CS_SR_REPORT_V;
APPS.CS_SR_REPORT_V is not referenced by any database object
|
|
|