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


VIEW: APPS.CS_SR_SEARCH_NO_CONT_V

Object Details
Object Name: CS_SR_SEARCH_NO_CONT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_SEARCH_NO_CONT_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 (50)
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
RESOLUTION_CODE VARCHAR2 (50)
Resolution code
INCIDENT_TYPE VARCHAR2 (90)
Incident type name
SEVERITY VARCHAR2 (90)
Severity name
STATUS_CODE VARCHAR2 (90)
Status name
URGENCY VARCHAR2 (90)
Urgency name
CUSTOMER_ID NUMBER (15)
Customer id
ACCOUNT_ID NUMBER

Account id
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
CONTRACT_SERVICE_ID NUMBER

Contract service 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_MEANING VARCHAR2 (80)
Service request creation channel (Web, phone etc.)
SR_CREATION_CHANNEL VARCHAR2 (50)
PLATFORM_VERSION_ID NUMBER

Platform version id
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
CALLER_TYPE VARCHAR2 (30)
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
COMPANY_NAME VARCHAR2 (360)
Company name
ACCOUNT VARCHAR2 (30)
Account no.
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number
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)
GROUP_TYPE VARCHAR2 (30)
The group owner type for the SR.
OWNER_GROUP_ID NUMBER

The group owner identifier for the SR.
GROUP_OWNER VARCHAR2 (60)
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.
CATEGORY_ID NUMBER

Category Identification Number.
INCIDENT_ADDRESS VARCHAR2 (963)
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.
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
CUSTOMER_ALIAS VARCHAR2 (240)
Party known as
MAINT_ORGANIZATION_ID NUMBER

Maintenance Organization Id
TEXT_INDEX VARCHAR2 (1)
Text Index
INCIDENT_CITY VARCHAR2 (60)
INCIDENT_COUNTY VARCHAR2 (60)
Incident County name
INCIDENT_PROVINCE VARCHAR2 (60)
Incident Province Name
PROJECT_ID NUMBER

PROJECT_TASK_ID NUMBER (15)
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
,      RESOLUTION_CODE
,      INCIDENT_TYPE
,      SEVERITY
,      STATUS_CODE
,      URGENCY
,      CUSTOMER_ID
,      ACCOUNT_ID
,      CURRENT_SERIAL_NUMBER_NV
,      PURCHASE_ORDER_NUM
,      ORIGINAL_ORDER_NUMBER
,      WORKFLOW_PROCESS_ID
,      DATE_CLOSED
,      PUBLISH_FLAG
,      CONTRACT_SERVICE_ID
,      TIME_ZONE_ID
,      CUSTOMER_PO_NUMBER
,      CUSTOMER_TICKET_NUMBER
,      OBLIGATION_DATE
,      SITE_ID
,      CUSTOMER_SITE_ID
,      SR_CREATION_CHANNEL_MEANING
,      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
,      COMPANY_NAME
,      ACCOUNT
,      OBJECT_VERSION_NUMBER
,      CALLER_TYPE_NAME
,      CALLER_TYPE_DESCRIPTION
,      TIME_ZONE_NAME
,      ORGANIZATION_ID
,      COUNTRY
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      PROJECT_NUMBER
,      GROUP_TYPE
,      OWNER_GROUP_ID
,      GROUP_OWNER
,      ERROR_CODE
,      SYSTEM_ID
,      EXTERNAL_REFERENCE
,      INCIDENT_OCCURRED_DATE
,      CATEGORY_ID
,      INCIDENT_ADDRESS
,      INCIDENT_LOCATION_ID
,      INCIDENT_COUNTRY
,      INCIDENT_POSTAL_CODE
,      INCIDENT_STATE
,      INCIDENT_LOCATION_TYPE
,      STATUS_FLAG
,      ITEM_SERIAL_NUMBER
,      CUSTOMER_ALIAS
,      MAINT_ORGANIZATION_ID
,      TEXT_INDEX
,      INCIDENT_CITY
,      INCIDENT_COUNTY
,      INCIDENT_PROVINCE
,      PROJECT_ID
,      PROJECT_TASK_ID
FROM APPS.CS_SR_SEARCH_NO_CONT_V;

Dependencies

[top of page]

APPS.CS_SR_SEARCH_NO_CONT_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_TL
ViewCS_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
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_TIMEZONES
ViewJTF_RS_GROUPS_VL
SynonymJTF_RS_GROUP_USAGES
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_SEARCH_NO_CONT_V is not referenced by any database object