Results for “orderby_clause”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSF_DC_QUERIES_B is a core configuration table in the Oracle E-Business Suite Field Service (CSF) module. It stores the WHERE-clause and ORDER BY-clause definitions that drive the queries used to populate the Dispatch Center with service tasks. In Oracle EBS 12.1.1 and 12.2.2, the Dispatch Center is the primary scheduling workbench used by dispatchers to view, assign, and manage field service tasks, and the query definitions held in this table effectively determine which tasks appear in the Dispatch Center view for a given user or role.

The table resides in the CSF schema and is classified, under the heuristic Data Vault modeling derived from its foreign key structure, as a standalone object with no dependent hub or link relationships. This classification suggests the table functions as an independent configuration or reference entity rather than a transactional or associative entity within the field service data model.

Key Information Stored

CSF_DC_QUERIES_B holds 15 documented columns. The most significant are:

• QUERY_ID — the surrogate primary key, defined by the CSF_DC_QUERIES_PK constraint. This uniquely identifies each Dispatch Center query definition.
• WHERE_CLAUSE — the SQL predicate that filters which tasks are retrieved for the Dispatch Center. This is the functional heart of the table.
• ORDERBY_CLAUSE — the sort specification applied to the retrieved task set.
• USER_ID — associates a query definition with a specific application user, allowing personalized Dispatch Center views.
• SEEDED_FLAG — indicates whether the row is a seeded (Oracle-provided) query or a customer-defined query.
• START_DATE_ACTIVE and END_DATE_ACTIVE — define the effective date range during which the query is active.
• SECURITY_GROUP_ID — a foreign key referencing FND_SECURITY_GROUPS, controlling which security group can access the query.
• OBJECT_VERSION_NUMBER — supports optimistic locking during concurrent updates.
• ZD_EDITION_NAME — participates in the unique index CSF_DC_QUERIES_U1 (QUERY_ID, ZD_EDITION_NAME), supporting edition-based redefinition in 12.2.x.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

The business-key candidate is the composite unique index CSF_DC_QUERIES_U1 on QUERY_ID and ZD_EDITION_NAME, distinguishing the editioned rows from the surrogate primary key alone.

Common Use Cases and Queries

Administrators and developers query this table to audit, troubleshoot, or replicate Dispatch Center task filters. A typical retrieval of active, user-specific queries is:

• SELECT query_id, where_clause, orderby_clause FROM csf.csf_dc_queries_b WHERE user_id = :p_user AND seeded_flag = 'N' AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Reporting on which queries are seeded versus custom-defined, to assess configuration drift after patching or upgrade.
• Reviewing WHERE_CLAUSE contents to diagnose why certain tasks appear or fail to appear in a dispatcher's Dispatch Center view.
• Validating SECURITY_GROUP_ID assignments against FND_SECURITY_GROUPS to confirm cross-group visibility controls.

Related Objects

• FND_SECURITY_GROUPS — referenced via CSF_DC_QUERIES_B.SECURITY_GROUP_ID, governing row-level access.
• CSF_DC_QUERIES_TL — the translation table that stores language-specific query names and descriptions keyed by QUERY_ID.
• CSF_DC_QUERIES_PK — the primary key constraint enforcing uniqueness on QUERY_ID.
• CSF_DC_QUERIES_U1 — the unique index on (QUERY_ID, ZD_EDITION_NAME).
• CSF_DEBRIEF_QUERIES / Dispatch Center concurrent programs — consume the WHERE_CLAUSE and ORDERBY_CLAUSE values at runtime to build the task list.
• FND_USER — referenced conceptually through USER_ID to resolve dispatcher identities.

Because the table is classified as standalone, its integrity depends primarily on its own primary key and the FND_SECURITY_GROUPS foreign key rather than on broader hub-and-link dependencies.