Search Results qp_list_lines_n1

Overview

APPS.CLN_PROCAT_CATITEM_V is a pricing and catalog item view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data as CLN.CLN_PROCAT_CATITEM_V. It is part of the Oracle Advanced Pricing / Contracts (CLN) functional family and consolidates price list line data with item master, customer item, and customer account attributes. The view exposes a denormalized, read-friendly result set that joins pricing structures held in QP_LIST_LINES with inventory item definitions and customer-specific item cross-references, allowing concurrent programs, reports, and integration interfaces to retrieve price list entries for a given item, organization, and customer in a single query.

The view is validated (STATUS: VALID) in Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it carries no independent storage and inherits the security, profile, and MOAC behavior of its underlying base objects.

Underlying Base Objects

The ETRM 12.2.2 metadata documents that CLN_PROCAT_CATITEM_V references the following base objects:

• FND_PROFILE (PACKAGE) — used to resolve profile option values, typically for organization or operating unit context.
• HZ_CUST_ACCOUNTS (SYNONYM) — the Trading Community Architecture customer account, providing PARTY_ID linkage.
• MTL_CUSTOMER_ITEMS and MTL_CUSTOMER_ITEM_XREFS (SYNONYMS) — customer item numbers and cross-references between internal inventory items and customer-defined item numbers.
• MTL_ITEM_REVISIONS (SYNONYM) — item revision data.
• MTL_SYSTEM_ITEMS_B_KFV (VIEW) — the key flexfield descriptive view of the item master, supplying CONCATENATED_SEGMENTS and related item identifiers.
• MTL_SYSTEM_ITEMS_TL (SYNONYM) — translated item descriptions, providing ITEM_DESCRIPTION.
• QP_LIST_LINES (SYNONYM) — the core price list line table holding LIST_HEADER_ID, LIST_LINE_ID, LIST_PRICE, and date ranges.
• QP_PRICING_ATTRIBUTES (SYNONYM) — pricing attribute definitions and qualification data.

Additional dependency entries reference MTL_ITEM_REVISI[ONS], confirming the revision join.

Key Columns

The view exposes pricing identity and value columns (LIST_HEADER_ID, LIST_LINE_ID, LIST_PRICE, LIST_PRICE_UOM_CODE, MINIMUM_ORDER_QUANTITY, PRODUCT_PRECEDENCE, START_DATE_ACTIVE, END_DATE_ACTIVE), item context columns (INVENTORY_ITEM_ID, ORGANIZATION_ID, CONCATENATED_SEGMENTS, PRIMARY_UOM_CODE, REVISION, SERVICE_ITEM_FLAG, ITEM_DESCRIPTION), and customer context columns (PARTY_ID, CUSTOMER_ITEM_NUMBER).

Notably, MAX_WARRANTY_AMOUNT (NUMBER) is the column most directly relevant to users searching for that term. It represents the maximum warranty amount associated with the price list line, supporting warranty pricing and service-contract logic. The view also carries fifteen descriptive flexfield columns (CONTEXT plus ATTRIBUTE1 through ATTRIBUTE15), each VARCHAR2(240), mirroring the DFF structure attached to the underlying pricing entity.

Common Use Cases and Queries

Typical uses include reporting effective price list lines for a given item and customer, validating warranty ceilings via MAX_WARRANTY_AMOUNT, and feeding downstream pricing or order interfaces.

A basic query to isolate warranty-bearing price list entries is:

• SELECT list_header_id, list_line_id, inventory_item_id, organization_id, list_price, max_warranty_amount FROM apps.cln_procat_catitem_v WHERE max_warranty_amount IS NOT NULL;

To retrieve a customer-specific price for a customer item number within an active date window:

• SELECT concatenated_segments, item_description, list_price, primary_uom_code FROM apps.cln_procat_catitem_v WHERE party_id = :p_party_id AND customer_item_number = :p_cust_item AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);

Because the view references FND_PROFILE, queries executed in a multi-org environment should be run within the appropriate operating unit responsibility so that profile-driven organization filtering resolves correctly. Callers should also account for PRODUCT_PRECEDENCE when multiple lines qualify for the same item, since precedence governs which price is applied.