Results for “xtr_rate_groups_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_RATE_GROUPS_V is a reporting view in the Oracle E-Business Suite Treasury (XTR) module. It presents rate group definitions, which are the configuration records used by Treasury to classify counterparties, branches, and pricing arrangements for interest rate, exchange rate, and wholesale/retail rate determination. The view is defined as a simple projection over the XTR_RATE_GROUPS base table, exposing the rate group identifier along with its descriptive and classification attributes. Because it is a view, it is non-updatable in the conventional sense and is intended for read-only access, reporting, and integration purposes rather than transactional maintenance.
The view plays a supporting role in Treasury reporting and integration. External systems, custom reports, and Oracle BI Publisher or concurrent-program extracts frequently need a stable, denormalized surface for rate group metadata without joining multiple base tables. The metadata notes that the object is "Not implemented in this database," indicating that in the environment where the ETRM documentation was generated, the view was not deployed; nevertheless, the documented definition establishes its canonical structure across Oracle EBS 12.1.1 and 12.2.2.
Underlying Base Objects
The documented view text references a single base object: XTR_RATE_GROUPS. There are no other referenced base objects in the ETRM metadata. The view is therefore a straightforward SELECT that projects the columns RATE_GROUP, GROUP_DESCRIPTION, WHOLESALE_RETAIL_RATE, BRANCH_SUBSIDIARY_CODE, PARTY_CODE, and SHADING_DETAILS directly from XTR_RATE_GROUPS. No joins, aggregations, or filters are applied.
Because the view depends on XTR_RATE_GROUPS, its availability and row population are governed entirely by that table. Any maintenance, purge, or archival activity performed against XTR_RATE_GROUPS is immediately reflected in queries against the view. The metadata does not document an owner, so the view may reside in the APPS schema or in the product schema depending on the installation, and appropriate grants or synonyms must exist for cross-schema access.
Key Columns
- RATE_GROUP — The primary identifier for a rate group. This value is referenced by Treasury rate and interest calculation logic to associate a counterparty or transaction with a pricing group.
- GROUP_DESCRIPTION — The user-facing description of the rate group. This is the column most commonly targeted by searches such as "group_description," since it provides the human-readable label used in reports and list-of-values queries.
- WHOLESALE_RETAIL_RATE — A classification flag indicating whether the rate group applies to wholesale or retail rate treatment, driving which rate source or spread logic is applied.
- BRANCH_SUBSIDIARY_CODE — Identifies the branch or subsidiary context to which the rate group belongs, supporting organizational segmentation of rate definitions.
- PARTY_CODE — Associates the rate group with a specific party or counterparty, enabling counterparty-specific rate configuration.
- SHADING_DETAILS — Holds shading or adjustment details applied to the rate group, typically used for pricing adjustments layered onto a base rate.
Common Use Cases and Queries
Typical usage centers on lookups and reporting. A common pattern is to retrieve the description for a known rate group or to search rate groups by description text:
- Search by description:
SELECT rate_group, group_description FROM xtr_rate_groups_v WHERE UPPER(group_description) LIKE '%' || UPPER(:search_term) || '%'; - Wholesale vs. retail listing:
SELECT rate_group, group_description, wholesale_retail_rate FROM xtr_rate_groups_v WHERE wholesale_retail_rate = :flag; - Counterparty or branch filtering:
SELECT rate_group, group_description, party_code, branch_subsidiary_code FROM xtr_rate_groups_v WHERE party_code = :party_code;
Because the view exposes the complete set of descriptive attributes, it is well suited to value sets, BI Publisher data templates, and interface extracts that need rate group metadata without touching the base table directly.
-
View: XTR_RATE_GROUPS_V 12.1.1
Not implemented in this database·Explore XTR module →
-
View: XTR_RATE_GROUPS_V 12.2.2
Not implemented in this database·Explore XTR module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1