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

VIEW: APPS.CS_SR_SEARCH_V

Object Details
Object Name: CS_SR_SEARCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_SEARCH_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
ROW_ID ROWID (10)
Row id
INCIDENT_ID NUMBER (15) Yes Incident id
ORG_ID NUMBER

Organization id
LAST_UPDATE_DATE DATE
Yes Date of last update of the record
LAST_UPDATED_BY NUMBER (15) Yes Person who updated the record last
CREATION_DATE DATE
Yes Date the record created
CREATED_BY NUMBER (15) Yes Person who created the record
LAST_UPDATE_LOGIN NUMBER (15)
Login name of the last update
INCIDENT_NUMBER VARCHAR2 (64) Yes Incident no.
INCIDENT_NUMBER_N VARCHAR2 (64) Yes Incident no. in number format
INCIDENT_STATUS_ID NUMBER (15) Yes Incident status id
INCIDENT_TYPE_ID NUMBER (15) Yes Incident type id
INCIDENT_URGENCY_ID NUMBER (15)
Incident urgency id
INCIDENT_SEVERITY_ID NUMBER (15) Yes Incident severity id
SUMMARY VARCHAR2 (240) Yes Summary of the problem
INCIDENT_OWNER_ID NUMBER (15)
Owner id of the SR
RESOURCE_TYPE VARCHAR2 (30)
Resource type
RESOURCE_SUBTYPE_ID NUMBER

Resource subtype id
INVENTORY_ITEM_ID NUMBER (15)
Inventory item id
SHIP_TO_SITE_USE_ID NUMBER (15)
Site id of the place to which goods will be shipped
SHIP_TO_CONTACT_ID NUMBER (15)
Contact id of the person to whom shipment will be done
BILL_TO_SITE_USE_ID NUMBER (15)
Site id to which bills will be despatched
BILL_TO_CONTACT_ID NUMBER (15)
Contact id of the person to whom bills will be despatched
INSTALL_SITE_USE_ID NUMBER (15)
Site id at which installation was done
PROBLEM_CODE VARCHAR2 (80)
Problem code
EXPECTED_RESOLUTION_DATE DATE

Date the resolution is expected
ACTUAL_RESOLUTION_DATE DATE

Date actually the problem was resolved
INCIDENT_DATE DATE

Incident date
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer product id
INCIDENT_ATTRIBUTE_1 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_2 VARCHAR2 (150)
flex field
INCIDENT_ATTRIBUTE_3 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_4 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_5 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_6 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_7 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_8 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_9 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_10 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_11 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_12 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_13 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_14 VARCHAR2 (150)
Flex field
INCIDENT_ATTRIBUTE_15 VARCHAR2 (150)
Flex field
INCIDENT_CONTEXT VARCHAR2 (30)
Incident context
RECORD_IS_VALID_FLAG VARCHAR2 (1)
Whether record is valid or not
RESOLUTION_CODE VARCHAR2 (50)
Resolution code
INTERFACED_TO_DEPOT_FLAG VARCHAR2 (1)
Interfaced to depot flag
INCIDENT_TYPE VARCHAR2 (90)
Incident type name
SEVERITY VARCHAR2 (90)
Severity name
STATUS_CODE VARCHAR2 (90)
Status name
URGENCY VARCHAR2 (90)
Urgency name
FILED_BY_EMPLOYEE_FLAG VARCHAR2 (1)
Whether SR was filed by employee or not
CUSTOMER_ID NUMBER (15)
Customer id
ACCOUNT_ID NUMBER

Account id
EMPLOYEE_ID NUMBER (15)
Employee id
EMPLOYEE_NAME VARCHAR2 (0)
Employee name
EMPLOYEE_NUMBER VARCHAR2 (0)
Employee number
CURRENT_SERIAL_NUMBER_NV VARCHAR2 (30)
Current serial number
PURCHASE_ORDER_NUM VARCHAR2 (50)
Purchase order number
ORIGINAL_ORDER_NUMBER NUMBER

Original order number
WORKFLOW_PROCESS_ID NUMBER

Workflow process id
DATE_CLOSED DATE

Date the SR was closed
PUBLISH_FLAG VARCHAR2 (1)
Publish flag
QA_COLLECTION_ID NUMBER

