Search Results parameter_value_code

Overview

XTR_COMPANY_PARAMETERS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It exposes company-level Treasury parameters—configuration values that control processing behavior for a given Treasury entity or company code. The view presents a clean, reporting-friendly projection of the XTR_COMPANY_PARAMETERS base table, carrying both surrogate identifier columns and descriptive parameter attributes. Typical Treasury parameters govern items such as settlement handling, interest calculation conventions, deal numbering, and default accounting options.

Because it is a simple view over the base table with no complex joins or aggregations, it is used primarily for reporting, integration extracts, and diagnostics. Users such as Treasury administrators and developers query it to verify that the correct parameters are set per company before running exposure, settlement, or accounting processes. The COMPANY_PARAMETER_ID column is the primary retrieval key, and it is the identifier most frequently used to link parameter records to related Treasury setup data.

Underlying Base Objects

The view is defined over a single documented base object: the XTR_COMPANY_PARAMETERS table, referenced through a SYNONYM in the APPS schema. No additional tables are joined. The view text is a direct column projection:

• Source table: XTR_COMPANY_PARAMETERS (aliased XCP)
• All ten columns are carried through unchanged; no filters, functions, or joins are applied.
• The view inherits the DML and concurrency characteristics of the base table, including standard WHO audit columns.

The one-to-one mapping means any row present in the view corresponds to exactly one row in XTR_COMPANY_PARAMETERS. This makes the view suitable for read-only reporting and integration, though direct DML against the view is not the normal practice—parameter maintenance is performed through the Treasury setup forms or APIs against the base table.

Key Columns

• COMPANY_PARAMETER_ID — Unique surrogate identifier for each parameter row; the primary key and the most common search predicate.
• COMPANY_CODE — Identifies the Treasury company or entity to which the parameter applies; parameters are scoped by company.
• PARAMETER_CODE — The name of the configuration parameter, determining which behavior is being controlled.
• PARAMETER_VALUE_CODE — The coded or lookup value assigned to the parameter where the parameter is defined against a value set.
• PARAMETER_VALUE — The plain or free-form value stored for the parameter, used where the setting is not a coded lookup.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO audit columns recording insert and last-update context.

Common Use Cases and Queries

The view is most often queried to inspect or extract company parameter settings, particularly during setup validation, troubleshooting, and migration between instances. A representative retrieval by identifier is:

• SELECT company_parameter_id, company_code, parameter_code, parameter_value_code, parameter_value FROM xtr_company_parameters_v WHERE company_parameter_id = :p_id;
• SELECT parameter_code, parameter_value_code, parameter_value FROM xtr_company_parameters_v WHERE company_code = :p_company ORDER BY parameter_code; — lists all parameters for one company.
• SELECT company_parameter_id, company_code, parameter_code, last_updated_by, last_update_date FROM xtr_company_parameters_v ORDER BY last_update_date DESC; — audits recently changed parameters.

Because the view applies no joins, these queries are lightweight and safe for ad hoc use, BI Publisher data models, and outbound interface extracts. The view supports the standard Oracle EBS multi-org and security model indirectly through the company code values it returns rather than through organization-based row filtering.