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]

TYPE: SYSTEM.CS_SR_SERVICE_REQUEST_I_T

Object Details

Object Name:	CS_SR_SERVICE_REQUEST_I_T
Object Type:	TYPE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
REQUEST_DATE	DATE
TYPE_ID	NUMBER
STATUS_ID	NUMBER
SEVERITY_ID	NUMBER
URGENCY_ID	NUMBER
CLOSED_DATE	DATE
OWNER_ID	NUMBER
OWNER_GROUP_ID	NUMBER
PUBLISH_FLAG	VARCHAR2	(1)
SUMMARY	VARCHAR2	(80)
CALLER_TYPE	VARCHAR2	(30)
CUSTOMER_ID	NUMBER
CUSTOMER_NUMBER	VARCHAR2	(30)
EMPLOYEE_ID	NUMBER
VERIFY_CP_FLAG	VARCHAR2	(1)
CUSTOMER_PRODUCT_ID	NUMBER
PLATFORM_ID	NUMBER
PLATFORM_VERSION	VARCHAR2	(250)
DB_VERSION	VARCHAR2	(250)
PLATFORM_VERSION_ID	NUMBER
CP_COMPONENT_ID	NUMBER
CP_COMPONENT_VERSION_ID	NUMBER
CP_SUBCOMPONENT_ID	NUMBER
CP_SUBCOMPONENT_VERSION_ID	NUMBER
LANGUAGE_ID	NUMBER
LANGUAGE	VARCHAR2	(4)
INVENTORY_ITEM_ID	NUMBER
INVENTORY_ORG_ID	NUMBER
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)
ORIGINAL_ORDER_NUMBER	NUMBER
PURCHASE_ORDER_NUM	VARCHAR2	(50)
PROBLEM_CODE	VARCHAR2	(50)
EXP_RESOLUTION_DATE	DATE
INSTALL_SITE_USE_ID	NUMBER
REQUEST_ATTRIBUTE_1	VARCHAR2	(150)
REQUEST_ATTRIBUTE_2	VARCHAR2	(150)
REQUEST_ATTRIBUTE_3	VARCHAR2	(150)
REQUEST_ATTRIBUTE_4	VARCHAR2	(150)
REQUEST_ATTRIBUTE_5	VARCHAR2	(150)
REQUEST_ATTRIBUTE_6	VARCHAR2	(150)
REQUEST_ATTRIBUTE_7	VARCHAR2	(150)
REQUEST_ATTRIBUTE_8	VARCHAR2	(150)
REQUEST_ATTRIBUTE_9	VARCHAR2	(150)
REQUEST_ATTRIBUTE_10	VARCHAR2	(150)
REQUEST_ATTRIBUTE_11	VARCHAR2	(150)
REQUEST_ATTRIBUTE_12	VARCHAR2	(150)
REQUEST_ATTRIBUTE_13	VARCHAR2	(150)
REQUEST_ATTRIBUTE_14	VARCHAR2	(150)
REQUEST_ATTRIBUTE_15	VARCHAR2	(150)
REQUEST_CONTEXT	VARCHAR2	(30)
BILL_TO_SITE_USE_ID	NUMBER
BILL_TO_CONTACT_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
RESOLUTION_CODE	VARCHAR2	(50)
ACT_RESOLUTION_DATE	DATE
PUBLIC_COMMENT_FLAG	VARCHAR2	(1)
PARENT_INTERACTION_ID	NUMBER
CONTRACT_SERVICE_ID	NUMBER
CONTRACT_ID	NUMBER
PROJECT_NUMBER	VARCHAR2	(120)
QA_COLLECTION_PLAN_ID	NUMBER
ACCOUNT_ID	NUMBER
RESOURCE_TYPE	VARCHAR2	(30)
RESOURCE_SUBTYPE_ID	NUMBER
CUST_PO_NUMBER	VARCHAR2	(50)
CUST_TICKET_NUMBER	VARCHAR2	(50)
SR_CREATION_CHANNEL	VARCHAR2	(50)
OBLIGATION_DATE	DATE
TIME_ZONE_ID	NUMBER
TIME_DIFFERENCE	NUMBER
SITE_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
TERRITORY_ID	NUMBER
INITIALIZE_FLAG	VARCHAR2	(1)
CP_REVISION_ID	NUMBER
INV_ITEM_REVISION	VARCHAR2	(3)
INV_COMPONENT_ID	NUMBER
INV_COMPONENT_VERSION	VARCHAR2	(3)
INV_SUBCOMPONENT_ID	NUMBER
INV_SUBCOMPONENT_VERSION	VARCHAR2	(3)
TIER	VARCHAR2	(250)
TIER_VERSION	VARCHAR2	(250)
OPERATING_SYSTEM	VARCHAR2	(250)
OPERATING_SYSTEM_VERSION	VARCHAR2	(250)
DATABASE	VARCHAR2	(250)
CUST_PREF_LANG_ID	NUMBER
CATEGORY_ID	NUMBER
GROUP_TYPE	VARCHAR2	(30)
GROUP_TERRITORY_ID	NUMBER
INV_PLATFORM_ORG_ID	NUMBER
PRODUCT_REVISION	VARCHAR2	(240)
COMPONENT_VERSION	VARCHAR2	(3)
SUBCOMPONENT_VERSION	VARCHAR2	(3)
COMM_PREF_CODE	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
OWNER_ASSIGNED_FLAG	VARCHAR2	(3)
OWNER_ASSIGNED_TIME	DATE
LAST_UPDATE_CHANNEL	VARCHAR2	(10)
CUST_PREF_LANG_CODE	VARCHAR2	(4)

Dependencies

[top of page]

SYSTEM.CS_SR_SERVICE_REQUEST_I_T references the following:

SYS: STANDARD - show dependent code

SYSTEM.CS_SR_SERVICE_REQUEST_I_T is referenced by following:

SYSTEM: CS_SR_SERVICE_REQUEST_I_M