QA collection id
CONTRACT_SERVICE_ID NUMBER

Contract service id
KB_SOLUTION_ID VARCHAR2 (240)
Knowledge base solution id
TIME_ZONE_ID NUMBER (15)
Time zone id
CUSTOMER_PO_NUMBER VARCHAR2 (50)
Customer purchase order number
CUSTOMER_TICKET_NUMBER VARCHAR2 (50)
Customer ticket number
OBLIGATION_DATE DATE

Obligation date
SITE_ID NUMBER

Site id
CUSTOMER_SITE_ID NUMBER

Customer site id
SR_CREATION_CHANNEL VARCHAR2 (50)
Service request creation channel (Web, phone etc.)
PLATFORM_VERSION_ID NUMBER

Platform version id
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
CALLER_TYPE VARCHAR2 (30) Yes Caller type
CP_COMPONENT_ID NUMBER

Customer product component id
CP_COMPONENT_VERSION_ID NUMBER

Customer product component version id
CP_SUBCOMPONENT_ID NUMBER

Customer product subcomponent id
CP_SUBCOMPONENT_VERSION_ID NUMBER

Customer product subcomponent version id
CP_REVISION_ID NUMBER

Customer product revision id
INV_ITEM_REVISION VARCHAR2 (240)
Inventory item revision
INV_COMPONENT_ID NUMBER

Inventory component id
INV_COMPONENT_VERSION VARCHAR2 (90)
Inventory component version
INV_SUBCOMPONENT_ID NUMBER

Inventory subcomponent id
INV_SUBCOMPONENT_VERSION VARCHAR2 (90)
Inventory subcomponent version
PLATFORM_ID NUMBER

Platform id
LANGUAGE_ID NUMBER

Language id
TERRITORY_ID NUMBER

Territory id
TIME_DIFFERENCE NUMBER

Time difference
INV_ORGANIZATION_ID NUMBER

Inventory organization id
PRODUCT_NAME VARCHAR2 (40)
Product name
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product description
OWNER VARCHAR2 (360)
SR owner name
COMPANY_NAME VARCHAR2 (360)
Company name
PERSON_FIRST_NAME VARCHAR2 (150)
Contact person first name
PERSON_LAST_NAME VARCHAR2 (150)
Contact person last name
CONTACT_NAME VARCHAR2 (301)
Contact person name
COUNTRY_CODE VARCHAR2 (10)
Telephone Country code
AREA_CODE VARCHAR2 (10)
Telephone area code
PHONE_NUMBER VARCHAR2 (40)
Telephone number
PHONE VARCHAR2 (62)
Whole phone no. including country code, area code
EXT VARCHAR2 (20)
Telephone extension
EMAIL VARCHAR2 (2000)
Contact person email id
PHONE_TYPE VARCHAR2 (30)
Telephone type (Work, Home etc.)
CONTACT_PARTY_ID NUMBER

Contact party id
CONTACT_POINT_ID NUMBER

Contact point id
ACCOUNT VARCHAR2 (30)
Account no.
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number
PERSON_TITLE VARCHAR2 (30)
Person title
CALLER_TYPE_NAME VARCHAR2 (80)
Caller type name
CALLER_TYPE_DESCRIPTION VARCHAR2 (240)
Caller type description
TIME_ZONE_NAME VARCHAR2 (50)
Time zone name
ORGANIZATION_ID NUMBER

Organization id
COUNTRY VARCHAR2 (60)
Country of the customer.
CONTRACT_NUMBER VARCHAR2 (120)
CONTRACT_ID NUMBER

PROJECT_NUMBER VARCHAR2 (120)
CONTACT_TYPE VARCHAR2 (30)
The contact type of the party.
CONTACT_NUMBER VARCHAR2 (30)
The contact number of the party.
GROUP_TYPE VARCHAR2 (30)
The group owner type for the SR.
OWNER_GROUP_ID NUMBER

The group owner identifier for the SR.
ERROR_CODE VARCHAR2 (250)
The error code of the problem reported in the service request.
SYSTEM_ID NUMBER (15)
System Identification Number.
EXTERNAL_REFERENCE VARCHAR2 (30)
External Reference number Store the Tag Number from the UI
INCIDENT_OCCURRED_DATE DATE

