Search Results frequency_code

Overview

CSD_BULLETINS_VL is a translated (VL) view owned by the APPS schema in Oracle E-Business Suite, belonging to the CSD – Depot Repair product. It is defined as a join between the base table CSD_BULLETINS_B and the translation table CSD_BULLETINS_TL, and its purpose is to expose bulletin definitions with language-specific name and description values resolved for the session language. In EBS 12.1.1 and 12.2.2, this view functions as the primary read interface for depot repair bulletins, which are informational or instructional notices attached to repair orders and service activities. The "_VL" suffix indicates that the view filters the translation table using USERENV('LANG'), returning only the row matching the current runtime language. Because Depot Repair responsibility users and concurrent programs routinely need bulletin text in their own language, the view abstracts the underlying _B and _TL tables and presents a single, denormalized row per bulletin. Reporting tools, custom forms, and integration interfaces that must display or extract bulletin metadata are expected to query this view rather than the base tables directly. The view has VALID status and its structure is documented in ETRM for release 12.2.2.

Underlying Base Objects

The view is defined over two referenced base objects, both accessed through synonyms in the APPS schema:

• CSD_BULLETINS_B — the base (non-translated) bulletin table holding all language-independent attributes, including the primary key BULLETIN_ID, bulletin type, validity dates, status flags, workflow attributes, audit columns, and the FREQUENCY_CODE.
• CSD_BULLETINS_TL — the translation table holding NAME and DESCRIPTION per language, joined on BULLETIN_ID and filtered by CSBT.LANGUAGE = USERENV('LANG').

The join condition enforces a one-to-many base-to-translation relationship restricted to the current language, yielding one row per bulletin for the active session language. All columns except NAME and DESCRIPTION, and the ROWID, are sourced from CSD_BULLETINS_B (aliased CSBB). Because the view is a simple join without INSTEAD OF triggers, it is read-only and cannot be used for DML. The ROWID column retained in the SELECT list corresponds to the base table row.

Key Columns

• BULLETIN_ID — primary identifier of the bulletin, inherited from CSD_BULLETINS_B.
• NAME / DESCRIPTION — language-specific text from CSD_BULLETINS_TL.
• BULLETIN_TYPE_CODE — classification of the bulletin.
• FREQUENCY_CODE — the column central to the user's search; defines the recurrence or cadence associated with the bulletin, sourced from CSD_BULLETINS_B.
• ACTIVE_FROM / ACTIVE_TO — effective date range for bulletin validity.
• PUBLISHED_FLAG — indicates whether the bulletin has been published.
• ESCALATION_CODE — escalation behavior linked to the bulletin.
• MANDATORY_FLAG — indicates whether acknowledgment is required.
• WF_ITEM_TYPE / WF_PROCESS_NAME — Oracle Workflow identifiers used when the bulletin triggers a workflow process.
• OBJECT_VERSION_NUMBER — optimistic locking column for the base row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield (DFF) storage columns.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view supports reporting on active bulletins, extracting recurrence rules via FREQUENCY_CODE, and building integration extracts or LOVs that display translated bulletin names. Typical patterns include filtering by the current date against ACTIVE_FROM and ACTIVE_TO, restricting to PUBLISHED_FLAG = 'Y', and joining to depot repair orders or workflows via WF_ITEM_TYPE.

Sample query filtered by the searched column:

SELECT bulletin_id, name, frequency_code, active_from, active_to, published_flag FROM csd_bulletins_vl WHERE frequency_code = :p_frequency_code AND active_from <= SYSDATE AND (active_to IS NULL OR active_to >= SYSDATE);

Query for published, mandatory bulletins in the session language:

SELECT bulletin_id, name, description, escalation_code FROM csd_bulletins_vl WHERE published_flag = 'Y' AND mandatory_flag = 'Y';

Because the view resolves translation automatically, it is the recommended access path for any reported or integrated bulletin data; DML must target CSD_BULLETINS_B and CSD_BULLETINS_TL directly.