Search Results xtr_deal_subtypes




Overview
Explore in AI Chat

Overview

The XTR_DEAL_SUBTYPES table is a core reference data object within the Oracle E-Business Suite Treasury (XTR) module. It functions as a master repository for defining and maintaining the specific classifications or categories of financial transactions, known as deal subtypes, that are permissible within the system. Each subtype is intrinsically linked to a broader deal type, creating a hierarchical structure for transaction categorization. This table is fundamental to the configuration and validation of treasury deals, ensuring that all entered transactions conform to predefined business rules and classifications established by the organization. Its role is critical for maintaining data integrity and enabling precise reporting and processing across the treasury management lifecycle.

Key Information Stored

While the provided metadata does not list individual columns beyond the key fields, the structure and relationships indicate the core data elements. The table's primary key is a composite of DEAL_TYPE and DEAL_SUBTYPE, which are its most critical columns. The DEAL_TYPE column stores the high-level classification of a treasury transaction (e.g., Foreign Exchange, Money Market), and the DEAL_SUBTYPE column stores the more granular classification within that type (e.g., Spot, Forward, Swap). The table likely contains additional descriptive columns, such as a name or description for the subtype, and potentially flags controlling its status (e.g., active/inactive) and specific behavioral attributes relevant to the XTR application's logic for processing deals of that particular subtype.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting. During implementation, it is populated with the organization's specific deal taxonomy. At runtime, the application validates every new deal entry against this table. Common analytical queries involve listing all available subtypes for a given deal type or identifying which subtypes are in use. A typical reporting query might join this table to the transaction table to generate subtype-level summaries.

  • Validation Query: SELECT 'VALID' FROM XTR_DEAL_SUBTYPES WHERE DEAL_TYPE = :p_deal_type AND DEAL_SUBTYPE = :p_deal_subtype;
  • Setup Listing: SELECT DEAL_TYPE, DEAL_SUBTYPE FROM XTR_DEAL_SUBTYPES ORDER BY DEAL_TYPE, DEAL_SUBTYPE;
  • Reporting Join: SELECT ds.DEAL_TYPE, ds.DEAL_SUBTYPE, COUNT(d.DEAL_NUMBER) FROM XTR_DEALS d, XTR_DEAL_SUBTYPES ds WHERE d.DEAL_TYPE = ds.DEAL_TYPE AND d.DEAL_SUBTYPE = ds.DEAL_SUBTYPE GROUP BY ds.DEAL_TYPE, ds.DEAL_SUBTYPE;

Related Objects

The XTR_DEAL_SUBTYPES table maintains defined foreign key relationships with several other key tables in the XTR schema, as documented in the metadata. These relationships enforce referential integrity and define its central position in the data model.

  • XTR_DEAL_TYPES: The DEAL_TYPE column in XTR_DEAL_SUBTYPES references the XTR_DEAL_TYPES table, establishing that every subtype must belong to a valid, pre-defined parent deal type.
  • XTR_DEALS: The primary transaction table references XTR_DEAL_SUBTYPES via its DEAL_TYPE and DEAL_SUBTYPE columns. This ensures every deal recorded in the system uses a valid and configured subtype combination.
  • XTR_FX_PERIOD_WEIGHTINGS: References this table on DEAL_TYPE and DEAL_SUBTYPE, likely to store FX-specific calculation rules or parameters that vary by deal subtype.
  • XTR_TIME_RESTRICTIONS: References this table on DEAL_TYPE and DEAL_SUBTYPE, indicating that trading or processing time restrictions can be configured at the granular deal subtype level.