Date on which Incident Occurred.
GROUP_OWNER VARCHAR2 (60)
Name of the Group
CATEGORY_ID NUMBER

Category Identification Number.
INCIDENT_ADDRESS VARCHAR2 (960)
The Incident Address
INCIDENT_LOCATION_ID NUMBER

The incident Location identifier.
INCIDENT_COUNTRY VARCHAR2 (60)
The incident country.
INCIDENT_POSTAL_CODE VARCHAR2 (60)
The Incident Postal code.
INCIDENT_STATE VARCHAR2 (60)
The state of the incident address.
INCIDENT_LOCATION_TYPE VARCHAR2 (30)
The Incident Location Type.
PRIMARY_FLAG VARCHAR2 (1)
The primary flag of the contact.
STATUS_FLAG VARCHAR2 (3) Yes The status flag indicates if the Service Request is open or closed.
ITEM_SERIAL_NUMBER VARCHAR2 (30)
This column will store the serial number field for EAM SRs
INCIDENT_ADDRESS2 VARCHAR2 (240)
The Incident Address line 2.
INCIDENT_ADDRESS3 VARCHAR2 (240)
The Incident Address line 3.
INCIDENT_ADDRESS4 VARCHAR2 (240)
The Incident Address line 4.
CUSTOMER_ALIAS VARCHAR2 (240)
Customer Alias.
PARTY_ROLE_CODE VARCHAR2 (30)
Party Role Code
TEXT_INDEX VARCHAR2 (1)
Text Index
Query Text

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
,      FILED_BY_EMPLOYEE_FLAG
,      CUSTOMER_ID
,      ACCOUNT_ID
,      EMPLOYEE_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      CURRENT_SERIAL_NUMBER_NV
,      PURCHASE_ORDER_NUM
,      ORIGINAL_ORDER_NUMBER
,      WORKFLOW_PROCESS_ID
,      DATE_CLOSED
,      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
,      PLATFORM_ID
,      LANGUAGE_ID
,      TERRITORY_ID
,      TIME_DIFFERENCE
,      INV_ORGANIZATION_ID
,      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
,      CONTACT_PARTY_ID
,      CONTACT_POINT_ID
,      ACCOUNT
,      OBJECT_VERSION_NUMBER
,      PERSON_TITLE
,      CALLER_TYPE_NAME
,      CALLER_TYPE_DESCRIPTION
,      TIME_ZONE_NAME
,      ORGANIZATION_ID
,      COUNTRY
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      PROJECT_NUMBER
,      CONTACT_TYPE
,      CONTACT_NUMBER
,      GROUP_TYPE
,      OWNER_GROUP_ID
,      ERROR_CODE
,      SYSTEM_ID
,      EXTERNAL_REFERENCE
,      INCIDENT_OCCURRED_DATE
,      GROUP_OWNER
,      CATEGORY_ID
,      INCIDENT_ADDRESS
,      INCIDENT_LOCATION_ID
,      INCIDENT_COUNTRY
,      INCIDENT_POSTAL_CODE
,      INCIDENT_STATE
,      INCIDENT_LOCATION_TYPE
,      PRIMARY_FLAG
,      STATUS_FLAG
,      ITEM_SERIAL_NUMBER
,      INCIDENT_ADDRESS2
,      INCIDENT_ADDRESS3
,      INCIDENT_ADDRESS4
,      CUSTOMER_ALIAS
,      PARTY_ROLE_CODE
,      TEXT_INDEX
FROM APPS.CS_SR_SEARCH_V;

Dependencies

[top of page]

APPS.CS_SR_SEARCH_V references the following:

SchemaAPPS
SynonymCS_HZ_SR_CONTACT_POINTS
SynonymCS_INCIDENTS_ALL_TL
SynonymCS_INCIDENTS_B_SEC
SynonymCS_INCIDENT_SEVERITIES_TL
SynonymCS_INCIDENT_STATUSES_TL
SynonymCS_INCIDENT_TYPES_TL
SynonymCS_INCIDENT_URGENCIES_TL
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymHZ_TIMEZONES
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_SEARCH_V is not referenced by any database object