Search Results cln_procat_price_lists_v




Overview
Explore in AI Chat

Overview

The CLN_PROCAT_PRICE_LISTS_V view is an Oracle E-Business Suite database object owned by the APPS schema in the CLN – Supply Chain Trading Connector for RosettaNet product module. It exposes the set of price lists available to the trading connector, attributing each price list to a specific customer account where such an assignment exists. The view is most relevant to EBS releases 12.1.1 and 12.2.2, where RosettaNet Partner Interface Process (PIP) messaging relies on accurate, customer-scoped pricing information retrieved from the Oracle Advanced Pricing (QP) data model.

The view is not a transactional interface; it is a read-only reporting and integration construct. It presents price list names and identifiers alongside the customer party to which a list is assigned, and it carries an ASSIGNED_FLAG column that distinguishes price lists directly linked to a customer qualifier from those that are not. Because the ASSIGNED_FLAG is a literal value generated within the view definition rather than stored data, it must be interpreted as a query-level classification rather than a persistent attribute of the price list record.

Underlying Base Objects

CLN_PROCAT_PRICE_LISTS_V is defined over the following documented base objects:

The view text is a UNION of two branches. The first branch joins the header tables to the qualifier view and customer accounts, producing rows with a real PARTY_ID and an ASSIGNED_FLAG of 'Y'. The second branch returns price lists without a customer assignment, producing a PARTY_ID of -1 and an ASSIGNED_FLAG of 'N'. Both branches apply the same QP security logic, honoring QP_SECURITY_CONTROL and the current ORG_ID.

Key Columns

  • NAME – the translated price list name from QP_LIST_HEADERS_TL.
  • LIST_HEADER_ID – the primary identifier of the price list header, used to join to other QP objects.
  • PARTY_ID – the customer party identifier associated with the qualifier, or -1 when the list is unassigned.
  • ASSIGNED_FLAG – 'Y' when a customer qualifier exists for the list, 'N' otherwise. This is the column most frequently searched by users investigating assignment status.

Common Use Cases and Queries

A frequent requirement is to enumerate which price lists are assigned to customers and which are unassigned. The following query lists assigned lists only:

SELECT name, list_header_id, party_id
FROM   cln_procat_price_lists_v
WHERE  assigned_flag = 'Y';

To identify unassigned price lists available for customer attachment:

SELECT name, list_header_id
FROM   cln_procat_price_lists_v
WHERE  assigned_flag = 'N';

To inspect a single price list across all of its customer assignments:

SELECT name, party_id, assigned_flag
FROM   cln_procat_price_lists_v
WHERE  list_header_id = :p_list_header_id;

These queries respect the QP_SECURITY_CONTROL and ORG_ID profile settings, so results vary with the responsibility and operating unit context under which they are executed.