Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CS Tables and Views

TABLE - CS.CSY_RESOLUTION_QLTY

TABLE - CS.CSY_RESPONSE_RESOLUTIONS

TABLE - CS.CS_BILLING_TYPE_CATEGORIES

TABLE - CS.CS_BUSINESS_PROCESSES

TABLE - CS.CS_BUS_PROCESS_TXNS

TABLE - CS.CS_CF_FLOWS_B

TABLE - CS.CS_CF_FLOWS_TL

TABLE - CS.CS_CF_FLOW_PAGES_B

TABLE - CS.CS_CF_FLOW_PAGES_TL

TABLE - CS.CS_CF_FLOW_TYPE_PAGES

TABLE - CS.CS_CF_SOURCE_CXT_TARGETS

TABLE - CS.CS_CF_SOURCE_CXT_TYPES

TABLE - CS.CS_CHG_SUB_RESTRICTIONS

TABLE - CS.CS_CONTACTS

TABLE - CS.CS_COST_DETAILS

TABLE - CS.CS_COST_STAGING

TABLE - CS.CS_COUNTER_DER_FILTERS

TABLE - CS.CS_COUNTER_GRP_LOG

TABLE - CS.CS_CP_AUDIT

TABLE - CS.CS_CP_LANGUAGES

TABLE - CS.CS_CP_PARAMETERS

TABLE - CS.CS_CP_PARTIES_AUDIT

TABLE - CS.CS_CP_REVISIONS

TABLE - CS.CS_CSZ_SEARCHES

TABLE - CS.CS_CSZ_SRCH_CRITERIA

TABLE - CS.CS_CSZ_SRCH_CRIT_GROUPS

TABLE - CS.CS_CSZ_SRCH_CRIT_VALUES

TABLE - CS.CS_CSZ_SRCH_RESULT_COLS

TABLE - CS.CS_CSZ_SRCH_SORTS

TABLE - CS.CS_CTR_AUDIT

TABLE - CS.CS_CTR_AUDIT_LINES

TABLE - CS.CS_CTR_ESTIMATED_READINGS

TABLE - CS.CS_CTR_ESTIMATION_METHODS

TABLE - CS.CS_CTR_FORMULA_BVARS

TABLE - CS.CS_CTR_UPLOAD_INSTANCES

TABLE - CS.CS_ESTIMATE_DETAILS

TABLE - CS.CS_FORUM_ATTRS_B

TABLE - CS.CS_FORUM_ATTRS_TL

TABLE - CS.CS_FORUM_CATEGORIES_B

TABLE - CS.CS_FORUM_CATEGORIES_TL

TABLE - CS.CS_FORUM_CAT_ATTRS

TABLE - CS.CS_FORUM_CAT_CATS

TABLE - CS.CS_FORUM_CAT_LINKS

TABLE - CS.CS_FORUM_CAT_MSGS

TABLE - CS.CS_FORUM_MESSAGES_B

TABLE - CS.CS_FORUM_MESSAGES_TL

TABLE - CS.CS_FORUM_MSG_ATTRS

TABLE - CS.CS_FORUM_MSG_MSGS

TABLE - CS.CS_FORUM_USER_CATS

TABLE - CS.CS_FORUM_USER_MSGS

TABLE - CS.CS_HZ_SR_CONTACT_PNTS_AUDIT

TABLE - CS.CS_HZ_SR_CONTACT_POINTS

TABLE - CS.CS_INCIDENTS_ALL_B

TABLE - CS.CS_INCIDENTS_ALL_TL

TABLE - CS.CS_INCIDENTS_AUDIT_B

TABLE - CS.CS_INCIDENTS_AUDIT_TL

TABLE - CS.CS_INCIDENTS_EXT_AUDIT

TABLE - CS.CS_INCIDENTS_EXT_B

TABLE - CS.CS_INCIDENTS_EXT_TL

TABLE - CS.CS_INCIDENTS_PURGE_AUDIT_B

TABLE - CS.CS_INCIDENTS_PURGE_AUDIT_TL

TABLE - CS.CS_INCIDENTS_PURGE_STAGING

TABLE - CS.CS_INCIDENT_CYCLE_STEPS

TABLE - CS.CS_INCIDENT_LINKS

TABLE - CS.CS_INCIDENT_LINKS_EXT

TABLE - CS.CS_INCIDENT_SEVERITIES_B

TABLE - CS.CS_INCIDENT_SEVERITIES_TL

TABLE - CS.CS_INCIDENT_STATUSES_B

TABLE - CS.CS_INCIDENT_STATUSES_TL

TABLE - CS.CS_INCIDENT_TYPES_B

TABLE - CS.CS_INCIDENT_TYPES_TL

TABLE - CS.CS_INCIDENT_URGENCIES_B

TABLE - CS.CS_INCIDENT_URGENCIES_TL

TABLE - CS.CS_INST_DTL_INTERFACE

TABLE - CS.CS_KB_ATTRS_B

TABLE - CS.CS_KB_ATTRS_TL

TABLE - CS.CS_KB_ATTR_VALS_B

TABLE - CS.CS_KB_ATTR_VALS_TL

TABLE - CS.CS_KB_AUTOLINKS_B

TABLE - CS.CS_KB_AUTOLINKS_TL

TABLE - CS.CS_KB_AUTOLINK_USAGES

TABLE - CS.CS_KB_CACHE

TABLE - CS.CS_KB_CATEGORY_GROUPS_B

