Search Results icx_shopping_cart_lines

Overview

The ICX_SHOPPING_CART_LINES table is a core data object within Oracle E-Business Suite 12.1.1 and 12.2.2, specifically for the iProcurement module (ICX). It functions as the primary transactional repository for individual line items within a web-based shopping cart or requisition. Each record in this table represents a single line item that a user has added to a requisition, capturing all product, quantity, pricing, and sourcing details before the requisition is submitted for approval and converted into a purchase order line. Its role is central to the iProcurement self-service purchasing process, persisting the user's shopping session data.

Key Information Stored

The table stores detailed attributes for each requisition line. While the full column list is extensive, key columns inferred from the metadata and standard iProcurement functionality include: CART_LINE_ID (the primary key), CART_ID (linking to the header in ICX_SHOPPING_CARTS), ITEM_ID and DESTINATION_ORGANIZATION_ID (linking to the catalog item in MTL_SYSTEM_ITEMS_B), DELIVER_TO_LOCATION_ID (linking to HR_LOCATIONS_ALL), and quantity and unit of measure. Critical sourcing columns like AUTOSOURCE_DOC_HEADER_ID and AUTOSOURCE_DOC_LINE_NUM create a foreign key relationship to PO_LINES_ALL, indicating if the line was auto-sourced from an existing blanket or contract purchase agreement.

Common Use Cases and Queries

This table is frequently queried for troubleshooting, reporting, and data fixes. Common scenarios include analyzing requisition content before submission, identifying lines sourced from specific contracts, and reconciling data during issues with the shopping cart. A typical diagnostic query joins to the cart header and item master:

• SELECT scl.cart_line_id, sc.cart_id, sc.preparer_id, msi.segment1 item, scl.quantity
  FROM icx.icx_shopping_cart_lines scl,
  icx.icx_shopping_carts sc,
  inv.mtl_system_items_b msi
  WHERE scl.cart_id = sc.cart_id
  AND scl.item_id = msi.inventory_item_id
  AND scl.destination_organization_id = msi.organization_id
  AND sc.cart_id = :p_cart_id;

Reporting use cases often aggregate line data to understand purchasing patterns by item, cost center, or auto-sourcing compliance.

Related Objects

ICX_SHOPPING_CART_LINES has defined foreign key relationships with several key EBS tables, as documented in the metadata:

• ICX_SHOPPING_CARTS: The parent header table. Joined via ICX_SHOPPING_CART_LINES.CART_ID.
• HR_LOCATIONS_ALL: Provides the deliver-to address. Joined via ICX_SHOPPING_CART_LINES.DELIVER_TO_LOCATION_ID.
• PO_LINES_ALL: Identifies the source blanket or contract. Joined via ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_HEADER_ID and AUTOSOURCE_DOC_LINE_NUM.
• MTL_SYSTEM_ITEMS_B: The inventory item master. Joined via ICX_SHOPPING_CART_LINES.ITEM_ID and DESTINATION_ORGANIZATION_ID.
• ICX_CART_LINE_DISTRIBUTIONS: The child table storing accounting distributions for the cart line. Joined via ICX_CART_LINE_DISTRIBUTIONS.CART_LINE_ID.