Results for “urgency_id”
48 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSD_REPAIR_JOBS_V is a seeded, VALID APPS-schema view in the Oracle E-Business Suite Depot Repair (CSD) module. Its documented purpose is to return depot repair orders joined with their originating service request information. The view consolidates data from the Depot Repair transaction tables and the Service (TeleService) incident tables, together with supporting master data such as inventory items, customer accounts, parties, item instances, and repair types. Because it combines repair execution data with service request context, it is widely used for reporting, inquiry, and integration purposes, allowing a single query to retrieve repair number, incident number, item, quantity in process, approval status, and repair status simultaneously.
Underlying Base Objects
The documented referenced objects are CSD_REPAIRS, CSD_REPAIR_TYPES_VL, CSI_ITEM_INSTANCES, CS_INCIDENTS_ALL_B, CS_INCIDENT_SEVERITIES_VL, CS_INCIDENT_STATUSES_VL, CS_INCIDENT_TYPES_VL, CS_INCIDENT_URGENCIES_VL, FND_GLOBAL, FND_LOOKUPS, HZ_CUST_ACCOUNTS, HZ_PARTIES, MTL_SYSTEM_ITEMS_VL, and PER_ALL_PEOPLE_F. The repair line identifier (REPAIR_LINE_ID) and repair attributes are sourced from CSD_REPAIRS (referenced via synonym, aliased DRA in the view text). The service request columns (incident identifier, incident number, customer, caller type) derive from CS_INCIDENTS_ALL_B (SR). Item data, including concatenated segments, description, and organization, is drawn from MTL_SYSTEM_ITEMS_VL (ITEM). Repair type descriptions come from CSD_REPAIR_TYPES_VL, customer product reference numbers from CSI_ITEM_INSTANCES, and customer information via HZ_CUST_ACCOUNTS and HZ_PARTIES. FND_GLOBAL supplies session context, while FND_LOOKUPS and various _VL views supply translated meanings.
Key Columns
Identity and control columns include ROW_ID, REPAIR_LINE_ID, REPAIR_NUMBER, INCIDENT_ID, and INCIDENT_NUMBER. Transaction and quantity columns include REPAIR_ORDER_QUANTITY, RELEASED_QUANTITY, REMAINING_QUANTITY, QUANTITY_IN_WIP, RECEIVED_QUANTITY, and QUANTITY_SHIPPED, with NVL defaults of zero applied to the receipt and WIP quantities. Item and instance columns include INVENTORY_ITEM_ID, ITEM (concatenated segments), ITEM_DESC, ORGANIZATION_ID, UNIT_OF_MEASURE, REFERENCE_NUMBER, and SERIAL_NUMBER. Status and approval columns include APPROVAL_REQUIRED_FLAG, APPROVAL_STATUS, APPROVAL_STATUS_MEANING, STATUS, STATUS_MEANING, and DATE_CLOSED. Additional attributes cover REPAIR_TYPE, REPAIR_TYPE_ID, PROMISE_DATE, PROJECT_ID, TASK_ID, CUSTOMER_PRODUCT_ID, and an extensive ATTRIBUTE_CATEGORY/ATTRIBUTE1–12 descriptive flexfield set. Note that RESOURCE_NAME and JOB_TITLE are defined as literal NULL placeholders in the view text.
Common Use Cases and Queries
- Repair order reporting by status, repair type, or promise date.
- Service request correlation, linking incidents to repair lines.
- WIP quantity tracking for repairs not yet completed.
- Customer and product analysis using account and instance data.
A typical query filtered on the repair status and service request context:
SELECT REPAIR_NUMBER, INCIDENT_NUMBER, ITEM, STATUS_MEANING, REMAINING_QUANTITY, PROMISE_DATE FROM CSD_REPAIR_JOBS_V WHERE STATUS_MEANING = 'Awaiting Repair' AND TRUNC(PROMISE_DATE) >= TRUNC(SYSDATE);
Regarding the search term "severity_id," the documented view text does not expose a SEVERITY_ID column; incident severity is referenced only through CS_INCIDENT_SEVERITIES_VL as a base object, and the view selects incident attributes such as CALLER_TYPE and CUSTOMER_ID rather than the severity identifier. Consult that base view or CS_INCIDENTS_ALL_B directly when severity is required.
-
View: CSD_REPAIR_JOBS_V 12.2.2
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_REPAIR_JOBS_V 12.1.1
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.1.1
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.2.2
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.2.2
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.1.1
-
PACKAGE: APPS.SR_UWQ_INTEG 12.1.1
-
PACKAGE: APPS.SR_UWQ_INTEG 12.2.2
-
eTRM - CSD Tables and Views 12.1.1
Transaction table for the High Volume Repair module.
-
eTRM - CSD Tables and Views 12.2.2
Transaction table for the High Volume Repair module.