TABLE - CS.CS_KB_CATEGORY_GROUPS_TL

TABLE - CS.CS_KB_CAT_GROUP_DENORM

TABLE - CS.CS_KB_CAT_GROUP_FLOWS

TABLE - CS.CS_KB_CAT_GROUP_MEMBERS

TABLE - CS.CS_KB_CONTEXTS

TABLE - CS.CS_KB_CTXT_REPO_MAPS_B

TABLE - CS.CS_KB_CTXT_REPO_MAPS_TL

TABLE - CS.CS_KB_ELEMENTS_B

TABLE - CS.CS_KB_ELEMENTS_TL

TABLE - CS.CS_KB_ELEMENT_LINKS

TABLE - CS.CS_KB_ELEMENT_TYPES_B

TABLE - CS.CS_KB_ELEMENT_TYPES_TL

TABLE - CS.CS_KB_ELE_ATTR_VALS

TABLE - CS.CS_KB_ELE_CHG_HISTS

TABLE - CS.CS_KB_ELE_ELES

TABLE - CS.CS_KB_ELE_TYPE_ATTRS

TABLE - CS.CS_KB_ELE_TYPE_LINKS

TABLE - CS.CS_KB_HISTORIES_B

TABLE - CS.CS_KB_HISTORIES_TL

TABLE - CS.CS_KB_LIB_LINKS_TL

TABLE - CS.CS_KB_LIB_PROPERTIES_B

TABLE - CS.CS_KB_LIB_PROPERTIES_TL

TABLE - CS.CS_KB_LIB_SECTIONS

TABLE - CS.CS_KB_REPORT_DATA

TABLE - CS.CS_KB_REPOSITORIES

TABLE - CS.CS_KB_REPO_PROPERTIES

TABLE - CS.CS_KB_SECTIONS_B

TABLE - CS.CS_KB_SECTIONS_TL

TABLE - CS.CS_KB_SECTION_DETAILS

TABLE - CS.CS_KB_SESSIONS

TABLE - CS.CS_KB_SESSION_ATTRS

TABLE - CS.CS_KB_SETS_B

TABLE - CS.CS_KB_SETS_TL

TABLE - CS.CS_KB_SET_ATTR_VALS

TABLE - CS.CS_KB_SET_CATEGORIES

TABLE - CS.CS_KB_SET_CHG_HISTS

TABLE - CS.CS_KB_SET_ELES

TABLE - CS.CS_KB_SET_ELE_TYPES

TABLE - CS.CS_KB_SET_LINKS

TABLE - CS.CS_KB_SET_PLATFORMS

TABLE - CS.CS_KB_SET_PRODUCTS

TABLE - CS.CS_KB_SET_RECS

TABLE - CS.CS_KB_SET_SETS

TABLE - CS.CS_KB_SET_TYPES_B

TABLE - CS.CS_KB_SET_TYPES_TL

TABLE - CS.CS_KB_SET_TYPE_ATTRS

TABLE - CS.CS_KB_SET_TYPE_LINKS

TABLE - CS.CS_KB_SET_USED_HISTS

TABLE - CS.CS_KB_SET_USED_SUMS

TABLE - CS.CS_KB_SOLN_CATEGORIES_B

TABLE - CS.CS_KB_SOLN_CATEGORIES_TL

TABLE - CS.CS_KB_USED_SUM_DEFS_B

TABLE - CS.CS_KB_USED_SUM_DEFS_TL

TABLE - CS.CS_KB_VISIBILITIES_B

TABLE - CS.CS_KB_VISIBILITIES_TL

TABLE - CS.CS_KB_WF_FLOWS_B

TABLE - CS.CS_KB_WF_FLOWS_TL

TABLE - CS.CS_KB_WF_FLOW_DETAILS

TABLE - CS.CS_LINE_INST_DETAILS

TABLE - CS.CS_MESSAGES

TABLE - CS.CS_MULTI_ORG_RULES

TABLE - CS.CS_OBJECT_RESP_MAPPINGS

TABLE - CS.CS_OKS_UPGRADE_PW

TABLE - CS.CS_PARTY_ROLES_B

TABLE - CS.CS_PARTY_ROLES_TL

TABLE - CS.CS_PARTY_ROLE_GROUPS_B

TABLE - CS.CS_PARTY_ROLE_GROUPS_TL

TABLE - CS.CS_PARTY_ROLE_GROUP_MAPS

TABLE - CS.CS_QM_FILTERS

TABLE - CS.CS_QM_FOLDER_FILTERS

TABLE - CS.CS_QM_FUNCTION_FILTERS

TABLE - CS.CS_QM_USER_FOLDERS

TABLE - CS.CS_REPAIRS_ALL

TABLE - CS.CS_SERVICE_AVAILABILITY

TABLE - CS.CS_SERVICE_RESPONSIBILITY

TABLE - CS.CS_SR_ACTION_CODES_B

TABLE - CS.CS_SR_ACTION_CODES_TL

TABLE - CS.CS_SR_ACTION_DETAILS

TABLE - CS.CS_SR_ACTION_TRIGGERS

TABLE - CS.CS_SR_ALLOWED_STATUSES

TABLE - CS.CS_SR_AQ_TEMP

TABLE - CS.CS_SR_CONTACTS_EXT_AUDIT

TABLE - CS.CS_SR_CONTACTS_EXT_B

TABLE - CS.CS_SR_CONTACTS_EXT_TL

