Search Results ams_price_list_attributes




Overview
Explore in AI Chat

Overview

The AMS_PRICE_LIST_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically designed for versions 12.1.1 and 12.2.2. It functions as a surrogate table, extending the standard pricing entity QP_LIST_HEADERS_B from the Order Management foundation. Its primary role is to capture marketing-specific attributes, statuses, and ownership details for price lists that are not natively stored in the base pricing tables. This enables the Marketing Online functionality to manage and govern price lists with module-specific business rules and lifecycle states, effectively bridging enterprise pricing data with specialized marketing campaign and promotion requirements.

Key Information Stored

The table's structure is centered around linking to a core price list and enriching it with AMS-specific metadata. The most critical column is QP_LIST_HEADER_ID, which serves as the foreign key to the base price list in QP_LIST_HEADERS_B, establishing the fundamental relationship. The primary key is PRICE_LIST_ATTRIBUTE_ID. Other significant columns include USER_STATUS_ID, which links to AMS_USER_STATUSES_B to track the marketing-specific lifecycle status (e.g., Draft, Active, Inactive) of the price list. The OWNER_ID column references JTF_RS_RESOURCE_EXTNS to designate the marketing resource responsible for the list. Finally, the CUSTOM_SETUP_ID can link to AMS_CUSTOM_SETUPS_B, potentially allowing for customized configurations or setups associated with the price list.

Common Use Cases and Queries

This table is essential for reporting and administrative processes within the Marketing module. A common use case is generating a report of all price lists available for marketing campaigns, including their current status and owner. Another scenario involves validating price list availability before launching a promotion. Sample SQL to retrieve key marketing attributes for a price list would join the surrogate table with its referenced entities:

  • SELECT apa.PRICE_LIST_ATTRIBUTE_ID, qlh.NAME, aus.NAME STATUS, res.RESOURCE_NAME OWNER FROM AMS_PRICE_LIST_ATTRIBUTES apa, QP_LIST_HEADERS_B qlh, AMS_USER_STATUSES_B aus, JTF_RS_RESOURCE_EXTNS res WHERE apa.QP_LIST_HEADER_ID = qlh.LIST_HEADER_ID AND apa.USER_STATUS_ID = aus.USER_STATUS_ID(+) AND apa.OWNER_ID = res.RESOURCE_ID(+);

Data maintenance tasks, such as bulk updating the status of price lists or reassigning ownership, would also be performed via this table.

Related Objects

AMS_PRICE_LIST_ATTRIBUTES sits at the intersection of Marketing, Pricing, and Resource Management. Its documented foreign key relationships are critical for data integrity and reporting:

  • QP_LIST_HEADERS_B: The foundational price list (join column: QP_LIST_HEADER_ID).
  • JTF_RS_RESOURCE_EXTNS: The marketing resource or owner of the price list (join column: OWNER_ID).
  • AMS_USER_STATUSES_B: The marketing-specific status (join column: USER_STATUS_ID).
  • AMS_CUSTOM_SETUPS_B: Associated custom setup definitions (join column: CUSTOM_SETUP_ID).

The table's primary key (PRICE_LIST_ATTRIBUTE_ID) is referenced by other AMS entities, though specific child tables are not detailed in the provided metadata. It is a key dependency for any Marketing functionality that leverages enriched price list data.