Search Results cs_transaction_types_b

Overview

The CS_TRANSACTION_TYPES_B table is a core master data table within the Oracle E-Business Suite Service (CS) module. It serves as the definitive repository for all transaction types, which are critical business rules governing the processing of service charges. These types can be either Oracle-seeded or user-defined, providing a flexible framework for categorizing service activities such as installations, returns, or warranty claims. The table's primary role is to define the behavioral and processing logic for service transactions, acting as a key control point for downstream workflows, billing determinations, and inventory status updates within the service lifecycle.

Key Information Stored

While the provided metadata does not list specific columns, the primary key and foreign key relationships indicate the nature of the critical data. The central column is TRANSACTION_TYPE_ID, the unique identifier for each transaction type record. The table stores descriptive attributes for each type, which typically include a name, description, and active status. Crucially, it holds configuration columns that link to other control data, notably INSTALLED_CP_STATUS_ID and NEW_CP_STATUS_ID. These foreign keys reference the CS_CUSTOMER_PRODUCT_STATUSES table, defining the starting and ending inventory statuses for a customer product (e.g., from "In Service" to "Returned") when a transaction of this type is processed. This mechanism is fundamental for tracking asset lifecycle changes.

Common Use Cases and Queries

This table is central to reporting, configuration, and transactional integrity. Common use cases include generating lists of active transaction types for setup or data entry forms, validating transaction rules during service order entry, and analyzing service activity by type. A frequent reporting requirement is to join transaction types with their corresponding customer product statuses to understand state transitions. A typical query pattern is:

• SELECT ttb.transaction_type_id, ttb.name, ttb.description, cps_inst.status_code AS installed_status, cps_new.status_code AS new_status FROM cs_transaction_types_b ttb LEFT JOIN cs_customer_product_statuses cps_inst ON ttb.installed_cp_status_id = cps_inst.customer_product_status_id LEFT JOIN cs_customer_product_statuses cps_new ON ttb.new_cp_status_id = cps_new.customer_product_status_id WHERE ttb.enabled_flag = 'Y';

This query retrieves active transaction types along with the inventory status codes they apply, which is essential for process analysis and audit.

Related Objects

CS_TRANSACTION_TYPES_B is a pivotal table with documented relationships to several other key service entities. It references the CS_CUSTOMER_PRODUCT_STATUSES table twice via foreign keys on the INSTALLED_CP_STATUS_ID and NEW_CP_STATUS_ID columns to manage product status flows. More significantly, its primary key (TRANSACTION_TYPE_ID) is referenced as a foreign key by multiple transactional and control tables, enforcing referential integrity across the module. These dependent objects include:

• CS_BUS_PROCESS_TXNS: Links business processes to allowed transaction types (join on TRANSACTION_TYPE_ID).
• CS_LINE_INST_DETAILS: Associates individual service line installation details with a transaction type (join on TRANSACTION_TYPE_ID).
• CS_TXN_BILLING_TYPES: Defines the billing rules (e.g., billable, non-billable, warranty) applicable to each transaction type (join on TRANSACTION_TYPE_ID).

These relationships underscore the table's role as a central hub for configuring service transaction behavior, impacting billing, asset tracking, and process execution.