Results for “security_value”

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

Overview

XTR_LOAN_SECURITIES_V is a reporting view owned by the APPS schema within the XTR (Treasury) product family of Oracle E-Business Suite, validated on both 12.1.1 and 12.2.2. It exposes loan collateral security records maintained by the Treasury module, presenting attributes such as the counterparty, the security identifier and description, its assessed value, the valuation authority, the valuation date, aggregate priority ranking, company designation, and the issuing party. Because it is a view rather than a table, it provides a stable, read-oriented projection of loan security data suitable for inquiry screens, concurrent reports, and downstream integration extracts without exposing the full physical structure of the underlying storage table.

The view is not registered in the ETRM metadata as a multi-table join; it is a straightforward column projection, which means its performance characteristics mirror those of the base object and no aggregation or filtering logic is applied at the view layer. Users searching on the term "issued_by" will find that column exposed directly, allowing identification of the institution or entity that issued the security pledged against a loan or collateral arrangement.

Underlying Base Objects

The documented base object referenced by XTR_LOAN_SECURITIES_V is XTR_LOAN_SECURITIES, a synonym in the APPS schema. The view text is a direct SELECT of a defined column set from that source with no WHERE clause, no DISTINCT, and no joins, meaning every row present in XTR_LOAN_SECURITIES is surfaced through the view.

• Owner/schema: APPS
• Referenced base object: XTR_LOAN_SECURITIES (SYNONYM)
• Projected columns: CPARTY_CODE, SECURITY_NUMBER, SECURITY_DESCRIPTION, SECURITY_REF, SECURITY_VALUE, VALUER, VALUATION_DATE, PRIORITY_SUM, COMPANY_CODE, ISSUED_BY

Because the view performs no transformation, data integrity, cardinality, and referential behavior are entirely determined by the base table. Any change to the base table structure requires the view definition to be reviewed for column-level compatibility.

Key Columns

• CPARTY_CODE — Counterparty code identifying the party associated with the loan or collateral relationship.
• SECURITY_NUMBER — Unique identifier for the security pledged or recorded.
• SECURITY_DESCRIPTION — Free-text description of the security instrument.
• SECURITY_REF — External or internal reference used to cross-reference the security.
• SECURITY_VALUE — Monetary value assessed for the security.
• VALUER — Party or resource responsible for producing the valuation.
• VALUATION_DATE — Date on which the valuation was performed; useful for aging and revaluation reporting.
• PRIORITY_SUM — Aggregated priority figure across the security's ranking entries.
• COMPANY_CODE — Legal entity or company designation owning the record.
• ISSUED_BY — The issuer of the security, i.e., the institution or entity that issued the instrument recorded on the line.

Common Use Cases and Queries

Typical scenarios include listing all securities issued by a given institution, reporting collateral valuations by counterparty, reconciling company-level exposure, and extracting data for external risk systems. The following queries illustrate common access patterns.

• Securities issued by a specific institution: SELECT cparty_code, security_number, security_value, valuation_date FROM xtr_loan_securities_v WHERE issued_by = :issuer;
• Valuations by counterparty and company: SELECT company_code, cparty_code, security_number, security_value, valuer FROM xtr_loan_securities_v WHERE valuation_date >= :from_date ORDER BY cparty_code;
• Priority ranking review: SELECT security_number, issued_by, priority_sum, security_value FROM xtr_loan_securities_v ORDER BY priority_sum DESC;

Because the view is a direct projection, filters on ISSUED_BY, CPARTY_CODE, and COMPANY_CODE are passed to the base object and benefit from any indexing defined on XTR_LOAN_SECURITIES.