TABLE - CS.CS_SR_DUP_CHECK_TMP

TABLE - CS.CS_SR_EVENT_ACTIONS

TABLE - CS.CS_SR_EVENT_CODES_B

TABLE - CS.CS_SR_EVENT_CODES_TL

TABLE - CS.CS_SR_LINK_TYPES_B

TABLE - CS.CS_SR_LINK_TYPES_TL

TABLE - CS.CS_SR_LINK_VALID_OBJ

TABLE - CS.CS_SR_LOAD_BALANCE_WT

TABLE - CS.CS_SR_LOG_DATA_TEMP

TABLE - CS.CS_SR_PREFERRED_LANG

TABLE - CS.CS_SR_PROB_CODE_MAPPING

TABLE - CS.CS_SR_PROB_CODE_MAPPING_DETAIL

TABLE - CS.CS_SR_RES_CODE_MAPPING

TABLE - CS.CS_SR_RES_CODE_MAPPING_DETAIL

TABLE - CS.CS_SR_SAVED_ADV_CRITERIA

TABLE - CS.CS_SR_SAVED_BSC_CRITERIA

TABLE - CS.CS_SR_SAVED_SEARCHES_B

TABLE - CS.CS_SR_SAVED_SEARCHES_TL

TABLE - CS.CS_SR_STATUS_GROUPS_B

TABLE - CS.CS_SR_STATUS_GROUPS_TL

TABLE - CS.CS_SR_STATUS_TRANSITIONS

TABLE - CS.CS_SR_TSK_TMPL_GP_MAP

TABLE - CS.CS_SR_TSK_TMPL_SEQ_RULES

TABLE - CS.CS_SR_TYPE_CATEGORIES_B

TABLE - CS.CS_SR_TYPE_CATEGORIES_TL

TABLE - CS.CS_SR_TYPE_CAT_MAPPINGS

TABLE - CS.CS_SR_TYPE_ITEMCAT_MAPS

TABLE - CS.CS_SR_TYPE_MAPPING

TABLE - CS.CS_SR_UWQ_NODES_B

TABLE - CS.CS_SR_UWQ_NODES_TL

TABLE - CS.CS_SYSTEM_AUDIT

TABLE - CS.CS_SYSTEM_OPTIONS

TABLE - CS.CS_SYSTEM_PARAMETERS_ALL

TABLE - CS.CS_SYSTEM_PARTY_LINKS

TABLE - CS.CS_SYSTEM_SR_LINKS

TABLE - CS.CS_TIME_ZONES

TABLE - CS.CS_TM_LABOR_SCHEDULES

TABLE - CS.CS_TP_CHOICES_B

TABLE - CS.CS_TP_CHOICES_TL

TABLE - CS.CS_TP_FREETEXTS

TABLE - CS.CS_TP_LOOKUPS

TABLE - CS.CS_TP_QUESTIONS_B

TABLE - CS.CS_TP_QUESTIONS_TL

TABLE - CS.CS_TP_TEMPLATES_B

TABLE - CS.CS_TP_TEMPLATES_TL

TABLE - CS.CS_TP_TEMPLATE_ATTRIBUTE

TABLE - CS.CS_TP_TEMPLATE_LINKS

TABLE - CS.CS_TP_TEMPLATE_QUESTIONS

TABLE - CS.CS_TRANSACTION_TYPES_B

TABLE - CS.CS_TRANSACTION_TYPES_TL

TABLE - CS.CS_TXN_BILLING_OETXN_ALL

TABLE - CS.CS_TXN_BILLING_TYPES

TABLE - CS.CS_UPG_EMPLOYEES

TABLE - CS.CS_UPG_ERRORS

TABLE - CS.CS_UPG_SLABS

TABLE - CS.CS_WEB_CONFERENCES

TABLE - APPS.SUGGESTIONSLIST

VIEW - APPS.CSY_PERIODS_V

VIEW - APPS.CS_ACC_CP_RG_V

VIEW - APPS.CS_BRM_3D_SERVICE_REQUEST_V

VIEW - APPS.CS_BUS_PROCESS_TXNS_V

VIEW - APPS.CS_CF_FLOWS_VL

VIEW - APPS.CS_CF_FLOW_PAGES_VL

VIEW - APPS.CS_CHARGE_DETAILS_V

VIEW - APPS.CS_CONFIG_RG_V

VIEW - APPS.CS_CONTRACT_COVERAGES_V

VIEW - APPS.CS_CONT_CONTACTS_RG_V

VIEW - APPS.CS_COUNTER_DER_FILTERS_V

VIEW - APPS.CS_COUNTER_PROPERTIES_V

VIEW - APPS.CS_CP_ADDRESSES_V

VIEW - APPS.CS_CP_AGREEMENTS_RG_V

VIEW - APPS.CS_CP_AUDIT_MAINT_V

VIEW - APPS.CS_CP_BILLTOADD_RG_V

VIEW - APPS.CS_CP_CONTRACTS_V

VIEW - APPS.CS_CP_PARAMETERS_V

VIEW - APPS.CS_CP_REVISIONS_MAINT_V

VIEW - APPS.CS_CP_SERVICES

VIEW - APPS.CS_CP_SYSTEMS_MAINT_V

VIEW - APPS.CS_CTR_ASSOCIATIONS_V

VIEW - APPS.CS_CTR_ESTIMATE_READINGS_V

