Search Results csd_bulletin_scs

Overview

CSD_BULLETIN_SCS is a child table within the CSD (Depot Repair) product schema of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It records the association between depot repair bulletins and service codes, allowing a single bulletin to be linked to one or more service codes. Bulletins in Depot Repair communicate repair instructions, safety notices, or coverage rules to technicians, and the service code linkage determines which repair activities, service types, or pricing codes the bulletin applies to.

From a heuristic Data Vault modeling perspective, CSD_BULLETIN_SCS is best classified as a link table. It resolves a many-to-many relationship between two business entities — CSD_BULLETINS_B (the bulletin header) and CSD_SERVICE_CODES_B (the service code master) — and carries no descriptive attributes of its own beyond standard audit and concurrency columns. This classification is inferred from the foreign key structure and the presence of a composite unique index on the two foreign key columns.

Key Information Stored

The table contains nine documented columns. The most significant are:

BULLETIN_SC_ID — Surrogate primary key (CSD_BULLETIN_SCS_PK1) uniquely identifying each association row.
BULLETIN_ID — Foreign key to CSD_BULLETINS_B identifying the parent bulletin.
SERVICE_CODE_ID — Foreign key to CSD_SERVICE_CODES_B identifying the linked service code.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the ORM layer for concurrent update control.
CREATED_BY, CREATION_DATE — Audit columns capturing who created the row and when.
LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Audit columns capturing the last modification user, timestamp, and login session.

The documented unique indexes distinguish keys: CSD_BULLETIN_SCS_U1 enforces uniqueness on BULLETIN_SC_ID, while CSD_BULLETIN_SCS_U2 enforces uniqueness on the (BULLETIN_ID, SERVICE_CODE_ID) pair, which is the true business-key candidate preventing duplicate bulletin-to-service-code mappings.

Common Use Cases and Queries

Typical usage includes reporting which service codes a bulletin covers, finding all bulletins applicable to a given service code, and validating bulletin coverage during repair order creation.

List service codes for a bulletin: SELECT SERVICE_CODE_ID FROM CSD_BULLETIN_SCS WHERE BULLETIN_ID = :bulletin_id;
Find bulletins for a service code: SELECT BULLETIN_ID FROM CSD_BULLETIN_SCS WHERE SERVICE_CODE_ID = :service_code_id;
Join to master tables for descriptive reporting: SELECT b.BULLETIN_NAME, s.SERVICE_CODE FROM CSD_BULLETIN_SCS scs JOIN CSD_BULLETINS_B b ON scs.BULLETIN_ID = b.BULLETIN_ID JOIN CSD_SERVICE_CODES_B s ON scs.SERVICE_CODE_ID = s.SERVICE_CODE_ID;

Related Objects

CSD_BULLETINS_B — Parent bulletin header; joined via BULLETIN_ID.
CSD_SERVICE_CODES_B — Service code master; joined via SERVICE_CODE_ID.
CSD_BULLETIN_SCS_PK1 — Primary key index on BULLETIN_SC_ID.
CSD_BULLETIN_SCS_U1 / U2 — Unique indexes enforcing surrogate and business-key uniqueness.
Related Depot Repair objects such as bulletin applicability, repair order, and estimate tables may reference these links indirectly through CSD_BULLETINS_B.

Table: CSD_BULLETIN_SCS 12.1.1
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETIN_SCS, object_name:CSD_BULLETIN_SCS, status:VALID, product: CSD - Depot Repair , implementation_dba_data: CSD.CSD_BULLETIN_SCS ,
Table: CSD_BULLETIN_SCS 12.2.2
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETIN_SCS, object_name:CSD_BULLETIN_SCS, status:VALID, product: CSD - Depot Repair , description: Bulletin Service Codes table , implementation_dba_data: CSD.CSD_BULLETIN_SCS ,
VIEW: CSD.CSD_BULLETIN_SCS# 12.2.2
owner:CSD, object_type:VIEW, object_name:CSD_BULLETIN_SCS#, status:VALID,
SYNONYM: APPS.CSD_BULLETIN_SCS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:CSD_BULLETIN_SCS, status:VALID,
VIEW: CSD.CSD_BULLETIN_SCS# 12.2.2
SYNONYM: APPS.CSD_BULLETIN_SCS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:CSD_BULLETIN_SCS, status:VALID,
TABLE: CSD.CSD_BULLETIN_SCS 12.1.1
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETIN_SCS, object_name:CSD_BULLETIN_SCS, status:VALID,
Table: CSD_BULLETINS_B 12.1.1
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETINS_B, object_name:CSD_BULLETINS_B, status:VALID, product: CSD - Depot Repair , implementation_dba_data: CSD.CSD_BULLETINS_B ,
Table: CSD_SERVICE_CODES_B 12.2.2
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_SERVICE_CODES_B, object_name:CSD_SERVICE_CODES_B, status:VALID, product: CSD - Depot Repair , description: This table stores all service codes. , implementation_dba_data: CSD.CSD_SERVICE_CODES_B ,
TABLE: CSD.CSD_BULLETIN_SCS 12.2.2
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETIN_SCS, object_name:CSD_BULLETIN_SCS, status:VALID,
Table: CSD_SERVICE_CODES_B 12.1.1
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_SERVICE_CODES_B, object_name:CSD_SERVICE_CODES_B, status:VALID, product: CSD - Depot Repair , description: This table stores all service codes. , implementation_dba_data: CSD.CSD_SERVICE_CODES_B ,
Table: CSD_BULLETINS_B 12.2.2
owner:CSD, object_type:TABLE, fnd_design_data:CSD.CSD_BULLETINS_B, object_name:CSD_BULLETINS_B, status:VALID, product: CSD - Depot Repair , description: Base table for service bulletins , implementation_dba_data: CSD.CSD_BULLETINS_B ,
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.CSD_RO_BULLETINS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CSD_RO_BULLETINS_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 FND Design Data 12.2.2
PACKAGE BODY: APPS.CSD_RO_BULLETINS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CSD_RO_BULLETINS_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.CSD_RO_BULLETINS_PVT SQL Statements 12.2.2
APPS.CSD_RO_BULLETINS_PVT SQL Statements 12.1.1
APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_BULLETIN_SCS 12.1.1
APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_BULLETIN_SCS 12.2.2
APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_BULLETINS_B 12.1.1
APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_BULLETINS_B 12.2.2
eTRM - CSD Tables and Views 12.1.1
description: Transaction table for the High Volume Repair module. ,
eTRM - CSD Tables and Views 12.2.2
description: Transaction table for the High Volume Repair module. ,
PACKAGE BODY: APPS.CSD_RO_BULLETINS_PVT 12.2.2
PACKAGE BODY: APPS.CSD_RO_BULLETINS_PVT 12.1.1
eTRM - CSD Tables and Views 12.1.1
description: Transaction table for the High Volume Repair module. ,
eTRM - CSD Tables and Views 12.2.2
description: Transaction table for the High Volume Repair module. ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1