Table: CS_SR_RES_CODE_MAPPING | Oracle EBS ETRM Search

Table: CS_SR_RES_CODE_MAPPING 12.1.1 satellite-leaning

This table will contain the resolution code search criteria details. The resolution code -> search criteria association details will be stored in CS_SR_RES_CODE_MAPPING_DETAIL table.

CS.CS_SR_RES_CODE_MAPPING·Explore CS module →

View: CS_NEW_INCIDENTS_V_SEC 12.2.2

CS - Service·31 columns

This is a secured view created on top of the view CS_NEW_INCIDENTS_V

APPS.CS_NEW_INCIDENTS_V_SEC·↳ CSC_HZ_PARTIES_SELF_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: JTF_RS_PROBLEM_CODES_V 12.2.2

JTF - CRM Foundation·6 columns

Stores all valid problem codes for which resource skills can be assigned.

APPS.JTF_RS_PROBLEM_CODES_V·↳ FND_LOOKUP_VALUES·Explore JTF module →

View: CS_SR_REPORT_V 12.1.1

CS - Service·32 columns

This view is used in Service Request Summary/Detail report.

APPS.CS_SR_REPORT_V·↳ CSICUMPI_PUB·↳ CS_CUSTOMER_PRODUCTS·↳ CS_INCIDENTS_ALL_VL·Explore CS module →

Table: CS_SR_RES_CODE_MAPPING_DETAIL 12.2.2 link

owner CS·CS - Service·34 columns

This is the detail table. This table will contain the resolution code -> search criteria association details.

CS.CS_SR_RES_CODE_MAPPING_DETAIL·Explore CS module →

View: CS_SERVICE_REQUEST_PUB_V 12.1.1

CS - Service·38 columns

Service Request

APPS.CS_SERVICE_REQUEST_PUB_V·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →

View: CS_SR_UWQ_V 12.2.2

CS - Service·49 columns

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 information like Status, Severity, Escalation.

APPS.CS_SR_UWQ_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →

Table: CSY_RESOLUTION_QLTY 12.1.1 standalone

owner CS·CS - Service·20 columns

This table Service Request Resolution quality summary for agents and groups

CS.CSY_RESOLUTION_QLTY·Explore CS module →

Table: CSY_RESOLUTION_QLTY 12.2.2 standalone

owner CS·CS - Service·20 columns

This table Service Request Resolution quality summary for agents and groups

CS.CSY_RESOLUTION_QLTY·Explore CS module →

View: CSD_INCIDENTS_NON_SEC_V 12.1.1

CSD - Depot Repair·82 columns

The view for getting service request information.

APPS.CSD_INCIDENTS_NON_SEC_V·↳ AR_LOOKUPS·↳ CSD_PROCESS_UTIL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →

View: CS_SR_DUPLICATE_CHECK_V 12.2.2

CS - Service·12 columns

This view will be used as the base view for the duplicate check window in SR and SR tab

APPS.CS_SR_DUPLICATE_CHECK_V·↳ CS_INCIDENTS_ALL_VL·↳ CS_INCIDENT_STATUSES_VL·↳ CS_INCIDENT_TYPES_VL·Explore CS module →

View: CS_SR_UWQ_LABEL_V 12.2.2

CS - Service·49 columns

This view is a dummy view and will be used for creating label nodes in UWQ.

APPS.CS_SR_UWQ_LABEL_V·↳ DUAL·Explore CS module →

View: CS_SR_PROB_CODE_MAPPING_V 12.2.2

CS - Service·39 columns

This view lists the mapping of problem codes to service request types and inventory items.

APPS.CS_SR_PROB_CODE_MAPPING_V·↳ CS_INCIDENT_TYPES_VL·↳ CS_LOOKUPS·↳ CS_SR_PROB_CODE_MAPPING_DETAIL·Explore CS module →

Table: CS_SR_TSK_TMPL_GP_MAP 12.1.1 satellite-leaning

owner CS·CS - Service·16 columns

This table will store the mapping between template group and request type, product and product category.

CS.CS_SR_TSK_TMPL_GP_MAP·Explore CS module →

View: CS_SR_DUPLICATE_CHECK_V 12.1.1

CS - Service·12 columns

This view will be used as the base view for the duplicate check window in SR and SR tab

APPS.CS_SR_DUPLICATE_CHECK_V·↳ CS_INCIDENTS_ALL_VL·↳ CS_INCIDENT_STATUSES_VL·↳ CS_INCIDENT_TYPES_VL·Explore CS module →

View: CS_SR_UWQ_V 12.1.1

CS - Service·49 columns

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 information like Status, Severity, Escalation.

APPS.CS_SR_UWQ_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →

