Search Results icx_por_price_list_lines




Overview
Explore in AI Chat

Overview

The ICX_POR_PRICE_LIST_LINES table is a core data repository within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detailed line-level storage for price list information. Each record in this table represents a specific item's pricing terms as defined within a broader price list header. Its primary role is to support the requisitioning process by providing the system with the necessary data to determine accurate item costs, validate supplier agreements, and enforce procurement policies during the creation of shopping cart lines. The integrity of this data is critical for cost control and spend analysis within the procurement lifecycle.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships explicitly reveal the table's critical data dimensions. The essential columns include a HEADER_ID, which links the line to its parent price list in ICX_POR_PRICE_LISTS, and an ITEM_ID, which associates the price with a specific catalog item from ICX_POR_ITEMS. The table stores supplier and buyer context via SUPPLIER_ID and BUYER_ID, both referencing the HZ_PARTIES table (Trading Community Architecture). This allows for pricing that can be specific to a supplier, a buying organization, or both. The CURRENCY_CODE column, linked to FND_CURRENCIES, defines the transactional currency for the price. Other typical columns, inferred from its purpose, would include UNIT_PRICE, effective dates (START_DATE_ACTIVE, END_DATE_ACTIVE), and possibly attributes for minimum/maximum order quantities or price breaks.

Common Use Cases and Queries

A primary use case is the real-time price lookup during requisition entry. When a user selects an item and supplier, iProcurement queries this table to retrieve the valid, active unit price. This table is also central for generating procurement reports on supplier pricing compliance, item cost history, and spend by price list. Common analytical queries involve joining to related tables to produce meaningful reports.

Sample Query: Find Active Prices for a Supplier
SELECT pll.item_id, pll.unit_price, pll.currency_code
FROM icx_por_price_list_lines pll
JOIN icx_por_price_lists pl ON pll.header_id = pl.header_id
WHERE pll.supplier_id = 12345
AND SYSDATE BETWEEN pll.start_date_active AND NVL(pll.end_date_active, SYSDATE)
AND pl.status = 'APPROVED';

Related Objects

The table maintains defined foreign key relationships with several key EBS entities, as per the provided metadata:

  • ICX_POR_PRICE_LISTS: Joined via ICX_POR_PRICE_LIST_LINES.HEADER_ID. This is the parent header defining the overall price list agreement.
  • ICX_POR_ITEMS: Joined via ICX_POR_PRICE_LIST_LINES.ITEM_ID. This provides the catalog item details (description, category, UOM).
  • HZ_PARTIES (Supplier): Joined via ICX_POR_PRICE_LIST_LINES.SUPPLIER_ID. Identifies the supplier party.
  • HZ_PARTIES (Buyer): Joined via ICX_POR_PRICE_LIST_LINES.BUYER_ID. Identifies the buying organization party.
  • FND_CURRENCIES: Joined via ICX_POR_PRICE_LIST_LINES.CURRENCY_CODE. Provides currency name and precision.
  • Table: ICX_POR_PRICE_LIST_LINES 12.1.1

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_PRICE_LIST_LINES,  object_name:ICX_POR_PRICE_LIST_LINES,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores price list lines information. ,  implementation_dba_data: ICX.ICX_POR_PRICE_LIST_LINES , 

  • Table: ICX_POR_PRICE_LIST_LINES 12.2.2

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_PRICE_LIST_LINES,  object_name:ICX_POR_PRICE_LIST_LINES,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores price list lines information. ,  implementation_dba_data: ICX.ICX_POR_PRICE_LIST_LINES , 

  • Table: ICX_POR_PRICE_LISTS 12.1.1

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_PRICE_LISTS,  object_name:ICX_POR_PRICE_LISTS,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores price lists information. There is 1 price list per buyer/supplier combination. ,  implementation_dba_data: ICX.ICX_POR_PRICE_LISTS , 

  • Table: ICX_POR_PRICE_LISTS 12.2.2

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_PRICE_LISTS,  object_name:ICX_POR_PRICE_LISTS,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores price lists information. There is 1 price list per buyer/supplier combination. ,  implementation_dba_data: ICX.ICX_POR_PRICE_LISTS , 

  • Table: ICX_POR_ITEMS 12.1.1

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_ITEMS,  object_name:ICX_POR_ITEMS,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may b ,  implementation_dba_data: ICX.ICX_POR_ITEMS , 

  • Table: ICX_POR_ITEMS 12.2.2

    owner:ICX,  object_type:TABLE,  fnd_design_data:ICX.ICX_POR_ITEMS,  object_name:ICX_POR_ITEMS,  status:VALID,  product: ICX - Oracle iProcurement ,  description: Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may b ,  implementation_dba_data: ICX.ICX_POR_ITEMS ,