[Home] [Help] [Dependency Information]
Object Name: | CS_SERVICE_REQUEST_PUB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SERVICE_REQUEST_PUB_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Service Request Public View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
SERVICE_REQUEST_NUMBER | VARCHAR2 | (64) | Yes | Service Request Number from cs_incidents_all_b table |
SERVICE_REQUEST_ID | NUMBER | (15) | Yes | Service Request ID from cs_incidents_all_b table. |
SERVICE_REQUEST_SUMMARY | VARCHAR2 | (240) | Yes | Service Request Summary from cs_incidents_all_b table. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number from cs_incidents_all_b table | |
RESOLVE_BY_DATE | DATE | Incident Resolved by Date | ||
REPORTED_DATE | DATE | Incident Reported date | ||
INCIDENT_LAST_MODIFIED_DATE | DATE | Incident Last Modified date | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
GROUP_OWNER_NAME | VARCHAR2 | (60) | Service Request Group Owner Name | |
OWNER_NAME | VARCHAR2 | (360) | Service Request Resource Owner Name | |
INCIDENT_DATE | DATE | Incident Occurred Date | ||
RESOLVED_ON_DATE | DATE | Service Request Resolved on Date | ||
RESPONDED_ON_DATE | DATE | Service Request Responded on Date | ||
DATE_CLOSED | DATE | Date service request closed | ||
RESPOND_BY_DATE | DATE | Service Request responded by date | ||
SR_CREATION_CHANNEL | VARCHAR2 | (50) | Service Request Creation Channel | |
INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | Service Request Incident Location Type | |
INCIDENT_LOCATION_ID | NUMBER | Service Request Incident Location ID | ||
SERVICE_REQUEST_TYPE | VARCHAR2 | (90) | Yes | Service Request Type |
SEVERITY | VARCHAR2 | (90) | Yes | Service Request Severity |
STATUS | VARCHAR2 | (90) | Yes | Service Request Status |
OPEN_FLAG | VARCHAR2 | (3) | Yes | Service Request Open/Close flag indicator |
URGENCY | VARCHAR2 | (90) | Service Request Urgency | |
ITEM_NUMBER | VARCHAR2 | (40) | Service Request Inventory Item | |
ITEM_REVISION | VARCHAR2 | (240) | Service Request Inventory Item Revision | |
CUSTOMER_ID | NUMBER | (15) | Yes | Service Request Customer ID |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Service Request Customer Name |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | Service Request Customer Number |
CUSTOMER_TYPE | VARCHAR2 | (30) | Yes | Service Request Customer Type |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Customer Account Number | |
PROBLEM_CODE | VARCHAR2 | (80) | Service Request Problem Code | |
RESOLUTION_CODE | VARCHAR2 | (80) | Service Request Resolution Code | |
ITEM_INSTANCE_ID | VARCHAR2 | (30) | Install Base Instance Number | |
INSTANCE_REVISION | VARCHAR2 | (240) | Install Base Item revision from cs_incidents_all_b table |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SERVICE_REQUEST_NUMBER
, SERVICE_REQUEST_ID
, SERVICE_REQUEST_SUMMARY
, OBJECT_VERSION_NUMBER
, RESOLVE_BY_DATE
, REPORTED_DATE
, INCIDENT_LAST_MODIFIED_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, GROUP_OWNER_NAME
, OWNER_NAME
, INCIDENT_DATE
, RESOLVED_ON_DATE
, RESPONDED_ON_DATE
, DATE_CLOSED
, RESPOND_BY_DATE
, SR_CREATION_CHANNEL
, INCIDENT_LOCATION_TYPE
, INCIDENT_LOCATION_ID
, SERVICE_REQUEST_TYPE
, SEVERITY
, STATUS
, OPEN_FLAG
, URGENCY
, ITEM_NUMBER
, ITEM_REVISION
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_TYPE
, ACCOUNT_NUMBER
, PROBLEM_CODE
, RESOLUTION_CODE
, ITEM_INSTANCE_ID
, INSTANCE_REVISION
FROM APPS.CS_SERVICE_REQUEST_PUB_V;
APPS.CS_SERVICE_REQUEST_PUB_V is not referenced by any database object
|
|
|