Results for “csd_service_codes_vl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSD_SERVICE_CODES_VL is a translation-enabled (VL) database view owned by the APPS schema in Oracle E-Business Suite, belonging to the CSD – Depot Repair product family. It exposes depot repair service code definitions in a language-specific form by joining the service code base table with its corresponding translations table. Service codes are used throughout Depot Repair to classify the type of service or repair work being performed on a returned or depot-bound item, and they commonly drive defaulting, validation, billing, and reporting logic. Because the view is a VL view, it automatically restricts the translated descriptive columns to the session language, returning a single, correctly localized row per service code without requiring the calling form, report, or interface to handle language filtering explicitly. This makes it the standard access path for any component that needs to display or validate service code names and descriptions, and it is the object of interest for developers and functional analysts searching CSD_SERVICE_CODES_VL when investigating service code behavior or building custom queries.
Underlying Base Objects
The view is defined over two documented base objects, both referenced as synonyms in the APPS schema: CSD_SERVICE_CODES_B, the base table holding the language-independent attributes of each service code, and CSD_SERVICE_CODES_TL, the translations table holding the localized NAME and DESCRIPTION. The view text joins the two on SERVICE_CODE_ID and applies the language predicate CSCT.LANGUAGE = USERENV('LANG'), so only the row matching the current runtime language of the session is returned. Table aliases used in the definition are CSCB for the base table and CSCT for the translations table. The base table row identifier is surfaced as ROWID. Both underlying objects are documented as VALID in the ETRM metadata, and the view itself carries VALID status in the APPS schema.
Key Columns
- SERVICE_CODE_ID – Primary key of the service code, and the join key between the base and translation tables. Used as a foreign key by other Depot Repair entities.
- SERVICE_CODE – The language-independent short code used for validation and lookup.
- NAME – The translated display name of the service code, restricted to the session language.
- DESCRIPTION – The translated free-text description of the service code.
- ACTIVE_FROM / ACTIVE_TO – Effective date range controlling when the service code is valid for use.
- OBJECT_VERSION_NUMBER – Optimistic locking column used by the Oracle Applications Framework to detect concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – Descriptive flexfield (DFF) columns enabling customer-specific extensions on the service code.
Common Use Cases and Queries
Typical uses include populating service code list of values in Depot Repair forms, validating service codes entered through open interfaces or conversion programs, feeding custom reports and BI Publisher layouts, and joining to repair order lines for analytical reporting. A basic active service code lookup might read:
SELECT service_code_id, service_code, name, description, active_from, active_to FROM apps.csd_service_codes_vl WHERE TRUNC(SYSDATE) BETWEEN active_from AND NVL(active_to, TRUNC(SYSDATE)) ORDER BY service_code;
Because the view is language-aware, queries run under a different USERENV('LANG') automatically return the appropriate translated NAME and DESCRIPTION, so report logic need not reference the _TL table directly. For joins to transactional data, use SERVICE_CODE_ID rather than the SERVICE_CODE text to avoid language and uniqueness pitfalls. When DFF values are required, the ATTRIBUTE columns can be included; for very large extract volumes, filtering on ACTIVE_FROM and ACTIVE_TO first reduces the result set. Note that the ROWID column reflects the base table row and should not be persisted as a stable identifier; SERVICE_CODE_ID serves that purpose.
-
View: CSD_SERVICE_CODES_VL 12.2.2
APPS.CSD_SERVICE_CODES_VL·↳ CSD_SERVICE_CODES_B·↳ CSD_SERVICE_CODES_TL·Explore CSD module →
-
View: CSD_SERVICE_CODES_VL 12.1.1
APPS.CSD_SERVICE_CODES_VL·↳ CSD_SERVICE_CODES_B·↳ CSD_SERVICE_CODES_TL·Explore CSD module →
-
View: CSD_RO_APPLICABLE_SC_V 12.1.1
This view gets all the repair orders having applicable service codes, along with the applicable service codes.
APPS.CSD_RO_APPLICABLE_SC_V·↳ CSD_RO_SERVICE_CODES·↳ CSD_SERVICE_CODES_VL·Explore CSD module →
-
View: CSD_RO_APPLICABLE_SC_V 12.2.2
This view gets all the repair orders having applicable service codes, along with the applicable service codes.
APPS.CSD_RO_APPLICABLE_SC_V·↳ CSD_RO_SERVICE_CODES·↳ CSD_SERVICE_CODES_VL·Explore CSD module →
-
View: CSD_RO_SERVICE_CODES_V 12.1.1
Displays Service Codes associated to Repair Orders.
APPS.CSD_RO_SERVICE_CODES_V·↳ CSD_REPAIRS_V·↳ CSD_RO_SERVICE_CODES·↳ CSD_SERVICE_CODES_VL·Explore CSD module →
-
View: CSD_RO_SERVICE_CODES_V 12.2.2
Displays Service Codes associated to Repair Orders.
APPS.CSD_RO_SERVICE_CODES_V·↳ CSD_REPAIRS_V·↳ CSD_RO_SERVICE_CODES·↳ CSD_SERVICE_CODES_VL·Explore CSD module →
-
View: CSD_REPAIR_JOB_XREF_V 12.2.2
The view for getting repair order jobs.
APPS.CSD_REPAIR_JOB_XREF_V·↳ CSD_REPAIR_JOB_XREF·↳ CSD_SERVICE_CODES_VL·↳ FND_GLOBAL·Explore CSD module →
-
12.2.2 FND Design Data 12.2.2
-
View: CSD_REPAIR_JOB_XREF_V 12.1.1
The view for getting repair order jobs.
APPS.CSD_REPAIR_JOB_XREF_V·↳ CSD_REPAIR_JOB_XREF·↳ CSD_SERVICE_CODES_VL·↳ FND_GLOBAL·Explore CSD module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Fetches all the estimate lines for repair orders.
APPS.CSD_REPAIR_ESTIMATE_LINES_V·↳ BOM_RESOURCES_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
Fetches all the estimate lines for repair orders.
APPS.CSD_REPAIR_ESTIMATE_LINES_V·↳ BOM_RESOURCES_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ESTIMATE·Explore CSD module →
-
eTRM - CSD Tables and Views 12.1.1
Transaction table for the High Volume Repair module.