VIEW - APPS.CS_CTR_ESTIMATION_METHODS_V

VIEW - APPS.CS_CUSTOMER_PRODUCTS

VIEW - APPS.CS_CUSTOMER_PRODUCTS_CONFIRM_V

VIEW - APPS.CS_CUSTOMER_PRODUCTS_DEFINE_V

VIEW - APPS.CS_CUSTOMER_PRODUCTS_REPORT_V

VIEW - APPS.CS_CUSTOMER_PRODUCT_TRANSFER_V

VIEW - APPS.CS_FORUM_ATTRS_VL

VIEW - APPS.CS_FORUM_CATEGORIES_VL

VIEW - APPS.CS_FORUM_MESSAGES_VL

VIEW - APPS.CS_HZ_SR_CONTACT_POINTS_V

VIEW - APPS.CS_IB_EMPLOYEES_V

VIEW - APPS.CS_IB_W_EMPLOYEES_V

VIEW - APPS.CS_INCIDENTS_ALL_VL

VIEW - APPS.CS_INCIDENTS_AUDIT_VL

VIEW - APPS.CS_INCIDENTS_B_SEC

VIEW - APPS.CS_INCIDENTS_DIARY_V

VIEW - APPS.CS_INCIDENTS_PURGE_AUDIT_VL

VIEW - APPS.CS_INCIDENTS_V

VIEW - APPS.CS_INCIDENTS_VL_SEC

VIEW - APPS.CS_INCIDENTS_WORKFLOW_V

VIEW - APPS.CS_INCIDENT_LINKS_FROM_V

VIEW - APPS.CS_INCIDENT_LINKS_TO_V

VIEW - APPS.CS_INCIDENT_LINKS_TO_V_SEC

VIEW - APPS.CS_INCIDENT_SEVERITIES_VL

VIEW - APPS.CS_INCIDENT_STATUSES_VL

VIEW - APPS.CS_INCIDENT_TYPES_RG_V

VIEW - APPS.CS_INCIDENT_TYPES_RG_V_SEC

VIEW - APPS.CS_INCIDENT_TYPES_VL

VIEW - APPS.CS_INCIDENT_TYPES_VL_SEC

VIEW - APPS.CS_INCIDENT_URGENCIES_VL

VIEW - APPS.CS_INC_RELATED_STATUSES_V

VIEW - APPS.CS_INST_CONTACT_DTLS_V

VIEW - APPS.CS_INST_DETAIL_CONTACTS_V

VIEW - APPS.CS_JTF_RESOURCES_V

VIEW - APPS.CS_JTF_RS_RESOURCE_EXTNS_SEC

VIEW - APPS.CS_KB_ATTRS_VL

VIEW - APPS.CS_KB_ATTR_VALS_VL

VIEW - APPS.CS_KB_AUTOLINKS_VL

VIEW - APPS.CS_KB_CATEGORY_GROUPS_VL

VIEW - APPS.CS_KB_CTXT_REPO_MAPS_VL

VIEW - APPS.CS_KB_ELEMENTS_V

VIEW - APPS.CS_KB_ELEMENTS_VL

VIEW - APPS.CS_KB_ELEMENT_TYPES_VL

VIEW - APPS.CS_KB_HISTORIES_VL

VIEW - APPS.CS_KB_INTEGRATION_V

VIEW - APPS.CS_KB_LIB_PROPERTIES_V

VIEW - APPS.CS_KB_LIB_PROPERTIES_VL

VIEW - APPS.CS_KB_LINKED_SOLUTIONS_VIEW

VIEW - APPS.CS_KB_SECTIONS_V

VIEW - APPS.CS_KB_SECURE_SOLUTIONS_VIEW

VIEW - APPS.CS_KB_SETS_V

VIEW - APPS.CS_KB_SETS_VL

VIEW - APPS.CS_KB_SET_ELEMENTS_V

VIEW - APPS.CS_KB_SET_TYPES_VL

VIEW - APPS.CS_KB_SOLN_CATEGORIES_VL

VIEW - APPS.CS_KB_USED_SUM_DEFS_VL

VIEW - APPS.CS_KB_VISIBILITIES_VL

VIEW - APPS.CS_KB_WF_FLOWS_VL

VIEW - APPS.CS_LOCATION_V

VIEW - APPS.CS_LOOKUPS

VIEW - APPS.CS_MESSAGES_V

VIEW - APPS.CS_MULTI_ORG_RULES_V

VIEW - APPS.CS_NEW_ACCOUNT_RG_V

VIEW - APPS.CS_NEW_INCIDENTS_V

VIEW - APPS.CS_NEW_INCIDENTS_V_SEC

VIEW - APPS.CS_NEW_SYSTEMS_RG_V

VIEW - APPS.CS_PARTY_ROLES_VL

VIEW - APPS.CS_PARTY_ROLE_GROUPS_VL

VIEW - APPS.CS_PR_OCV

VIEW - APPS.CS_RETURNS_RG_V

VIEW - APPS.CS_SERVICE_REQUEST_PUB_V

VIEW - APPS.CS_SR_ACTION_CODES_VL

VIEW - APPS.CS_SR_ACTIVITIES_V

VIEW - APPS.CS_SR_ALL_NOTES_V

VIEW - APPS.CS_SR_CONTACT_POINTS_V

VIEW - APPS.CS_SR_CONTRACT_NOTES_V

VIEW - APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V

VIEW - APPS.CS_SR_DUPLICATE_CHECK_V

