Search Results ozf_price_list_attributes




Overview
Explore in AI Chat

Overview

The OZF_PRICE_LIST_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It functions as a surrogate table, extending the capabilities of the base pricing entity QP_LIST_HEADERS_B from the Order Management pricing engine. Its primary role is to capture Trade Management-specific attributes and statuses for price lists, which are not natively stored in the standard pricing tables. This table enables the Trade Management application to manage price lists with its own business rules, ownership models, and lifecycle states, effectively bridging generic pricing functionality with specialized trade promotion and fund management processes.

Key Information Stored

The table's structure is centered around linking to a price list and enriching it with module-specific metadata. The primary key, PRICE_LIST_ATTRIBUTE_ID, uniquely identifies each record. The most critical foreign key is QP_LIST_HEADER_ID, which ties each record to a specific price list header in QP_LIST_HEADERS_B. Other significant columns include OWNER_ID, which links to the JTF_RS_RESOURCE_EXTNS table to designate the resource responsible for the price list within Trade Management. The USER_STATUS_ID column references AMS_USER_STATUSES_B to track the application-specific status (e.g., Draft, Approved, Inactive) of the price list. Finally, the CUSTOM_SETUP_ID can link to AMS_CUSTOM_SETUPS_B, potentially allowing for customized configurations or setups to be associated with the price list.

Common Use Cases and Queries

A primary use case is retrieving the full context of a price list active within Trade Management, including its owner and current status. This is essential for operational reports and UI displays. Development and support tasks often involve diagnosing data integrity issues by checking for orphaned records or validating status transitions. A typical query would join this table to the pricing and resource tables to generate a management report.

  • Sample Query: Price List Summary
    SELECT plb.name price_list_name, pla.qp_list_header_id, res.resource_name owner, us.status_name user_status FROM ozf_price_list_attributes pla, qp_list_headers_b plb, jtf_rs_resource_extns res, ams_user_statuses_b us WHERE pla.qp_list_header_id = plb.list_header_id AND pla.owner_id = res.resource_id(+) AND pla.user_status_id = us.user_status_id(+);
  • Data Validation: Identifying price lists in QP that lack a corresponding Trade Management attribute record, or vice versa, is a common support activity to ensure synchronization between the two systems.

Related Objects

OZF_PRICE_LIST_ATTRIBUTES sits at an integration point between several key EBS modules. Its documented foreign key relationships are as follows:

  • QP_LIST_HEADERS_B (via OZF_OFFERS): The core link to the pricing engine. The column OZF_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID references OZF_OFFERS, which in turn references QP_LIST_HEADERS_B, establishing the connection to the base price list.
  • JTF_RS_RESOURCE_EXTNS: Provides owner information. Joined via OZF_PRICE_LIST_ATTRIBUTES.OWNER_ID.
  • AMS_USER_STATUSES_B: Provides the status code and meaning for the price list within Trade Management. Joined via OZF_PRICE_LIST_ATTRIBUTES.USER_STATUS_ID.
  • AMS_CUSTOM_SETUPS_B: Allows association with custom setup configurations. Joined via OZF_PRICE_LIST_ATTRIBUTES.CUSTOM_SETUP_ID.

These relationships highlight its role in augmenting a standard price list with Trade Management's resource, status, and setup models.