Search Results supplier_item_pk_key

Overview

EDW_POA_SPIM_SPLRITEM_LTC_IV is a database view associated with the POA – Purchasing Intelligence module of Oracle E-Business Suite. Purchasing Intelligence is now classified as obsolete, meaning it is no longer actively supported or enhanced in recent EBS releases. The view name follows the EDW (Enterprise Data Warehouse) naming convention, indicating that it functions as an extract-layer object intended to supply supplier-item information to downstream analytical, reporting, or integration environments rather than to support transactional online forms.

The "_SPLRITEM" component identifies the subject area as supplier items (approved supplier lists and item sourcing relationships), while the "_LTC" suffix denotes a "latest change" or change-capture style layer. The "_IV" suffix marks this as an interface view, typically used as a staging or transformation layer in an ETL process. Per the documented ETRM metadata, this view is not implemented in this database, and its owner is not documented. The view text instead points to a companion object, EDW_POA_SPIM_SPLRITEM_LTC, as its sole source. Consequently, the view should be regarded as a thin projection over an existing change-tracking table or view, adding an operation code column and exposing well-defined keys for downstream consumption.

Underlying Base Objects

The ETRM metadata documents no base tables directly referenced by this view. The view definition selects exclusively from EDW_POA_SPIM_SPLRITEM_LTC, which is the only referenced object. No other base objects are documented. This means the view is not joined to supplier, site, or item master tables within its own definition; all denormalized descriptive attributes — supplier name, site code, instance, and item description — are already materialized in the source LTC object. The projected column set is identical to the source with one addition: a literal space aliased as OPERATION_CODE, which is a common convention for interface views where the consuming process expects a presence-indicator or change-type column but the feeder view supplies a placeholder.

Key Columns

• ROW_ID – The ROWID of the underlying row in the LTC object, useful for uniquely identifying the physical record within the source structure.
• ALL_FK / ALL_FK_KEY – Foreign-key surrogate and its human-readable key, used to link the supplier-item record to its parent approved-supplier-list or sourcing entity.
• SUPPLIER_ITEM_PK – The primary-key value identifying the supplier-item combination.
• SUPPLIER_ITEM_PK_KEY – The descriptive or concatenated key form of SUPPLIER_ITEM_PK. This is the column most commonly targeted by the search term "supplier_item_pk_key" and serves as the business-facing identifier for the supplier-item relationship.
• SUPPLIER_NAME and SUPPLIER_SITE_CODE – Denormalized supplier and supplier-site identifiers simplifying reporting without additional joins.
• SUPPLIER_ITEM_DP and SUPPLIER_SITE_ITEM_DP – Descriptive flexfield (DP) contexts or attribute values associated with the supplier item and site item.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 – Open descriptive attributes carried through from the source for custom analytical use.
• NAME – Descriptive name, typically the item or supplier-item description.
• INSTANCE – Identifies the source EBS instance, supporting multi-instance warehouse consolidation.
• CREATION_DATE / LAST_UPDATE_DATE – Audit timestamps used for incremental extraction and change detection.
• OPERATION_CODE – A placeholder literal (single space) intended to carry an insert/update/delete indicator in interface processing.

Common Use Cases and Queries

Because this view is part of the obsolete Purchasing Intelligence extraction layer, its practical use is confined to warehouse loads, custom analytics on supplier-item sourcing, and historical data migration. A typical query retrieves the current supplier-item set along with descriptive attributes:

SELECT supplier_item_pk_key,
       supplier_name,
       supplier_site_code,
       supplier_item_dp,
       name,
       last_update_date
FROM   edw_poa_spim_splritem_ltc_iv
WHERE  last_update_date >= :extract_start_date;

An incremental change-capture query would filter on both CREATION_DATE and LAST_UPDATE_DATE to isolate newly created or amended supplier-item relationships for the current load window. Analysts examining sourcing coverage may aggregate by supplier to determine how many approved supplier items exist per supplier name or site code. Note that all queries depend on the source object EDW_POA_SPIM_SPLRITEM_LTC being present and populated; the metadata explicitly records that the view is not implemented in the reference database, so availability must be verified against each environment before reliance in either EBS 12.1.1 or 12.2.2.