View: JTF_RS_PROBLEM_CODES_V 12.1.1

JTF - CRM Foundation·6 columns

Stores all valid problem codes for which resource skills can be assigned.

APPS.JTF_RS_PROBLEM_CODES_V·↳ FND_LOOKUP_VALUES·Explore JTF module →

View: CS_SR_UWQ_TEAM_V 12.2.2

CS - Service·52 columns

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 information like Status, Severity, Escalation.

APPS.CS_SR_UWQ_TEAM_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: CS_INCIDENTS_WORKFLOW_V 12.2.2

CS - Service·21 columns

Used by the Service Request Workflow

APPS.CS_INCIDENTS_WORKFLOW_V·↳ CSICUMPI_PUB·↳ CS_CUSTOMER_PRODUCTS·↳ CS_INCIDENTS_ALL_VL·Explore CS module →

Table: CS_SR_TSK_TMPL_GP_MAP 12.2.2 satellite-leaning

owner CS·CS - Service·16 columns

This table will store the mapping between template group and request type, product and product category.

CS.CS_SR_TSK_TMPL_GP_MAP·Explore CS module →

View: CS_NEW_INCIDENTS_V 12.1.1

CS - Service·31 columns

This is a simplified version of view CS_INCIDENTS_V

APPS.CS_NEW_INCIDENTS_V·↳ CSC_HZ_PARTIES_SELF_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →

View: CS_SR_REPORT_V 12.2.2

CS - Service·32 columns

This view is used in Service Request Summary/Detail report.

APPS.CS_SR_REPORT_V·↳ CSICUMPI_PUB·↳ CS_CUSTOMER_PRODUCTS·↳ CS_INCIDENTS_ALL_VL·Explore CS module →

Table: CS_SR_PROB_CODE_MAPPING_DETAIL 12.1.1 link

owner CS·CS - Service·33 columns

This is the problem code mapping detail table. This table will contain the problem code -> search criteria association details.

CS.CS_SR_PROB_CODE_MAPPING_DETAIL·Explore CS module →

Table: CS_SR_PROB_CODE_MAPPING_DETAIL 12.2.2 link

owner CS·CS - Service·33 columns

This is the problem code mapping detail table. This table will contain the problem code -> search criteria association details.

CS.CS_SR_PROB_CODE_MAPPING_DETAIL·Explore CS module →

Table: CS_SR_RES_CODE_MAPPING_DETAIL 12.1.1 link

owner CS·CS - Service·34 columns

This is the detail table. This table will contain the resolution code -> search criteria association details.

CS.CS_SR_RES_CODE_MAPPING_DETAIL·Explore CS module →

View: CS_INCIDENTS_VL_SEC 12.1.1

FND - Application Object Library·198 columns

APPS.CS_INCIDENTS_VL_SEC·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore FND module →

View: CS_SR_TERRITORY_V 12.1.1

CS - Service·37 columns

This view shows information about Service Request, and this is being used by Territory Management.

APPS.CS_SR_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: CS_SERVICE_REQUEST_PUB_V 12.2.2

CS - Service·38 columns

Service Request

APPS.CS_SERVICE_REQUEST_PUB_V·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →

View: CS_SR_PROB_CODE_MAPPING_V 12.1.1

CS - Service·39 columns

This view lists the mapping of problem codes to service request types and inventory items.

APPS.CS_SR_PROB_CODE_MAPPING_V·↳ CS_INCIDENT_TYPES_VL·↳ CS_LOOKUPS·↳ CS_SR_PROB_CODE_MAPPING_DETAIL·Explore CS module →

View: CS_SR_UWQ_LABEL_V 12.1.1

CS - Service·49 columns

This view is a dummy view and will be used for creating label nodes in UWQ.

APPS.CS_SR_UWQ_LABEL_V·↳ DUAL·Explore CS module →

Table: CS_SR_RES_CODE_MAPPING 12.2.2 satellite-leaning

owner CS·CS - Service·30 columns

This table will contain the resolution code search criteria details. The resolution code -> search criteria association details will be stored in CS_SR_RES_CODE_MAPPING_DETAIL table.

CS.CS_SR_RES_CODE_MAPPING·Explore CS module →

Table: CS_SR_PROB_CODE_MAPPING 12.1.1 satellite-leaning

owner CS·CS - Service·30 columns

This table has the mappings of all the problem codes to SR types and Inventory items.

CS.CS_SR_PROB_CODE_MAPPING·Explore CS module →

Table: CS_SR_PROB_CODE_MAPPING 12.2.2 satellite-leaning

owner CS·CS - Service·30 columns

This table has the mappings of all the problem codes to SR types and Inventory items.

