Results for “product_desc”

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

Overview

XTR_AUTH_PRODUCT_TYPES_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The object is documented as VALID in the ETRM reference and is classified as a reporting and validation view rather than a transactional entity. Its purpose is to expose the set of authorized product types that may be associated with a given deal type and deal subtype combination. In Treasury workflows, a deal is characterized first by its deal type, then by a subtype, and finally by one or more product types representing the financial instruments or facilities that the deal can process. This view consolidates the product type authorization matrix into a single queryable structure, allowing both application logic and ad hoc reporting to determine which products are permissible for a selected deal classification.

Because the view is read-only and derived entirely from other views, it carries no data of its own. This makes it a low-risk object for integration, since querying it never alters configuration or transactional state. It is commonly used to drive value lists, validate user input, and support reporting on product coverage across the Treasury deal taxonomy.

Underlying Base Objects

The documented definition of XTR_AUTH_PRODUCT_TYPES_V joins two Treasury views:

• XTR_TY_SUB_PRD_COMBIN_V — the view providing the deal type, deal subtype, and product type combination matrix. It is the authoritative source of which product types are authorized for each type/subtype pairing.
• XTR_PRODUCT_TYPES_V — the view supplying product type attributes, including the product description used for display purposes.
• FND_GLOBAL — referenced as a supporting base object, typically used within Treasury security and access logic to establish the effective user and responsibility context during query execution.

The join condition links the two views on DEAL_TYPE and PRODUCT_TYPE, ensuring that only product types both authorized for the combination and present in the product type reference set are returned. The view therefore functions as a filtered, description-enriched projection of the authorization matrix.

Key Columns

• DEAL_TYPE — identifies the high-level classification of the Treasury deal. It is the primary grouping key in the authorization matrix.
• DEAL_SUBTYPE — a further refinement of the deal type, narrowing the applicability of authorized products to a specific deal variant.
• PRODUCT_TYPE — the product type code authorized for the deal type and subtype combination. This is the value typically carried forward into transaction entry and validation logic.
• PRODUCT_DESC — the descriptive name of the product type, sourced from XTR_PRODUCT_TYPES_V, intended for user-facing lists and report layouts.

Common Use Cases and Queries

Typical scenarios include populating a product type list of values after a deal type and subtype have been selected, validating submitted product types during deal capture, and reporting on the breadth of authorized products per deal classification. A representative query restricts output by deal type:

• SELECT deal_type, deal_subtype, product_type, product_desc FROM xtr_auth_product_types_v WHERE deal_type = :p_deal_type ORDER BY deal_subtype, product_type;
• SELECT product_type, product_desc FROM xtr_auth_product_types_v WHERE deal_type = :p_deal_type AND deal_subtype = :p_deal_subtype;
• SELECT deal_type, COUNT(DISTINCT product_type) FROM xtr_auth_product_types_v GROUP BY deal_type;

Because the view is defined over other views, no direct DML is permitted; it is intended strictly for query and validation purposes within the Treasury module and for supplemental reporting.