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.

[Home] [Help]

Table: CS_INCIDENTS_ALL_B

Product:	CS - Service
Description:	This table stores non-translated information about service requests.
Implementation/DBA Data:	CS.CS_INCIDENTS_ALL_B

Primary Key: CS_INCIDENTS_B_PK

INCIDENT_ID

Primary Key: CS_INCIDENTS_B_UK1

INCIDENT_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
CS_INCIDENTS_ALL_B	HZ_CONTACT_POINTS	CS_INCIDENTS_ALL_B.CUSTOMER_EMAIL_ID
CS_INCIDENTS_ALL_B	HZ_CONTACT_POINTS	CS_INCIDENTS_ALL_B.CUSTOMER_PHONE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_ACCOUNTS	CS_INCIDENTS_ALL_B.BILL_TO_ACCOUNT_ID
CS_INCIDENTS_ALL_B	HZ_CUST_ACCOUNTS	CS_INCIDENTS_ALL_B.SHIP_TO_ACCOUNT_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.BILL_TO_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.SHIP_TO_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTIES	CS_INCIDENTS_ALL_B.BILL_TO_PARTY_ID
CS_INCIDENTS_ALL_B	HZ_PARTIES	CS_INCIDENTS_ALL_B.SHIP_TO_PARTY_ID
CS_INCIDENTS_ALL_B	CS_HZ_SR_CONTACT_POINTS	CS_INCIDENTS_ALL_B.PRIMARY_CONTACT_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INSTALL_SITE_ID
CS_INCIDENTS_ALL_B	BOM_DEPARTMENTS	CS_INCIDENTS_ALL_B.OWNING_DEPARTMENT_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITE_USES	CS_INCIDENTS_ALL_B.SHIP_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITE_USES	CS_INCIDENTS_ALL_B.BILL_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID
CS_INCIDENTS_ALL_B	HZ_LOCATIONS	CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID
CS_INCIDENTS_ALL_B	CSI_SYSTEMS_B	CS_INCIDENTS_ALL_B.SYSTEM_ID
CS_INCIDENTS_ALL_B	MTL_CATEGORIES_B	CS_INCIDENTS_ALL_B.CATEGORY_ID
CS_INCIDENTS_ALL_B	MTL_CATEGORY_SETS_B	CS_INCIDENTS_ALL_B.CATEGORY_SET_ID
CS_INCIDENTS_ALL_B	CS_SR_PREFERRED_LANG	CS_INCIDENTS_ALL_B.CUST_PREF_LANG_ID
CS_INCIDENTS_ALL_B	CS_INCIDENT_STATUSES_B	CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.SHIP_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
CS_INCIDENTS_ALL_B	CSI_ITEM_INSTANCES	CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID
CS_INCIDENTS_ALL_B	HZ_PARTIES	CS_INCIDENTS_ALL_B.BILL_TO_CONTACT_ID
CS_INCIDENTS_ALL_B	HZ_PARTIES	CS_INCIDENTS_ALL_B.SHIP_TO_CONTACT_ID
CS_INCIDENTS_ALL_B	JTF_RS_RESOURCE_EXTNS	CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID
CS_INCIDENTS_ALL_B	JTF_RS_GROUPS_B	CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID
CS_INCIDENTS_ALL_B	CS_INCIDENT_TYPES_B	CS_INCIDENTS_ALL_B.INCIDENT_TYPE_ID
CS_INCIDENTS_ALL_B	HZ_CUST_ACCOUNTS	CS_INCIDENTS_ALL_B.ACCOUNT_ID
CS_INCIDENTS_ALL_B	QA_PLANS	CS_INCIDENTS_ALL_B.QA_COLLECTION_ID
CS_INCIDENTS_ALL_B	JTF_RS_TEAMS_B	CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID
CS_INCIDENTS_ALL_B	HZ_CUST_ACCOUNTS	CS_INCIDENTS_ALL_B.ACCOUNT_ID
CS_INCIDENTS_ALL_B	%	CS_INCIDENTS_ALL_B.PLATFORM_VERSION_ID
CS_INCIDENTS_ALL_B	CS_INCIDENT_URGENCIES_B	CS_INCIDENTS_ALL_B.INCIDENT_URGENCY_ID
CS_INCIDENTS_ALL_B	%	CS_INCIDENTS_ALL_B.PLATFORM_ID
CS_INCIDENTS_ALL_B	%	CS_INCIDENTS_ALL_B.LANGUAGE_ID
CS_INCIDENTS_ALL_B	CS_CUSTOMER_PRODUCTS_ALL	CS_INCIDENTS_ALL_B.CP_COMPONENT_ID
CS_INCIDENTS_ALL_B	CS_CP_REVISIONS	CS_INCIDENTS_ALL_B.CP_COMPONENT_VERSION_ID
CS_INCIDENTS_ALL_B	CS_CUSTOMER_PRODUCTS_ALL	CS_INCIDENTS_ALL_B.CP_SUBCOMPONENT_ID
CS_INCIDENTS_ALL_B	CS_CP_REVISIONS	CS_INCIDENTS_ALL_B.CP_SUBCOMPONENT_VERSION_ID
CS_INCIDENTS_ALL_B	CS_CP_REVISIONS	CS_INCIDENTS_ALL_B.CP_REVISION_ID
CS_INCIDENTS_ALL_B	OKC_K_LINES_B	CS_INCIDENTS_ALL_B.CONTRACT_SERVICE_ID
CS_INCIDENTS_ALL_B	HZ_TIMEZONES	CS_INCIDENTS_ALL_B.TIME_ZONE_ID
CS_INCIDENTS_ALL_B	CS_INCIDENT_SEVERITIES_B	CS_INCIDENTS_ALL_B.INCIDENT_SEVERITY_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.CUSTOMER_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTIES	CS_INCIDENTS_ALL_B.CUSTOMER_ID
CS_INCIDENTS_ALL_B	HZ_CUST_SITE_USES_ALL	CS_INCIDENTS_ALL_B.BILL_TO_SITE_USE_ID
CS_INCIDENTS_ALL_B	%	CS_INCIDENTS_ALL_B.DEF_DEFECT_ID
CS_INCIDENTS_ALL_B	%	CS_INCIDENTS_ALL_B.DEF_DEFECT_ID2
AHL_UNIT_EFFECTIVITIES_B	CS_INCIDENTS_ALL_B	AHL_UNIT_EFFECTIVITIES_B.CS_INCIDENT_ID
AHL_VISITS_B	CS_INCIDENTS_ALL_B	AHL_VISITS_B.SERVICE_REQUEST_ID
AHL_VISIT_TASKS_B	CS_INCIDENTS_ALL_B	AHL_VISIT_TASKS_B.SERVICE_REQUEST_ID
CSD_GROUP_JOB_PARAM_TEMP	CS_INCIDENTS_ALL_B	CSD_GROUP_JOB_PARAM_TEMP.INCIDENT_ID
CSD_REPAIRS	CS_INCIDENTS_ALL_B	CSD_REPAIRS.INCIDENT_ID
CSD_REPAIRS	CS_INCIDENTS_ALL_B	CSD_REPAIRS.INCIDENT_ID
CSD_REPAIR_ORDER_GROUPS	CS_INCIDENTS_ALL_B	CSD_REPAIR_ORDER_GROUPS.INCIDENT_ID
CS_ESTIMATE_DETAILS	CS_INCIDENTS_ALL_B	CS_ESTIMATE_DETAILS.INCIDENT_ID
CS_HZ_SR_CONTACT_POINTS	CS_INCIDENTS_ALL_B	CS_HZ_SR_CONTACT_POINTS.INCIDENT_ID
CS_INCIDENTS_AUDIT_B	CS_INCIDENTS_ALL_B	CS_INCIDENTS_AUDIT_B.INCIDENT_ID
CS_INCIDENTS_EXT_AUDIT	CS_INCIDENTS_ALL_B	CS_INCIDENTS_EXT_AUDIT.INCIDENT_ID
CS_INCIDENTS_EXT_B	CS_INCIDENTS_ALL_B	CS_INCIDENTS_EXT_B.INCIDENT_ID
CS_INCIDENTS_EXT	CS_INCIDENTS_ALL_B	CS_INCIDENTS_EXT.INCIDENT_ID
CS_INCIDENTS_PURGE_AUDIT_B	CS_INCIDENTS_ALL_B	CS_INCIDENTS_PURGE_AUDIT_B.INCIDENT_ID
CS_INCIDENTS_PURGE_STAGING	CS_INCIDENTS_ALL_B	CS_INCIDENTS_PURGE_STAGING.INCIDENT_ID
CS_INCIDENT_LINKS_EXT	CS_INCIDENTS_ALL_B	CS_INCIDENT_LINKS_EXT.FROM_INCIDENT_ID
CS_INCIDENT_LINKS	CS_INCIDENTS_ALL_B	CS_INCIDENT_LINKS.OBJECT_ID
CS_INCIDENT_LINKS	CS_INCIDENTS_ALL_B	CS_INCIDENT_LINKS.SUBJECT_ID
CS_INCIDENTS_PURGE_AUDIT_TL	CS_INCIDENTS_ALL_B	CS_INCIDENTS_PURGE_AUDIT_TL.INCIDENT_ID
CS_MESSAGES	CS_INCIDENTS_ALL_B	CS_MESSAGES.SOURCE_OBJECT_INT_ID
CS_SR_CONTACTS_EXT_AUDIT	CS_INCIDENTS_ALL_B	CS_SR_CONTACTS_EXT_AUDIT.INCIDENT_ID
CS_SR_CONTACTS_EXT_B	CS_INCIDENTS_ALL_B	CS_SR_CONTACTS_EXT_B.INCIDENT_ID
CS_SR_CONTACTS_EXT	CS_INCIDENTS_ALL_B	CS_SR_CONTACTS_EXT.INCIDENT_ID
CS_SYSTEM_SR_LINKS	CS_INCIDENTS_ALL_B	CS_SYSTEM_SR_LINKS.INCIDENT_ID
CS_WEB_CONFERENCES	CS_INCIDENTS_ALL_B	CS_WEB_CONFERENCES.INCIDENT_ID
CUG_INCIDNT_ATTR_VALS_B	CS_INCIDENTS_ALL_B	CUG_INCIDNT_ATTR_VALS_B.INCIDENT_ID
JTF_NOTES_B	CS_INCIDENTS_ALL_B	JTF_NOTES_B.SOURCE_OBJECT_ID
JTF_TASKS_B	CS_INCIDENTS_ALL_B	JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASKS_B	CS_INCIDENTS_ALL_B	JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B	CS_INCIDENTS_ALL_B	JTF_TASK_AUDITS_B.OLD_SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B	CS_INCIDENTS_ALL_B	JTF_TASK_AUDITS_B.NEW_SOURCE_OBJECT_ID
JTF_TASK_REFERENCES_B	CS_INCIDENTS_ALL_B	JTF_TASK_REFERENCES_B.OBJECT_ID
XNS_INCIDENT_EXT_REFS	CS_INCIDENTS_ALL_B	XNS_INCIDENT_EXT_REFS.INCIDENT_ID