CS.CS_SR_PROB_CODE_MAPPING·Explore CS module →

View: CS_SR_TASK_TERRITORY_V 12.2.2

CS - Service·41 columns

This view shows combined information of Service Request and task , and this is being used by Territory Management.

APPS.CS_SR_TASK_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: CSF_SR_HIST_V 12.2.2

CSF - Field Service·41 columns

Service History Extension View

APPS.CSF_SR_HIST_V·↳ CSF_SR_TASKS_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·Explore CSF module →

View: CS_NEW_INCIDENTS_V_SEC 12.1.1

CS - Service·31 columns

This is a secured view created on top of the view CS_NEW_INCIDENTS_V

APPS.CS_NEW_INCIDENTS_V_SEC·↳ CSC_HZ_PARTIES_SELF_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: CS_NEW_INCIDENTS_V 12.2.2

CS - Service·31 columns

This is a simplified version of view CS_INCIDENTS_V

APPS.CS_NEW_INCIDENTS_V·↳ CSC_HZ_PARTIES_SELF_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →

View: CSF_CT_TASKS 12.2.2

CSF - Field Service·107 columns

Base view of 'Tasks' block in CSFCTTKS form. Selects only tasks with source document 'Service Request'

APPS.CSF_CT_TASKS·↳ CSF_TASKS_PUB·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·Explore CSF module →

View: CS_SYSTEM_SR_LINKS_V 12.1.1

CS - Service·34 columns

APPS.CS_SYSTEM_SR_LINKS_V·↳ CS_INCIDENTS_ALL_VL·↳ CS_SYSTEMS_ALL_VL·↳ CS_SYSTEM_SR_LINKS·Explore CS module →

View: CS_INCIDENTS_WORKFLOW_V 12.1.1

CS - Service·21 columns

Used by the Service Request Workflow

APPS.CS_INCIDENTS_WORKFLOW_V·↳ CSICUMPI_PUB·↳ CS_CUSTOMER_PRODUCTS·↳ CS_INCIDENTS_ALL_VL·Explore CS module →

View: CS_INCIDENTS_ALL_VL 12.1.1

CS - Service·199 columns

Multi-lingual view for CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL tables.

APPS.CS_INCIDENTS_ALL_VL·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: CS_SR_SEARCH_V 12.1.1

CS - Service·144 columns

This view is used in the SR find window on Bali spread table

APPS.CS_SR_SEARCH_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →

View: CS_SR_RES_CODE_MAPPING_V 12.1.1

CS - Service·41 columns

This view lists the mapping of resolution codes to service request types and inventory items.

APPS.CS_SR_RES_CODE_MAPPING_V·↳ CS_INCIDENT_TYPES_VL·↳ CS_LOOKUPS·↳ CS_SR_RES_CODE_MAPPING_DETAIL·Explore CS module →

View: CS_SR_RES_CODE_MAPPING_V 12.2.2

CS - Service·41 columns

This view lists the mapping of resolution codes to service request types and inventory items.

APPS.CS_SR_RES_CODE_MAPPING_V·↳ CS_INCIDENT_TYPES_VL·↳ CS_LOOKUPS·↳ CS_SR_RES_CODE_MAPPING_DETAIL·Explore CS module →

Table: JTF_RS_RESOURCE_SKILLS 12.2.2 standalone

owner JTF·JTF - CRM Foundation·35 columns

This table stores the skills for individual resource

JTF.JTF_RS_RESOURCE_SKILLS·Explore JTF module →

Table: JTF_RS_RESOURCE_SKILLS 12.1.1 standalone

owner JTF·JTF - CRM Foundation·35 columns

This table stores the skills for individual resource

JTF.JTF_RS_RESOURCE_SKILLS·Explore JTF module →

Table: AHL_UC_DETAILS_FOR_HGRID 12.2.2 standalone

AHL - Complex Maintenance Repair and Overhaul·72 columns

APPS.AHL_UC_DETAILS_FOR_HGRID·Explore AHL module →

View: CS_SR_UWQ_GROUP_V 12.1.1

CS - Service·52 columns

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 information like Status, Severity, Escalation.

APPS.CS_SR_UWQ_GROUP_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: CS_SR_UWQ_GROUP_V 12.2.2

CS - Service·52 columns

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 information like Status, Severity, Escalation.

APPS.CS_SR_UWQ_GROUP_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →

View: CS_SYSTEM_SR_LINKS_V 12.2.2

CS - Service·34 columns

APPS.CS_SYSTEM_SR_LINKS_V·↳ CS_INCIDENTS_ALL_VL·↳ CS_SYSTEMS_ALL_VL·↳ CS_SYSTEM_SR_LINKS·Explore CS module →

Results for “problem_code”