VIEW - APPS.CS_SR_EVENT_CODES_VL

VIEW - APPS.CS_SR_FIND_EAM_PROD_MAINT_V

VIEW - APPS.CS_SR_FIND_PROD_MAINT_EAM_V

VIEW - APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V

VIEW - APPS.CS_SR_FULFIL_STATUS_V

VIEW - APPS.CS_SR_HZ_CONT_PTS_EMAILS_V

VIEW - APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V

VIEW - APPS.CS_SR_HZ_CUST_CONT_V

VIEW - APPS.CS_SR_HZ_RELATIONSHIPS_V

VIEW - APPS.CS_SR_INCIDENTS_V

VIEW - APPS.CS_SR_INCIDENTS_V_SEC

VIEW - APPS.CS_SR_INCIDENT_ADDRESS_V

VIEW - APPS.CS_SR_INSTALLBASE_NOTES_V

VIEW - APPS.CS_SR_INTERACTIONS_V

VIEW - APPS.CS_SR_INV_COMPONENTS_V

VIEW - APPS.CS_SR_INV_SUBCOMPONENTS_V

VIEW - APPS.CS_SR_KB_NOTE_LINKS_V

VIEW - APPS.CS_SR_KB_SOLUTION_LINKS_V

VIEW - APPS.CS_SR_LINKS_EXT_V

VIEW - APPS.CS_SR_LINK_TYPES_VL

VIEW - APPS.CS_SR_LINK_VALID_OBJ_V

VIEW - APPS.CS_SR_LOAD_BALANCE_WT_V

VIEW - APPS.CS_SR_MEMBERS_V

VIEW - APPS.CS_SR_MEMBERS_V_SEC

VIEW - APPS.CS_SR_NEW_ACC_CP_RG_V

VIEW - APPS.CS_SR_NEW_FIND_PROD_MAINT_P_V

VIEW - APPS.CS_SR_NEW_FIND_PROD_MAINT_V

VIEW - APPS.CS_SR_NEW_PRODUCTS_MAINT_V

VIEW - APPS.CS_SR_NOTES_V

VIEW - APPS.CS_SR_NULL_V

VIEW - APPS.CS_SR_OCV

VIEW - APPS.CS_SR_OWNERS_SEARCH_V

VIEW - APPS.CS_SR_OWNERS_V

VIEW - APPS.CS_SR_PARTY_ADDRESS_V

VIEW - APPS.CS_SR_PREFERRED_LANG_V

VIEW - APPS.CS_SR_PROB_CODE_MAPPING_V

VIEW - APPS.CS_SR_PRODUCTS_MAINT_V

VIEW - APPS.CS_SR_REPORT_V

VIEW - APPS.CS_SR_RES_CODE_MAPPING_V

VIEW - APPS.CS_SR_SAVED_SEARCHES_VL

VIEW - APPS.CS_SR_SEARCH_NO_CONT_V

VIEW - APPS.CS_SR_SEARCH_V

VIEW - APPS.CS_SR_SERVICE_HISTORY_V

VIEW - APPS.CS_SR_STATUS_GROUPS_VL

VIEW - APPS.CS_SR_SYSTEMS_V

VIEW - APPS.CS_SR_TASKS_V

VIEW - APPS.CS_SR_TASK_DEBRIEF_NOTES_V

VIEW - APPS.CS_SR_TASK_NOTES_V

VIEW - APPS.CS_SR_TASK_TERRITORY_V

VIEW - APPS.CS_SR_TERRITORY_V

VIEW - APPS.CS_SR_TYPE_CATEGORIES_VL

VIEW - APPS.CS_SR_UWQ_EMPLOYEE_V

VIEW - APPS.CS_SR_UWQ_EMP_COUNT_V

VIEW - APPS.CS_SR_UWQ_GROUP_COUNT_V

VIEW - APPS.CS_SR_UWQ_GROUP_V

VIEW - APPS.CS_SR_UWQ_LABEL_V

VIEW - APPS.CS_SR_UWQ_NODES_VL

VIEW - APPS.CS_SR_UWQ_TEAM_COUNT_V

VIEW - APPS.CS_SR_UWQ_TEAM_V

VIEW - APPS.CS_SR_UWQ_UNOWNED_V

VIEW - APPS.CS_SR_UWQ_V

VIEW - APPS.CS_SYSTEMS_V

VIEW - APPS.CS_SYSTEMS_VL

VIEW - APPS.CS_SYSTEM_BILLTO_LOC_RG_V

VIEW - APPS.CS_SYSTEM_PARAMETERS

VIEW - APPS.CS_SYSTEM_PARTY_LINKS_V

VIEW - APPS.CS_SYSTEM_SR_LINKS_V

VIEW - APPS.CS_TAX_LINES_SUMMARY_V

VIEW - APPS.CS_TP_CHOICES_VL

VIEW - APPS.CS_TP_QUESTIONS_VL

VIEW - APPS.CS_TP_TEMPLATES_VL

VIEW - APPS.CS_TRANSACTION_TYPES_V

VIEW - APPS.CS_TRANSACTION_TYPES_VL

Table: CSY_RESOLUTION_QLTY

Primary Key: CSY_RESOLUTION_QLTY_PK

1. SUMMARY_DATE
2. OWNER_TYPE
3. INCIDENT_OWNER_ID
4. INCIDENT_SEVERITY_ID
5. INV_ORGANIZATION_ID
6. INVENTORY_ITEM_ID
7. RESOLUTION_CODE
8. PROBLEM_CODE

