Results for “ozf_price_list_attributes”

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

Overview

OZF_PRICE_LIST_ATTRIBUTES is a Trade Management (OZF) table that functions as a surrogate extension to QP_LIST_HEADERS_B, the core Oracle Advanced Pricing table that stores price list headers. While QP_LIST_HEADERS_B holds the fundamental pricing list definitions shared across Oracle Pricing, Order Management, and other modules, it does not natively capture the Trade Management-specific attributes required by promotions, offers, and trade planning processes. OZF_PRICE_LIST_ATTRIBUTES fills this gap by storing status, ownership, workflow, and custom setup information tied to a given price list header.

The table is owned by the OZF schema and is classified as VALID in the ETRM repository. Its primary key is OZF_PRICE_LIST_ATTRIBUTES_PK, defined on the PRICE_LIST_ATTRIBUTE_ID column. Two unique indexes are documented: OZF_PRICE_LIST_ATTRIBUTES_U1 on PRICE_LIST_ATTRIBUTE_ID and OZF_PRICE_LIST_ATTRIBUTES_U2 on QP_LIST_HEADER_ID. The presence of U2 confirms a one-to-one relationship between a price list header and its Trade Management attribute record. Under the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link — it connects a price list header (QP_LIST_HEADERS_B) to Trade Management entities such as resources, offers, statuses, and custom setups, rather than acting as an independent hub or a descriptive satellite.

Key Information Stored

The table contains 15 documented columns. The most significant include:

• PRICE_LIST_ATTRIBUTE_ID — the surrogate primary key and the column behind unique index U1.
• QP_LIST_HEADER_ID — the foreign key to QP_LIST_HEADERS_B and the business-key candidate behind unique index U2, linking the attribute row to its parent price list.
• OWNER_ID — the resource identifier referencing JTF_RS_RESOURCE_EXTNS, identifying the Trade Management owner (typically a sales representative or resource) of the price list.
• CUSTOM_SETUP_ID — referencing AMS_CUSTOM_SETUPS_B, capturing the custom setup configuration applied to the price list.
• USER_STATUS_ID — referencing AMS_USER_STATUSES_B, the user-defined status assigned to the price list within Trade Management.
• STATUS_CODE and STATUS_DATE — the coded status value and the timestamp of the last status transition.
• SECURITY_GROUP_ID — referencing FND_SECURITY_GROUPS, supporting multi-org and security-group partitioning.
• WF_ITEM_KEY — the Oracle Workflow item key associated with the record, enabling workflow-driven approval or lifecycle processing.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Applications framework.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard WHO audit tracking.

The surrogate key (PRICE_LIST_ATTRIBUTE_ID) is distinct from the business keys (QP_LIST_HEADER_ID), which uniquely identifies the parent price list and enforces the one-to-one linkage.

Common Use Cases and Queries

Typical scenarios include reporting on the owner, status, and workflow state of Trade Management price lists, and joining these attributes to pricing data for promotional analysis or territory-based reporting.

A representative query joining the parent price list to its attributes:

• SELECT pla.qp_list_header_id, pla.status_code, pla.status_date, pla.owner_id, pla.wf_item_key FROM ozf.ozf_price_list_attributes pla WHERE pla.qp_list_header_id = :list_header_id;

A second pattern resolves the owning resource and user status for reporting:

• SELECT pla.qp_list_header_id, r.resource_name, us.user_status_name FROM ozf.ozf_price_list_attributes pla, jtf_rs_resource_extns r, ams_user_statuses_b us WHERE pla.owner_id = r.resource_id AND pla.user_status_id = us.user_status_id;

Because U2 enforces uniqueness on QP_LIST_HEADER_ID, queries can safely treat the join between QP_LIST_HEADERS_B and this table as one-to-one, simplifying reporting logic and avoiding row duplication.

Related Objects

The most significant related objects, based on documented foreign key relationships, include:

• QP_LIST_HEADERS_B — the parent pricing table; joined via QP_LIST_HEADER_ID (the FK is documented here as pointing to OZF_OFFERS in the mined relationship data, reflecting the Trade Management offer linkage).
• JTF_RS_RESOURCE_EXTNS — referenced through OWNER_ID, resolving the price list owner.
• AMS_CUSTOM_SETUPS_B — referenced through CUSTOM_SETUP_ID, providing custom setup context.
• AMS_USER_STATUSES_B — referenced through USER_STATUS_ID, supplying user-defined status values.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, supporting security partitioning.
• OZF_OFFERS — linked via QP_LIST_HEADER_ID as documented in the relationship data, tying price lists to Trade Management offers and promotions.

Together these objects establish OZF_PRICE_LIST_ATTRIBUTES as the connective layer between Oracle Advanced Pricing price lists and the Trade Management ecosystem.