[Home] [Help] [Dependency Information]
Object Name: | CS_INCIDENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_INCIDENTS_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Rowid from the base table | |
INCIDENT_ID | NUMBER | (15) | Yes | Service request identifier |
ORG_ID | NUMBER | Operating unit identifier | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Service request number |
INCIDENT_NUMBER_N | VARCHAR2 | (64) | Yes | Service request number stored a number |
INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Identifier for service request status |
INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Identifier for service request type |
INCIDENT_URGENCY_ID | NUMBER | (15) | Identifier for service request urgency | |
INCIDENT_SEVERITY_ID | NUMBER | (15) | Yes | Identifier for service request severity |
SUMMARY | VARCHAR2 | (240) | Yes | Service request summary |
INCIDENT_OWNER_ID | NUMBER | (15) | Identifier for the owner of the service request | |
RESOURCE_TYPE | VARCHAR2 | (30) | Identifier for the owner type of the service request. The owner type could be an Employee, a Group or a Team. | |
RESOURCE_SUBTYPE_ID | NUMBER | Not used. | ||
INVENTORY_ITEM_ID | NUMBER | (15) | Item identifier | |
SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifier for ship- to site use | |
SHIP_TO_CONTACT_ID | NUMBER | (15) | Ship-to contact identifier | |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Identifier for bill-to site use | |
BILL_TO_CONTACT_ID | NUMBER | (15) | Bill-to contact identifier | |
INSTALL_SITE_USE_ID | NUMBER | (15) | Identifier for installed site use | |
PROBLEM_CODE | VARCHAR2 | (50) | Problem code | |
EXPECTED_RESOLUTION_DATE | DATE | Expected date for the problem resolution | ||
ACTUAL_RESOLUTION_DATE | DATE | Actual date of resolution | ||
INCIDENT_DATE | DATE | Service request date | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | Customer product identifier | |
INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
INCIDENT_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
RECORD_IS_VALID_FLAG | VARCHAR2 | (1) | Flag to denote if the service request is verified or not | |
RESOLUTION_CODE | VARCHAR2 | (50) | Problem resolution quick code | |
INTERFACED_TO_DEPOT_FLAG | VARCHAR2 | (1) | Flag to denote service request is linked to repairs | |
INCIDENT_TYPE | VARCHAR2 | (90) | Yes | Incident Type name |
SEVERITY | VARCHAR2 | (90) | Yes | Severity Name |
STATUS_CODE | VARCHAR2 | (90) | Yes | Status name |
URGENCY | VARCHAR2 | (90) | Urgency Name | |
CREATED_BY_NAME | VARCHAR2 | (100) | Yes | Name of the identity who created the Service Request |
PRODUCT_REVISION | VARCHAR2 | (15) | Revision of the product | |
FILED_BY_EMPLOYEE_FLAG | VARCHAR2 | (1) | Indicates whether the request was made by an employee | |
CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
ACCOUNT_ID | NUMBER | Account Identifier | ||
EMPLOYEE_ID | NUMBER | (15) | Identifier for the employee if the service request is made by an employee | |
EMPLOYEE_NAME | VARCHAR2 | (240) | Name of the Employee | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | A number to uniquely identify the employee. | |
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number for an Installed Base product | |
CURRENT_SERIAL_NUMBER_NV | VARCHAR2 | (30) | Serial Number for a product that is not in Installed Base | |
SYSTEM_ID | NUMBER | Not used | ||
SYSTEM_NAME | VARCHAR2 | (50) | System Name | |
CP_INSTALL_SITE_USE_ID | NUMBER | Identifier for installed site use | ||
REFERENCE_NUMBER | VARCHAR2 | (30) | Unique reference for a customer product | |
CUSTOMER_PRODUCT_STATUS_ID | NUMBER | Status identifier of a customer product | ||
CUSTOMER_PRODUCT_STATUS | VARCHAR2 | (50) | Customer Product Status name | |
PRODUCT_SUPPORT_CUSTOMER_ID | NUMBER | Not Used | ||
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | The purchase order number for a product. | |
ORIGINAL_ORDER_NUMBER | NUMBER | Original Sales Order Number | ||
INCIDENT_ALLOWED_FLAG | VARCHAR2 | (1) | Incident Allowed Flag | |
PROBLEM_CODE_MEANING | VARCHAR2 | (80) | Meaning of the Problem Code | |
PROBLEM_CODE_DESCRIPTION | VARCHAR2 | (240) | Description for the Problem Code | |
RESOLUTION_CODE_MEANING | VARCHAR2 | (80) | Meaning of the Resolution Code | |
RESOLUTION_CODE_DESCRIPTION | VARCHAR2 | (240) | Description for the Resolution Code | |
WORKFLOW_PROCESS_ID | NUMBER | Sequence number used for this action's last workflow process | ||
LAST_INCIDENT_UPDATE_DATE_V | DATE | Date when the Service Request was last updated. | ||
RELATED_STATUSES_CNT_V | NUMBER | Count of the Related Statuses for a given Incident Type. | ||
DATE_CLOSED | DATE | Date when the Service Request closed. | ||
LOGGED_BY_NAME | VARCHAR2 | (100) | Yes | Name by whom the Service Request by logged. |
CLOSED_FLAG | VARCHAR2 | (1) | Flag to denote whether the service request is closed or not. | |
PUBLISH_FLAG | VARCHAR2 | (1) | Flag to denote whether the service request is published or not. | |
QA_COLLECTION_ID | NUMBER | Foreign key to Quality results table | ||
CONTRACT_SERVICE_ID | NUMBER | Service line unique identifier | ||
KB_SOLUTION_ID | VARCHAR2 | (240) | External knowledge base solution identifier. | |
TIME_ZONE_ID | NUMBER | (15) | This field stores the time zone id of the time zone specified in the service request form | |
CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer's Purchase Order number. | |
CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Customer's internal helpdesk tracking number. | |
OBLIGATION_DATE | DATE | Obligation Date | ||
SITE_ID | NUMBER | Identifier for Support Site. | ||
CUSTOMER_SITE_ID | NUMBER | Identifier for Customer Site. | ||
SR_CREATION_CHANNEL | VARCHAR2 | (50) | Source of channel through which a Service Request is created. The channel of creation. | |
PLATFORM_VERSION_ID | NUMBER | Identifier for Platform Version. | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CALLER_TYPE | VARCHAR2 | (30) | Type of the Calling Party. It could be an Organization, Person, Employee. | |
CP_COMPONENT_ID | NUMBER | Identifier for Installed Base Component. | ||
CP_COMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Component Revision. | ||
CP_SUBCOMPONENT_ID | NUMBER | Identifier for Installed Base Subcomponent. | ||
CP_SUBCOMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Subcomponent Revision. | ||
CP_REVISION_ID | NUMBER | Identifier for Installed Base Product Revision. | ||
INV_ITEM_REVISION | VARCHAR2 | (240) | Identifier for the Item Revision for a product not in Installed Base. | |
INV_COMPONENT_ID | NUMBER | Identifier for the Component for a product not in Installed Base. | ||
INV_COMPONENT_VERSION | VARCHAR2 | (90) | Identifier for the Component Revision for a product not in Installed Base. | |
INV_SUBCOMPONENT_ID | NUMBER | Identifier for the Subcomponent for a product not in Installed Base. | ||
INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | Identifier for the Subcomponent Revision for a product not in Installed Base. | |
INV_ORGANIZATION_ID | NUMBER | This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | ||
PLATFORM_ID | NUMBER | Identifier for Platform. | ||
LANGUAGE_ID | NUMBER | Identifier for the Product's Language. | ||
TERRITORY_ID | NUMBER | Identifier for the Territory of the Service Request. | ||
TIME_DIFFERENCE | NUMBER | GMT offset of the contact person's time. | ||
PRODUCT_NAME | VARCHAR2 | (40) | Name of the product | |
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Description for the product | |
OWNER | VARCHAR2 | (360) | Service Request Owner's name | |
COMPANY_NAME | VARCHAR2 | (360) | Customer Name for whom the Service Request is created | |
PERSON_FIRST_NAME | VARCHAR2 | (150) | Contact person's first name | |
PERSON_LAST_NAME | VARCHAR2 | (150) | Contact person's last name | |
CONTACT_NAME | VARCHAR2 | (301) | Contact person's full name | |
COUNTRY_CODE | VARCHAR2 | (10) | Country code of the contact's phone | |
AREA_CODE | VARCHAR2 | (10) | Area code of the contact's phone | |
PHONE_NUMBER | VARCHAR2 | (40) | Number of the contact's phone | |
PHONE | VARCHAR2 | (62) | Contact's phone number | |
EXT | VARCHAR2 | (20) | Contact's phone extension | |
VARCHAR2 | (2000) | Contact's email address | ||
PHONE_TYPE | VARCHAR2 | (30) | Communication type for the Contact. e.g. Phone/Fax/Cell | |
TIME_ZONE_NAME | VARCHAR2 | (50) | This field stores the time zone name of the time zone specified in the service request form | |
CONTACT_PARTY_ID | NUMBER | Contact Identifier | ||
CONTACT_POINT_ID | NUMBER | Unique identifier of this contact point | ||
ACCOUNT | VARCHAR2 | (30) | Account Number | |
CALLER_TYPE_NAME | VARCHAR2 | (80) | Name of Caller Type | |
CALLER_TYPE_DESCRIPTION | VARCHAR2 | (240) | Description of Caller Type | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Version Number of Object from CS_INCIDENTS_ALL_B. | |
PERSON_TITLE | VARCHAR2 | (30) | Person Title | |
CONTACT_TYPE | VARCHAR2 | (30) | Contact Type | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number associated with a Service Request | |
CONTRACT_ID | NUMBER | Header Id of the Contract Line associated with a Service Request | ||
PROJECT_NUMBER | VARCHAR2 | (120) | Project Number associated with a Service Request | |
ERROR_CODE | VARCHAR2 | (250) | Error Code |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INCIDENT_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INCIDENT_NUMBER
, INCIDENT_NUMBER_N
, INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID
, INCIDENT_SEVERITY_ID
, SUMMARY
, INCIDENT_OWNER_ID
, RESOURCE_TYPE
, RESOURCE_SUBTYPE_ID
, INVENTORY_ITEM_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, BILL_TO_SITE_USE_ID
, BILL_TO_CONTACT_ID
, INSTALL_SITE_USE_ID
, PROBLEM_CODE
, EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, INCIDENT_DATE
, CUSTOMER_PRODUCT_ID
, INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_15
, INCIDENT_CONTEXT
, RECORD_IS_VALID_FLAG
, RESOLUTION_CODE
, INTERFACED_TO_DEPOT_FLAG
, INCIDENT_TYPE
, SEVERITY
, STATUS_CODE
, URGENCY
, CREATED_BY_NAME
, PRODUCT_REVISION
, FILED_BY_EMPLOYEE_FLAG
, CUSTOMER_ID
, ACCOUNT_ID
, EMPLOYEE_ID
, EMPLOYEE_NAME
, EMPLOYEE_NUMBER
, CURRENT_SERIAL_NUMBER
, CURRENT_SERIAL_NUMBER_NV
, SYSTEM_ID
, SYSTEM_NAME
, CP_INSTALL_SITE_USE_ID
, REFERENCE_NUMBER
, CUSTOMER_PRODUCT_STATUS_ID
, CUSTOMER_PRODUCT_STATUS
, PRODUCT_SUPPORT_CUSTOMER_ID
, PURCHASE_ORDER_NUM
, ORIGINAL_ORDER_NUMBER
, INCIDENT_ALLOWED_FLAG
, PROBLEM_CODE_MEANING
, PROBLEM_CODE_DESCRIPTION
, RESOLUTION_CODE_MEANING
, RESOLUTION_CODE_DESCRIPTION
, WORKFLOW_PROCESS_ID
, LAST_INCIDENT_UPDATE_DATE_V
, RELATED_STATUSES_CNT_V
, DATE_CLOSED
, LOGGED_BY_NAME
, CLOSED_FLAG
, PUBLISH_FLAG
, QA_COLLECTION_ID
, CONTRACT_SERVICE_ID
, KB_SOLUTION_ID
, TIME_ZONE_ID
, CUSTOMER_PO_NUMBER
, CUSTOMER_TICKET_NUMBER
, OBLIGATION_DATE
, SITE_ID
, CUSTOMER_SITE_ID
, SR_CREATION_CHANNEL
, PLATFORM_VERSION_ID
, CUSTOMER_NUMBER
, CALLER_TYPE
, CP_COMPONENT_ID
, CP_COMPONENT_VERSION_ID
, CP_SUBCOMPONENT_ID
, CP_SUBCOMPONENT_VERSION_ID
, CP_REVISION_ID
, INV_ITEM_REVISION
, INV_COMPONENT_ID
, INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION
, INV_ORGANIZATION_ID
, PLATFORM_ID
, LANGUAGE_ID
, TERRITORY_ID
, TIME_DIFFERENCE
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, OWNER
, COMPANY_NAME
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, CONTACT_NAME
, COUNTRY_CODE
, AREA_CODE
, PHONE_NUMBER
, PHONE
, EXT
, EMAIL
, PHONE_TYPE
, TIME_ZONE_NAME
, CONTACT_PARTY_ID
, CONTACT_POINT_ID
, ACCOUNT
, CALLER_TYPE_NAME
, CALLER_TYPE_DESCRIPTION
, OBJECT_VERSION_NUMBER
, PERSON_TITLE
, CONTACT_TYPE
, CONTRACT_NUMBER
, CONTRACT_ID
, PROJECT_NUMBER
, ERROR_CODE
FROM APPS.CS_INCIDENTS_V;
|
|
|