Comments

This table Service Request Resolution quality summary for agents and groups

Indexes

Columns

[top of page]

CS.CSY_RESOLUTION_QLTY does not reference any database object

CS.CSY_RESOLUTION_QLTY is referenced by following:

CS

VIEW - CSY_RESOLUTION_QLTY#

[top of page]

Table: CSY_RESPONSE_RESOLUTIONS

Primary Key: CSY_RESPONSE_RESOLUTIONS_PK

1. SUMMARY_DATE
2. OWNER_TYPE
3. OWNER_GROUP_ID
4. INCIDENT_OWNER_ID
5. INCIDENT_SEVERITY_ID

Comments

This table contains summary of service request data by agents and groups. The service request summary contained in this table is: Backlog position for agent and group,. Number of Service Request Responded, Number of Service Request Resolved, Time taken to respond service requests, Time taken to resolve service requests, Movement of Service Request between agents and groups.

Indexes

Columns

[top of page]

CS.CSY_RESPONSE_RESOLUTIONS does not reference any database object

CS.CSY_RESPONSE_RESOLUTIONS is referenced by following:

CS

VIEW - CSY_RESPONSE_RESOLUTIONS#

[top of page]

Table: CS_BILLING_TYPE_CATEGORIES

Primary Key: CS_BILLING_TYPE_CATEGORIES_PK

1. BILLING_TYPE

Comments

This table defines the mapping between the extensible billing types and the parent billing category of 'M', 'L', and 'E'.
This table also defines the rollup item to be used for each billing type.

Indexes

Columns

[top of page]

CS.CS_BILLING_TYPE_CATEGORIES does not reference any database object

CS.CS_BILLING_TYPE_CATEGORIES is referenced by following:

CS

VIEW - CS_BILLING_TYPE_CATEGORIES#

[top of page]

Table: CS_BUSINESS_PROCESSES

Primary Key: CS_BUSINESS_PROCESSES_PK

1. BUSINESS_PROCESS_ID

Foreign Keys to this table:

Comments

CS_BUSINESS_PROCESSES stores Business Process definitions. A Business Process is an entity that groups related Transaction Types. Business Processes are only valid when used within the date range defined by the START_DATE_ACTIVE and the END_DATE_ACTIVE columns.

Indexes

Columns

[top of page]

CS.CS_BUSINESS_PROCESSES does not reference any database object

CS.CS_BUSINESS_PROCESSES is referenced by following:

CS

VIEW - CS_BUSINESS_PROCESSES#

[top of page]

Table: CS_BUS_PROCESS_TXNS

Primary Key: CS_BUS_PROCESS_TXNS_PK

1. BUSINESS_PROCESS_ID
2. TRANSACTION_TYPE_ID

Foreign Keys from this table:

Comments

This table stores associations between Transactions Types and Business Processes. Each Business Process can be assigned one or more transaction types. Each assignment can have an effective period, which can differ from the individual effective periods of the Business Processes and Transaction Types.

Indexes

Columns

[top of page]

CS.CS_BUS_PROCESS_TXNS does not reference any database object

CS.CS_BUS_PROCESS_TXNS is referenced by following:

CS

VIEW - CS_BUS_PROCESS_TXNS#

[top of page]

Table: CS_CF_FLOWS_B

Primary Key: CS_CF_FLOWS_B_PK

1. FLOW_ID

Foreign Keys to this table:

Comments

CS_CF_FLOWS_B stores the flow instances of a particular flow type. The FLOW_TYPE_CODE stores the type of flow this instance belongs under.

Indexes

Columns

[top of page]

CS.CS_CF_FLOWS_B does not reference any database object

CS.CS_CF_FLOWS_B is referenced by following:

CS

VIEW - CS_CF_FLOWS_B#

[top of page]

Table: CS_CF_FLOWS_TL

Primary Key: CS_CF_FLOWS_TL_PK

1. FLOW_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table is the translation table for CS_CF_FLOWS_B.

Indexes

Columns

[top of page]

CS.CS_CF_FLOWS_TL does not reference any database object

CS.CS_CF_FLOWS_TL is referenced by following:

CS

VIEW - CS_CF_FLOWS_TL#

[top of page]

Table: CS_CF_FLOW_PAGES_B

Primary Key: CS_CF_FLOW_PAGES_B_PK

1. FLOW_ID
2. FLOW_TYPE_PAGE_ID

Foreign Keys from this table:

Comments

CS_CF_FLOW_PAGES_B stores the activation status of pages for particular flow type instances.
FLOW_ID references the primary key in CS_CF_FLOWS_B for a specific instance of a flow type.
PAGE_FLOW_TYPE_ID references the primary key in CS_CF_FLOW_TYPE_PAGES for the page of a flow type.
The ENABLED_FLAG specifies the activation status of this page in this instance of the flow type.

Indexes

Columns

[top of page]

CS.CS_CF_FLOW_PAGES_B does not reference any database object

CS.CS_CF_FLOW_PAGES_B is referenced by following:

CS

VIEW - CS_CF_FLOW_PAGES_B#

[top of page]

Table: CS_CF_FLOW_PAGES_TL

Primary Key: CS_CF_FLOW_PAGES_TL_PK

1. FLOW_ID
2. FLOW_TYPE_PAGE_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

