Results for “incident_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The CSF_DEBRIEF_SRC_NUMBERS_V view is an APPS-owned database object within the CSF (Field Service) product family in Oracle EBS 12.1.1 and 12.2.2. It is documented as a VALID view whose stated purpose is to support List of Values (LOV) selection in the Field Service Debrief user interface. The Debrief UI allows field service technicians and dispatchers to record the outcome of a service visit, and the "source number" LOV lets the user associate a debrief line to the originating work object — either a Service Request (SR) or a depot repair order (DR).
The view acts as a lightweight, read-only consolidation layer. Rather than forcing the UI to query the SR and repair schemas separately, the view presents a single, normalized result set in which both source categories share the same column shape. This is a common Oracle EBS design pattern for LOV providers: a UNION query that projects heterogeneous source data into a uniform contract used by the framework's LOV engine. Because it is a view rather than a table, it stores no data and incurs no maintenance or DML considerations; consumers simply SELECT from it.
Underlying Base Objects
The documented view text reveals four referenced objects: CS_INCIDENTS_ALL (synonym), CSD_REPAIRS (synonym), JTF_OBJECTS_VL (view), and JTF_TASKS_VL (view). These are joined in two branches combined by UNION.
- Service Request branch: joins JTF_TASKS_VL, CS_INCIDENTS_ALL, and JTF_OBJECTS_VL. The task's SOURCE_OBJECT_ID is equated to the incident ID, filtered to SOURCE_OBJECT_TYPE_CODE = 'SR', with the object looked up as OBJECT_CODE = 'SR'. This yields SR-sourced debrief numbers.
- Depot Repair branch: joins CSD_REPAIRS to JTF_OBJECTS_VL filtered to OBJECT_CODE = 'DR', producing repair-order-sourced rows.
The relationship to JTF_OBJECTS_VL is particularly relevant given the user's search term: that view resolves the JTF object type code to a human-readable NAME, and CSF_DEBRIEF_SRC_NUMBERS_V depends on it to derive the SOURCE_TYPE label. The two UNION branches supply complementary NULLs so that the final projection is column-aligned — SR rows populate INCIDENT_ID and leave REPAIR_LINE_ID null, while DR rows do the reverse, and DESCRIPTION is populated only for SR rows.
Key Columns
- SOURCE_NUMBER — the user-facing identifier: CSA.INCIDENT_NUMBER for Service Requests, CR.REPAIR_NUMBER for depot repairs. This is the LOV display value.
- SOURCE_TYPE — the descriptive type name drawn from JTF_OBJECTS_VL.NAME, providing the label shown alongside the number.
- SOURCE_TYPE_CODE — a hard-coded discriminator, 'SR' or 'DR', identifying which branch produced the row.
- INCIDENT_ID — the CS_INCIDENTS_ALL.INCIDENT_ID for SR rows; NULL for DR rows.
- REPAIR_LINE_ID — the CSD_REPAIRS.REPAIR_LINE_ID for DR rows; NULL for SR rows. Note the asymmetry: the DR branch keys on the repair line identifier.
- DESCRIPTION — the SR summary text for SR rows; NULL for DR rows.
Common Use Cases and Queries
The principal use case is populating the Debrief UI LOV, but the view is also convenient for reporting and integration where a unified list of service source numbers is required. A typical query retrieves all available sources:
SELECT source_number, source_type, source_type_code, incident_id, repair_line_id FROM csf_debrief_src_numbers_v ORDER BY 1;— the full LOV set.SELECT * FROM csf_debrief_src_numbers_v WHERE source_type_code = 'SR';— restricts to Service Requests.SELECT * FROM csf_debrief_src_numbers_v WHERE source_type_code = 'DR';— restricts to depot repairs.
Because the view joins the JTF and CS schemas without a WHERE clause driving on bind parameters, on large data volumes a developer should constrain by source_type_code or join back to specific incident/repair identifiers rather than scanning the full result set. As with all APPS views, query it through the standard EBS responsibility and security model; do not attempt DML against it.
-
This view is used for LOV purposes in Debrief UI.
APPS.CSF_DEBRIEF_SRC_NUMBERS_V·↳ CSD_REPAIRS·↳ CS_INCIDENTS_ALL·↳ JTF_OBJECTS_VL·Explore CSF module →
-
This table stores translated audit information for service requests.
-
This table stores contact points for a service requests.
-
View: CS_SR_TASK_NOTES_V 12.1.1
This is the base view in the notes section of the workbench tab for SR task Debrief Notes.
APPS.CS_SR_TASK_NOTES_V·↳ CS_INCIDENTS_ALL_B·↳ CS_LOOKUPS·↳ FND_GLOBAL·Explore CS module →
-
View: CS_SR_CONTRACT_NOTES_V 12.2.2
This is the base view in the notes section of the workbench tab for Contract notes.
APPS.CS_SR_CONTRACT_NOTES_V·↳ CS_INCIDENTS_ALL_B·↳ CS_LOOKUPS·↳ FND_GLOBAL·Explore CS module →
-
View: CS_SR_TASK_NOTES_V 12.2.2
This is the base view in the notes section of the workbench tab for SR task Debrief Notes.
APPS.CS_SR_TASK_NOTES_V·↳ CS_INCIDENTS_ALL_B·↳ CS_LOOKUPS·↳ FND_GLOBAL·Explore CS module →
-
PAY_IE_SOCIAL_BENEFITS_F holds the social benefit details for an assignment.This is a date tracked table
-
Resolving table for creating WIP jobs for mass repair orders.
-
Table: CS_SR_DUP_CHECK_TMP 12.2.2
-
View: CSP_MOVEORDER_LINES_V 12.2.2
Mover order lines including extra information for Spares Management
APPS.CSP_MOVEORDER_LINES_V·↳ CSP_MOVEORDER_LINES·Explore CSP module →
-
View: CSP_MOVEORDER_LINES_V 12.1.1
Mover order lines including extra information for Spares Management
APPS.CSP_MOVEORDER_LINES_V·↳ CSP_MOVEORDER_LINES·Explore CSP module →
-
Table: CS_SR_DUP_CHECK_TMP 12.1.1
-
View: CS_NEW_INCIDENTS_V_SEC 12.2.2
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_SR_REPORT_V 12.1.1
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 →
-
This is a copy of the PER_WORK_INCIDENTS table which is populated by the EFC (Euro as Functional Currency) process.
-
This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters.
-
This is a copy of the PER_WORK_INCIDENTS table which is populated by the EFC (Euro as Functional Currency) process.
-
This view is used for LOV purposes in Debrief UI.
APPS.CSF_DEBRIEF_SRC_NUMBERS_V·↳ CSD_REPAIRS·↳ CS_INCIDENTS_ALL·↳ JTF_OBJECTS_VL·Explore CSF module →
-
Holds all the recall lines under a recall.
-
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's groups.
APPS.CS_SR_UWQ_GROUP_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
View: CS_SR_UWQ_TEAM_COUNT_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's teams.
APPS.CS_SR_UWQ_TEAM_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's groups.
APPS.CS_SR_UWQ_GROUP_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
View: CS_SR_UWQ_TEAM_COUNT_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user's teams.
APPS.CS_SR_UWQ_TEAM_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
View: CS_SR_UWQ_EMP_COUNT_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in.
APPS.CS_SR_UWQ_EMP_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters.
-
Stores information that indicates whether the gateway server can access a service request.
-
This view is used by the Run time form to capture the details of a Service Request specific to CIC application. The details include Incident Address, Over ride Address Validation Flag and the SR attributes.
APPS.CUG_INCIDNT_ATTR_VALS_V·↳ CUG_INCIDNT_ATTR_VALS_VL·↳ CUG_SR_TYPE_ATTR_MAPS_VL·↳ FND_GLOBAL·Explore CUG module →
-
This view is used by the Run time form to capture the details of a Service Request specific to CIC application. The details include Incident Address, Over ride Address Validation Flag and the SR attributes.
APPS.CUG_INCIDNT_ATTR_VALS_V·↳ CUG_INCIDNT_ATTR_VALS_VL·↳ CUG_SR_TYPE_ATTR_MAPS_VL·↳ FND_GLOBAL·Explore CUG module →
-
Table: CSD_CC_TRXN_XREF 12.2.2
-
Stores Repair Order groups. Each group translates into one or more repair order lines.
-
Temporary table to store Log data for the JSP report to read directly.
-
Temporary table to store Log data for the JSP report to read directly.
-
View: CS_SR_UWQ_EMP_COUNT_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in.
APPS.CS_SR_UWQ_EMP_COUNT_V·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
This table contains the translatable attributes of a service request that was purged.
-
This table contains the translatable attributes of a service request that was purged.
-
Stores information that indicates whether the gateway server can access a service request.
-
View: CSD_RO_GROUP_DETAILS_V 12.1.1
Views that defines all the repair order details for a group.
APPS.CSD_RO_GROUP_DETAILS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
View: CS_SR_UWQ_V 12.2.2
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 →
-
This table stores translated audit information for service requests.
-
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: CSF_VALIDATE_TASKS_V 12.1.1
APPS.CSF_VALIDATE_TASKS_V·↳ CSF_EXT_LOCATIONS·↳ CSF_TASKS_PUB·↳ CS_INCIDENTS_ALL_B·Explore CSF module →
-
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: CSP_REQUIRED_PARTS_V 12.2.2
View which gives you the complete status of spare part requirements
APPS.CSP_REQUIRED_PARTS_V·↳ CSP_PART_PRIORITIES_V·↳ CSP_PICK_UTILS·↳ CSP_REQUIREMENT_HEADERS·Explore CSP module →
-
Table to store web conference details for an SR.
-
Table to store web conference details for an SR.
-
This table stores translated information about service requests.
-
This table stores translated information about service requests.