eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	CS.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:

APPS: CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_TL; CS_INCIDENTS_B_SEC; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; CS_LOOKUPS; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_TIMEZONES; JTF_RS_GROUPS_VL; JTF_RS_GROUP_USAGES; MTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_SEARCH_NO_CONT_V is not referenced by any database object