This is the translation table for CS_CF_FLOW_PAGES_B.

Indexes

Columns

[top of page]

CS.CS_CF_FLOW_PAGES_TL does not reference any database object

CS.CS_CF_FLOW_PAGES_TL is referenced by following:

CS

VIEW - CS_CF_FLOW_PAGES_TL#

[top of page]

Table: CS_CF_FLOW_TYPE_PAGES

Primary Key: CS_CF_FLOW_TYPE_PAGES_PK

1. FLOW_TYPE_PAGE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CS_CF_FLOW_TYPE_PAGES lists the pages available for each flow type and their corresponding sequences in the flow.
The FUNCTION_NAME column stores the fnd_form_function which contains the physical jsp name for the corresponding PAGE_CODE.

Indexes

Columns

[top of page]

CS.CS_CF_FLOW_TYPE_PAGES does not reference any database object

CS.CS_CF_FLOW_TYPE_PAGES is referenced by following:

CS

VIEW - CS_CF_FLOW_TYPE_PAGES#

[top of page]

Table: CS_CF_SOURCE_CXT_TARGETS

Primary Key: CS_CF_SOURCE_CXT_TARGETS_PK

1. SOURCE_CONTEXT_TARGET_ID

Foreign Keys from this table:

Comments

CS_CF_SOURCE_CXT_TARGETS stores the code or id that references the location that contains the configuration information for a particular source code and context type combination. The location may differ depending on the source type. If the source type is for a particular page, the location will be referencing AK_REGIONS. If the source type is for a flow type, the location will be referencing CS_CF_FLOW_PAGES_B.
The Context_ValueX columns are used to store the values for the contexts. Depending on the type of context, one or more columns will be populated. Some of these columns may contain NULL values.
The Seed_Target_Value1 and Seed_Target_Value2 columns are used to store the target locations that are provided to the customers out-of-the-box. The Cust_Target_Value1 and Cust_Target_Value2 columns are used to store the target locations that are created and specified by the customers.

Indexes

Columns

[top of page]

CS.CS_CF_SOURCE_CXT_TARGETS does not reference any database object

CS.CS_CF_SOURCE_CXT_TARGETS is referenced by following:

CS

VIEW - CS_CF_SOURCE_CXT_TARGETS#

[top of page]

Table: CS_CF_SOURCE_CXT_TYPES

Primary Key: CS_CF_SOURCE_CXT_TYPES_PK

1. SOURCE_CONTEXT_TYPE_ID

Comments

CS_CF_SOURCE_CXT_TYPES is used to store all the possible contexts for a given source and is used in conjunction with other tables to store configurations for features in iSupport. This table is initially only a SEED table and will not be modified during normal operation.
A source type may refer to a page, a page flow typ, or other entities, as specified in the SOURCE_TYPE column.
The different context types allowed are defined in FND_LOOKUPS with a lookup type of IBU_CF_CONTEXT_TYPE. Each possible source is defined in FND_LOOKUPS with lookup types of IBU_CF_PAGE, or IBU_CF_FLOW_TYPE and can be extended to include other types as well.
Each source-context mapping is associated with a PRIORITY. This priority is used to determine the
precedence of the context types for each source type - the lower the priority, the higher the precedence.
SOURCE_CONTEXT_TYPE_ID is the unique identifier of each row.
For example:
The page IBU_SR_CR_IDENTIFY_PROBLEM may have different configurations stored at
the context levels GLOBAL and RESPONSIBILITY, with the configuration at the RESPONSIBILITY level taking precedence. Possible entries in this table may be
20 IBU_SR_CR_IDENTIFY_PROBLEM GLOBAL 50 IBU_CF_PAGE
30 IBU_SR_CR_IDENTIFY_PROBLEM RESP 40 IBU_CF_PAGE

Indexes

Columns

[top of page]

CS.CS_CF_SOURCE_CXT_TYPES does not reference any database object

CS.CS_CF_SOURCE_CXT_TYPES is referenced by following:

CS

VIEW - CS_CF_SOURCE_CXT_TYPES#

[top of page]

Table: CS_CHG_SUB_RESTRICTIONS

Primary Key: CS_CHG_SUB_RESTRICTIONS_PK

1. RESTRICTION_ID

Comments

Charges Auto Submission Restrictions

Indexes

Columns

[top of page]

CS.CS_CHG_SUB_RESTRICTIONS does not reference any database object

CS.CS_CHG_SUB_RESTRICTIONS is referenced by following:

CS

VIEW - CS_CHG_SUB_RESTRICTIONS#

[top of page]

Table: CS_CONTACTS

Primary Key: CS_CONTACTS_PK

1. CS_CONTACT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

CS.CS_CONTACTS does not reference any database object

CS.CS_CONTACTS is referenced by following:

CS

VIEW - CS_CONTACTS#

[top of page]

Table: CS_COST_DETAILS

Primary Key: CS_COST_DETAILS_PK

1. COST_ID

Comments

CS_COST_DETAILS stores details about Cost lines in Service. Cost lines can be created on behalf of a Service Request, a Depot Repair Order, or a Service/Debrief, but they will always have a parent Service Request.

Indexes

Columns

[top of page]

CS.CS_COST_DETAILS does not reference any database object

CS.CS_COST_DETAILS is referenced by following:

CS

VIEW - CS_COST_DETAILS#

[top of page]

Table: CS_COST_STAGING

Comments

This table is used as a staging table that would store all the charge lines for which cost details has to be created.

