CS Views (218)

CS - Service — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`CSY_PERIODS_V`	This view returns all the periods used by Embedded Analytics
`CS_ACC_CP_RG_V`	This view is used by the main service request form for a record group to retrieve install base information.
`CS_ACC_CP_RG_V_1155`	This view is used by the main service request form for a record group to retrieve install base information.
`CS_BRM_3D_SERVICE_REQUEST_V`	3D Service Request View used by the Business Rule Monitor.
`CS_BUS_PROCESS_TXNS_V`	View to show transaction groups
`CS_CF_FLOWS_VL`	Multi-lingual view for CS_CF_FLOWS_B and CS_CF_FLOWS_TL tables.
`CS_CF_FLOW_PAGES_VL`	Multi-lingual view for CS_CF_FLOW_PAGES_B and CS_CF_FLOW_PAGES_TL tables.
`CS_CHARGE_DETAILS_V`	Charge Lines associated with Service request,depot repair and Field Service Report
`CS_CONFIG_RG_V`	Configuration Information for product and its subcomponents
`CS_CONTACTS_V`	Information regarding the Resources and their type of contacts in Installedbase
`CS_CONTRACT_COVERAGES_V`	List of Contracts and Coverages available
`CS_CONT_CONTACTS_RG_V`	Contact Information
`CS_COUNTERS_QF_V`	View used for find window in counter setup form
`CS_COUNTERS_V`	Counters View
`CS_COUNTER_DER_FILTERS_V`	Derive counter filters view
`CS_COUNTER_GROUPS_V`	Counter groups view
`CS_COUNTER_PROPERTIES_V`	Counter properties view
`CS_CP_ADDRESSES_V`	Installed at / Ship To information of the Product
`CS_CP_AGREEMENTS_RG_V`	List of agreements pertaining t oeach party
`CS_CP_AUDIT_MAINTAIN_V`	View of the Customer Product Audit table
`CS_CP_AUDIT_MAINT_V`	Audit information for customer products
`CS_CP_AUDIT_V`	Audit table view for transferred products
`CS_CP_BILLTOADD_RG_V`	Bill To Address info of a Product
`CS_CP_CONTRACTS_V`	This view lists information regarding counter groups
`CS_CP_COUNTERS_V`	This view contains the information pertaining to counters (values,groups)
`CS_CP_INCLUDED_ITEMS_V`	Included items of a product in the installed base
`CS_CP_MAINT_V`	Products in the installed base
`CS_CP_ORDERINFO_RG_V`	This view lists the order information
`CS_CP_PARAMETERS_V`	This view lists the Parameter details of each product in InstalledBase.
`CS_CP_REVISIONS_MAINT_V`	Revision Details of a Product in InstalledBase
`CS_CP_SERVICES`	All services assigned to customer products
`CS_CP_SYSTEMS_MAINT_V`	System details of a product in InstalledBase
`CS_CTR_ASSOCIATIONS_V`	Counter group associations view
`CS_CTR_COUNTERS_HISTORY_V`	Counter readings history view
`CS_CTR_COUNTER_GRP_LOG_V`	Counter group log view
`CS_CTR_COUNTER_READINGS_V`	Counter reading view
`CS_CTR_COUNTER_VALUES_V`	Counter values view
`CS_CTR_CSXCTCCV_PROPERTY_V`	View used in CSXCTCCV form
`CS_CTR_ESTIMATE_READINGS_V`	View for counter estimate readings
`CS_CTR_ESTIMATION_METHODS_V`
`CS_CTR_FORMULA_BVARS_V`	Counter formula reference variable's view
`CS_CTR_PROPERTY_VALUES_V`	Counter property values view
`CS_CUSTOMER_PRODUCTS`	A view of customer products by organization.
`CS_CUSTOMER_PRODUCTS_CONFIRM_V`	Customer products
`CS_CUSTOMER_PRODUCTS_DEFINE_V`	Customer products
`CS_CUSTOMER_PRODUCTS_MAINT_V`	Products in the installed base
`CS_CUSTOMER_PRODUCTS_REPORT_V`	- Retrofitted
`CS_CUSTOMER_PRODUCTS_RG_V`	This view stores information pertaining to the Products in InstalledBase
`CS_CUSTOMER_PRODUCTS_RMA_V`	This view stores product information
`CS_CUSTOMER_PRODUCT_TRANSFER_V`	Customer Products
`CS_CUST_PROD_FORM_V`
`CS_CUST_PROD_MAINT_V`	New View for Customer Products - Performance
`CS_FORUM_ATTRS_VL`	Multi-lingual view for CS_FORUM_ATTRS_B and CS_FORUM_ATTRS_TL tables.
`CS_FORUM_CATEGORIES_VL`	Multi-lingual view for CS_FORUM_CATEGORIES_B and CS_FORUM_CATEGORIES_TL tables.
`CS_FORUM_MESSAGES_VL`	Multi-lingual view for CS_FORUM_MESSAGES_B and CS_FORUM_MESSAGES_TL tables.
`CS_HZ_SR_CONTACT_POINTS_V`	This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table.
`CS_IB_EMPLOYEES_V`
`CS_IB_PARTY_NAME_V`
`CS_IB_W_EMPLOYEES_V`
`CS_INCIDENTS_ALL_VL`	Multi-lingual view for CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL tables.
`CS_INCIDENTS_AUDIT_VL`	Multi-lingual view for CS_INCIDENTS_AUDIT_B and CS_INCIDENTS_AUDIT_TL tables.
`CS_INCIDENTS_B_SEC`
`CS_INCIDENTS_DIARY_V`	This view is not used anymore. This has been obsoleted. Starting 11.5.6 this view will not be supported and will remain just for backward co
`CS_INCIDENTS_PURGE_AUDIT_VL`	This is a _VL view. This view will be based on table cs_incidents_purge_audit_b and cs_incidents_purge_audit_tl table.
`CS_INCIDENTS_V`	Service requests and their attributes. This view is used by the main service request form.
`CS_INCIDENTS_VL_SEC`
`CS_INCIDENTS_WORKFLOW_V`	Used by the Service Request Workflow
`CS_INCIDENT_LINKS_FROM_V`	Show all Service Requests that are linked from another service request to this Service request.
`CS_INCIDENT_LINKS_TO_V`	Show a Service Request that have linked to other documents such as Service Requests or Defect.
`CS_INCIDENT_LINKS_TO_V_SEC`	This is a secured view on cs_incidents_links_to_v
`CS_INCIDENT_SEVERITIES_VL`	Multi-lingual view for CS_INCIDENT_SEVERITIES_B and CS_INCIDENT_SEVERITIES_TL tables.
`CS_INCIDENT_STATUSES_VL`	Multi-lingual view for CS_INCIDENT_STATUSES_B and CS_INCIDENT_STATUSES_TL tables.
`CS_INCIDENT_TYPES_RG_V`	Returns service request types for an LOV on main service request form.
`CS_INCIDENT_TYPES_RG_V_SEC`	Returns service request types for an LOV on main service request form.
`CS_INCIDENT_TYPES_VL`	Multi-lingual view for CS_INCIDENT_TYPES_B and CS_INCIDENT_TYPES_TL tables.
`CS_INCIDENT_URGENCIES_VL`	Multi-lingual view for CS_INCIDENT_URGENCIES_B and CS_INCIDENT_URGENCIES_TL tables. Refer to Base Tables for details.
`CS_INC_RELATED_STATUSES_V`	Related statuses for a service request type
`CS_INST_CONTACT_DTLS_V`	This view lists the details of the contacts pertaining to Installation Details
`CS_INST_DETAIL_CONTACTS_V`	This view lists the contact information pertaining to the Installation Details
`CS_INTERACTIONS_V`	- Retrofitted
`CS_JTF_RESOURCES_V`	Resource Details
`CS_JTF_RS_RESOURCE_EXTNS_SEC`	Main resource view that stores all resource data.
`CS_KB_ATTRS_VL`	Multi-lingual view for CS_KB_ATTRS_B and CS_KB_ATTRS_TL tables.
`CS_KB_ATTR_VALS_VL`	Multi-lingual view for CS_KB_ATTR_VALS_B and CS_KB_ATTR_VALS_TL tables.
`CS_KB_AUTOLINKS_VL`	Knowledge Base Autolinks Multi Lingual View
`CS_KB_CATEGORY_GROUPS_VL`	Knowledge Base Category Groups Multi Lingual View
`CS_KB_CTXT_REPO_MAPS_VL`	MultiLingual View for CS_KB_CTXT_REPO_MAPS_B / _TL
`CS_KB_ELEMENTS_V`	A view on top of CS_KB_ELEMENTS_VL and CS_KB_ELEMENT_TYPES_VL.
`CS_KB_ELEMENTS_VL`	Multi-lingual view for CS_KB_ELEMENTS_B and CS_KB_ELEMENTS_TL tables.
`CS_KB_ELEMENT_TYPES_VL`	Multi-lingual view for CS_KB_ELEMENT_TYPES_B and CS_KB_ELEMENT_TYPES_TL tables.
`CS_KB_HISTORIES_VL`	Multi-lingual view for CS_KB_HISTORIES_B and CS_KB_HISTORIES_TL tables.
`CS_KB_INTEGRATION_V`	View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any applica
`CS_KB_LIB_PROPERTIES_V`	View nolonger used.
`CS_KB_LIB_PROPERTIES_VL`	View nolonger used.
`CS_KB_LINKED_SOLUTIONS_VIEW`	Linked Solutions View
`CS_KB_SECTIONS_V`	View nolonger used.
`CS_KB_SECURE_SOLUTIONS_VIEW`	Secure Solutions View
`CS_KB_SETS_V`	A view on top of CS_KB_SETS_VL and CS_KB_SET_TYPES_VL.
`CS_KB_SETS_VL`	Multi-lingual view for CS_KB_SETS_B and CS_KB_SETS_TL tables.
`CS_KB_SET_ELEMENTS_V`	A view on top of CS_KB_SETS_V, CS_KB_ELEMENTS_V, and CS_KB_SET_ELES.
`CS_KB_SET_TYPES_VL`	Multi-lingual view for CS_KB_SET_TYPES_B and CS_KB_SET_TYPES_TL tables.
`CS_KB_SOLN_CATEGORIES_VL`	Multi-lingual view for solution categories
`CS_KB_USED_SUM_DEFS_VL`	Multi-lingual view for CS_KB_USED_SUM_DEFS_B and CS_KB_USED_SUM_DEFS_TL tables.
`CS_KB_VISIBILITIES_VL`	Knowledge Base Visibilities Multi Lingual View
`CS_KB_WF_FLOWS_VL`	Knowledge Base Authoring Flows Multi Lingual View
`CS_LINE_INST_DETAILS_V`	This view stores information regarding installation details of product captured during order or quote entry.
`CS_LOCATION_V`
`CS_LOOKUPS`	A view of all the Lookups that belong to product CS.
`CS_MESSAGES_V`	All messages and their corresponding attributes
`CS_MFS_INTERFACE`
`CS_MULTI_ORG_RULES_V`	This view shows all the rules and rule order for Multi org rules.
`CS_NEW_ACCOUNT_RG_V`	New Account Infomation for Transfer Product
`CS_NEW_INCIDENTS_V`	This is a simplified version of view CS_INCIDENTS_V
`CS_NEW_INCIDENTS_V_SEC`	This is a secured view created on top of the view CS_NEW_INCIDENTS_V
`CS_NEW_SYSTEMS_RG_V`	New system Information for Transfer Product
`CS_PARTY_ROLES_VL`	This is a _VL view. This view is based on table cs_party_roles_b and _tl table.
`CS_PARTY_ROLE_GROUPS_VL`	This is a _VL view. This view is based on table cs_party_role_groups_b and _tl table.
`CS_PR_OCV`	This view will read the object classifications (Party Role) for extensible attributes.
`CS_RA_ADDR_INSTALL_RG_V`	- Retrofitted
`CS_RA_ADDR_LOC_RG_V`	Customer product locations
`CS_RA_ADDR_SHIP_RG_V`	Customer Product Ship locations
`CS_REGIONS_VL`	Multi-lingual view for CS_REGIONS_B and CS_REGIONS_TL tables.
`CS_RESOURCE_DETAILS_V`
`CS_RETURNS_RG_V`	This View is a replica of the ASO object aso_returns_v
`CS_SERVICE_REQUEST_PUB_V`	Service Request
`CS_SO_NEWS_VL`	Multi-lingual view for CS_SO_NEWS_B and CS_SO_NEWS_TL tables.
`CS_SR_ACCESS_RESP_SEC`
`CS_SR_ACTION_CODES_VL`	View for all action defnitions. The view is based off cs_sr_action_codes_b and tl.
`CS_SR_ACTIVITIES_V`	This view is to list all the activities associated to a service requst.
`CS_SR_ALL_NOTES_V`	This is the base view in the notes section of the workbench tab for Contract notes.
`CS_SR_CONTACT_DETAILS_V`	This view obtains the contact information such as Job Title, Address etc. for each of the contacts pertaining to a service request depending
`CS_SR_CONTACT_POINTS_V`	This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts.
`CS_SR_CONTRACT_NOTES_V`	This is the base view in the notes section of the workbench tab for Contract notes.
`CS_SR_CP_NEW_ACCT_EAM_RG_V`	This view is used to filter the List of Values for the Product Related fields for eAM Service Requests.
`CS_SR_DUPLICATE_CHECK_V`	This view will be used as the base view for the duplicate check window in SR and SR tab
`CS_SR_EVENT_CODES_VL`	View for all event defnitions. View is based on cs_sr_event_codes_b and tl.
`CS_SR_FIND_EAM_PROD_MAINT_V`	This view is used to filter Instance related fields LOV in Search Installed Base UI.
`CS_SR_FIND_PROD_MAINT_EAM_V`	This view is used to bring eAM Assets in Find Product UI
`CS_SR_FIND_PROD_MAINT_P_EAM_V`	This view is used to bring eAM Assests in Find Product UI
`CS_SR_FULFIL_STATUS_V`	For a particular Source Object and Source Object Id, this View is used to retrieve the status of a submitted fulfillment request.
`CS_SR_HZ_CONT_PTS_EMAILS_V`
`CS_SR_HZ_CONT_PTS_P_PHONES_V`	This view lists all the active primary phones from HZ_CONTACT_POINTS.
`CS_SR_HZ_CUST_CONT_V`	This view lists all the customer contacts for party types PARTY_RELATIONSHIP and PERSON.
`CS_SR_HZ_RELATIONSHIPS_V`	View for details of Related, Subject, Object party.
`CS_SR_INCIDENTS_V`	Base view for SR main form.
`CS_SR_INCIDENTS_V_SEC`	Base view for SR main form.
`CS_SR_INCIDENT_ADDRESS_V`	This view has the address of the contacts for a service request.
`CS_SR_INSTALLBASE_NOTES_V`	This is the base view in the notes section of the workbench tab for Contract notes.
`CS_SR_INTERACTIONS_V`	This view is to list all the Interactions associated to a service requst.
`CS_SR_INV_COMPONENTS_V`	This view shows all inventory components from BOM.
`CS_SR_INV_SUBCOMPONENTS_V`	This view shows all inventory subcomponents from BOM.
`CS_SR_KB_NOTE_LINKS_V`	This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Req
`CS_SR_KB_SOLUTION_LINKS_V`	This is the base view in the notes section of the workbench tab for Knowledge Base solution notes.
`CS_SR_LINKS_EXT_V`	This view lists all the external links for a service request.
`CS_SR_LINK_TYPES_VL`	View has information of service request relationship types. This view is based on CS_SR_LINK_TYPES_B and _TL and is used to select the tran
`CS_SR_LINK_VALID_OBJ_V`
`CS_SR_LOAD_BALANCE_WT_V`	This view contains data of all the load balance weights.
`CS_SR_MEMBERS_V`	Group and Individual Owners
`CS_SR_MEMBERS_V_SEC`	Secured view on cs_sr_members_v
`CS_SR_NEW_ACC_CP_RG_V`	This view is used by the main service request form for a record group to retrieve release 11.5.6 and higher, install base informationr .
`CS_SR_NEW_FIND_PROD_MAINT_P_V`	This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticu
`CS_SR_NEW_FIND_PROD_MAINT_V`	This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticu
`CS_SR_NEW_PRODUCTS_MAINT_V`	This view contains the information about all products in the InstallBase release 11.5.6 and higher . This view is used to get all product
`CS_SR_NOTES_V`	This is the base view in the notes section of the workbench tab for SR notes.
`CS_SR_NULL_V`	View used to create the Contracts grid on the Results section of Search Installed Base window.
`CS_SR_OCV`	This view has been created for SR extensible attributes only.
`CS_SR_OWNERS_SEARCH_V`	This view is used to retrieve owner name of an SR
`CS_SR_OWNERS_V`	This view shows all resources of type 'EMPLOYEE', 'TEAM' and 'GROUP'
`CS_SR_PARTY_ADDRESS_V`	This view details the address information of all parties. The address column is a concatenated form of the address from HZ_PARTIES.
`CS_SR_PREFERRED_LANG_V`	This view gives the customers preferred language.
`CS_SR_PROB_CODE_MAPPING_V`	This view lists the mapping of problem codes to service request types and inventory items.
`CS_SR_PRODUCTS_MAINT_V`	This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticu
`CS_SR_REPORT_V`	This view is used in Service Request Summary/Detail report.
`CS_SR_RES_CODE_MAPPING_V`	This view lists the mapping of resolution codes to service request types and inventory items.
`CS_SR_SAVED_SEARCHES_VL`	View has information of service request saved searches.
`CS_SR_SEARCH_NO_CONT_V`	This view is used in the SR find window on Bali spread table and in the Service History Bali Spreadtable of SR Tab
`CS_SR_SEARCH_V`	This view is used in the SR find window on Bali spread table
`CS_SR_SERVICE_HISTORY_V`	This view is being used by Service History Tab
`CS_SR_STATUS_GROUPS_VL`	This view contains information about the Service request Status rules. Based on the CS_STATUS_GROUPS_B and CS_STATUS_GROUPS_TL tables.
`CS_SR_SYSTEMS_V`	This view brings data related to systems and corresponding customer details.
`CS_SR_TASKS_V`	This view is used by the task functionality of the service request form. This has all the task related information which are relevant to Ser
`CS_SR_TASK_DEBRIEF_NOTES_V`	This is the base view in the notes section of the workbench tab for Task debrief notes.
`CS_SR_TASK_NOTES_V`	This is the base view in the notes section of the workbench tab for SR task Debrief Notes.
`CS_SR_TASK_TERRITORY_V`	This view shows combined information of Service Request and task , and this is being used by Territory Management.
`CS_SR_TERRITORY_V`	This view shows information about Service Request, and this is being used by Territory Management.
`CS_SR_TYPES_SELECT_SEC`
`CS_SR_TYPE_CATEGORIES_VL`	This view contains information about the Service Request Type categories.
`CS_SR_TYPE_MAPPING_V`	This view contains the asssociation between the incident type, responsiblity, with a template.
`CS_SR_UWQ_EMPLOYEE_V`	This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of infor
`CS_SR_UWQ_EMP_COUNT_V`	This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in.
`CS_SR_UWQ_GROUP_COUNT_V`	This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's groups.
`CS_SR_UWQ_GROUP_V`	This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of infor
`CS_SR_UWQ_LABEL_V`	This view is a dummy view and will be used for creating label nodes in UWQ.
`CS_SR_UWQ_NODES_VL`	The base view for the form CSXNODES. This view shows all the user defined UWQ nodes for Service Request.
`CS_SR_UWQ_TEAM_COUNT_V`	This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's teams.
`CS_SR_UWQ_TEAM_V`	This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of infor
`CS_SR_UWQ_UNOWNED_V`	This view is used by the UWQ (Universal Work Queue) to query up Service Requests that are not owned. The view is a snapshot of information l
`CS_SR_UWQ_V`	This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of infor
`CS_SYSTEMS_ALL_VL`	Systems (all orgs, single language view)
`CS_SYSTEMS_CP_MAINT_V`	Systems and their attributes
`CS_SYSTEMS_FIND_V`	View Table for System Id field in find block
`CS_SYSTEMS_RG_V`	System Information
`CS_SYSTEMS_V`
`CS_SYSTEMS_VL`	Systems (single-org, single language view)
`CS_SYSTEM_BILLTO_LOC_RG_V`
`CS_SYSTEM_CONTACTS_RG_V`
`CS_SYSTEM_PARAMETERS`	Implementation options for Oracle Service.
`CS_SYSTEM_PARTY_LINKS_V`
`CS_SYSTEM_SR_LINKS_V`
`CS_TAX_LINES_SUMMARY_V`	View provided for the Taxation module.
`CS_TEMPLATES_VL`	This view holds all the template metadata.
`CS_TEMPLATE_DETAILS_V`	This view has all the attributes for the templates.
`CS_TP_CHOICES_VL`	Multi-lingual view for CS_TP_CHOICES_B and CS_TP_CHOICES_TL tables.
`CS_TP_QUESTIONS_VL`
`CS_TP_TEMPLATES_VL`
`CS_TRANSACTION_TYPES_V`	Transaction types
`CS_TRANSACTION_TYPES_VL`	Single language view of CS_TRANSACTION_TYPES_B and CS_TRANSACTION_TYPES_VL
`CS_W_RESOURCE_DETAILS_V`