Indexes

Columns

[top of page]

CS.CS_COST_STAGING does not reference any database object

CS.CS_COST_STAGING is referenced by following:

CS

VIEW - CS_COST_STAGING#

[top of page]

Table: CS_COUNTER_DER_FILTERS

Primary Key: CS_COUNTER_DER_FILTERS_PK

1. COUNTER_DER_FILTER_ID

Foreign Keys from this table:

Comments

This table holds filters for group operation type of counter.

Indexes

Columns

[top of page]

CS.CS_COUNTER_DER_FILTERS does not reference any database object

CS.CS_COUNTER_DER_FILTERS is referenced by following:

CS

VIEW - CS_COUNTER_DER_FILTERS#

[top of page]

Table: CS_COUNTER_GRP_LOG

Primary Key: CS_COUNTER_GRP_LOG_PK

1. COUNTER_GRP_LOG_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This tables holds the logs of the counter updates withing a counter group.

Indexes

Columns

[top of page]

CS.CS_COUNTER_GRP_LOG does not reference any database object

CS.CS_COUNTER_GRP_LOG is referenced by following:

CS

VIEW - CS_COUNTER_GRP_LOG#

[top of page]

Table: CS_CP_AUDIT

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

CS.CS_CP_AUDIT does not reference any database object

CS.CS_CP_AUDIT is referenced by following:

CS

VIEW - CS_CP_AUDIT#

[top of page]

Table: CS_CP_LANGUAGES

Primary Key: CS_CP_LANGUAGES_PK

1. CP_LANGUAGE_ID

Foreign Keys from this table:

Comments

This table will store the languages appliacable to a product (to be used when Installed Base is used to store software products)

Columns

[top of page]

CS.CS_CP_LANGUAGES does not reference any database object

CS.CS_CP_LANGUAGES is referenced by following:

CS

VIEW - CS_CP_LANGUAGES#

[top of page]

Table: CS_CP_PARAMETERS

Primary Key: CS_CP_PARAMETERS_PK

1. CP_PARAMETER_ID

Foreign Keys from this table:

Comments

This table will be used to extend CS_CUSTOMER_PRODUCTS_ALL table.

Indexes

Columns

[top of page]

CS.CS_CP_PARAMETERS does not reference any database object

CS.CS_CP_PARAMETERS is referenced by following:

CS

VIEW - CS_CP_PARAMETERS#

[top of page]

Table: CS_CP_PARTIES_AUDIT

Primary Key: CS_CP_PARTIES_AUDIT_PK

1. CS_CP_PARTIES_AUDIT_ID

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns

[top of page]

CS.CS_CP_PARTIES_AUDIT does not reference any database object

CS.CS_CP_PARTIES_AUDIT is referenced by following:

CS

VIEW - CS_CP_PARTIES_AUDIT#

[top of page]

Table: CS_CP_REVISIONS

Primary Key: CS_CP_REVISIONS_PK

1. CP_REVISION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

CS.CS_CP_REVISIONS does not reference any database object

CS.CS_CP_REVISIONS is referenced by following:

CS

VIEW - CS_CP_REVISIONS#

[top of page]

Table: CS_CSZ_SEARCHES

Primary Key: CS_CSZ_SEARCHES_PK

1. SEARCH_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about the HTML Service saved search. The data does not need to support MLS, therefore we don't need a _B and _TL table. This table is populated through the Create/Update Saved Search page - header region.

Indexes

Columns

[top of page]

CS.CS_CSZ_SEARCHES does not reference any database object

CS.CS_CSZ_SEARCHES is referenced by following:

CS

VIEW - CS_CSZ_SEARCHES#

[top of page]

Table: CS_CSZ_SRCH_CRITERIA

Primary Key: CS_CSZ_SRCH_CRITERIA_PK

1. CRITERIA_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about the criteria in Saved Search. Each criteria belongs to a criteria group and may contain one or more values. This information is captured in Create/Update Saved Search page - Criteria region.

Indexes

Columns

[top of page]

CS.CS_CSZ_SRCH_CRITERIA does not reference any database object

CS.CS_CSZ_SRCH_CRITERIA is referenced by following:

CS

VIEW - CS_CSZ_SRCH_CRITERIA#

[top of page]

Table: CS_CSZ_SRCH_CRIT_GROUPS

Primary Key: CS_CSZ_SRCH_CRIT_GROUPS_PK

1. CRITERIA_GROUP_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about the criteria group, which is a grouping of one or more search criteria. Each group is displayed as a row on the search UI. This information is captured in Create/Update Saved Search page - Criteria region.

Indexes

Columns

[top of page]

CS.CS_CSZ_SRCH_CRIT_GROUPS does not reference any database object

CS.CS_CSZ_SRCH_CRIT_GROUPS is referenced by following:

CS

VIEW - CS_CSZ_SRCH_CRIT_GROUPS#

[top of page]

Table: CS_CSZ_SRCH_CRIT_VALUES

Primary Key: CS_CSZ_SRCH_CRIT_VALUES_PK

1. CRITERIA_ID
2. VALUE_SEQ

Foreign Keys from this table:

Comments

This table stores information about the criteria values used in search criteria. Each criteria may contain one or more criteria values. This information is captured in Create/Update Saved Search page - Criteria region.

Indexes

Columns

[top of page]

CS.CS_CSZ_SRCH_CRIT_VALUES does not reference any database object