Results for “mtl_pull_seq_suppliers”

39 results




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

Overview

The MTL_PULL_SEQ_SUPPLIERS table is an Inventory (INV) module data object that stores supplier-level sourcing assignments for kanban pull sequences. Pull sequences define the replenishment mechanism for kanban-managed items at a given organization and inventory location; MTL_PULL_SEQ_SUPPLIERS refines that mechanism by allocating sourcing responsibility to specific suppliers and supplier sites, along with a distribution percentage and a card count.

The object is owned by the INV schema and is documented as VALID in ETRM 12.2.2, with the same structure applying to 12.1.1. It contains twelve documented columns.

The FK relationship from PULL_SEQUENCE_ID to MTL_KANBAN_PULL_SEQUENCES identifies the column. ETRM’s heuristic Data Vault classification for this table is standalone, meaning it participates only as a child in the parent/child relationship to the pull sequence header. Under this classification, PULL_SEQUENCE_ID functions effectively as the join to the hub, and the table behaves as a dependent link or satellite rather than an independent entity. This is a modeling suggestion derived from the mined FK structure, not a native EBS designation.

Key Information Stored

  • PULL_SEQUENCE_ID – References MTL_KANBAN_PULL_SEQUENCES. This is the FK column and the first column of the unique index; it links the supplier allocation to its parent pull sequence.
  • SUPPLIER_ID – The supplier (vendor) assigned to source the kanban card quantity. Together with PULL_SEQUENCE_ID, this forms the unique index MTL_PULL_SEQ_SUPPLIERS_U1, making it the principal business-key candidate.
  • SUPPLIER_SITE_ID – The specific supplier site from which replenishment is sourced.
  • ORGANIZATION_ID – The inventory organization context for the allocation.
  • SOURCING_PERCENTAGE – The share of the replenishment quantity that this supplier bears, supporting multi-supplier split sourcing.
  • NUMBER_OF_CARDS – The number of active kanban cards assigned to the supplier/site combination.
  • FUTURE_NO_OF_CARDS – The planned or pending card count, used where card quantities are adjusted on a forward-dated basis.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard audit columns; the table has no documented WHO columns beyond these.

No surrogate single-column primary key is documented; MTL_PULL_SEQ_SUPPLIERS_U1 (PULL_SEQUENCE_ID, SUPPLIER_ID) is the documented unique index and the practical business-key candidate.

Common Use Cases and Queries

Reporting on supplier sourcing for kanban replenishment is a typical use. A join to the parent pull sequence retrieves item and location context:

  • List all suppliers sourcing a pull sequence, with percentage split and card counts, filtered by ORGANIZATION_ID.
  • Identify supplier/site combinations where SOURCING_PERCENTAGE does not total 100 percent for a PULL_SEQUENCE_ID.
  • Compare NUMBER_OF_CARDS against FUTURE_NO_OF_CARDS to detect pending card adjustments.
  • Reconcile kanban card counts owned by each supplier for a location.
  • Audit changes using LAST_UPDATE_DATE between date ranges.

Because the table is standalone, most queries begin with a join on PULL_SEQUENCE_ID. No API is documented for this object; functional maintenance is performed through the kanban pull sequence and supplier sourcing setup flows in Inventory.

Related Objects

  • MTL_KANBAN_PULL_SEQUENCES – The only documented FK parent. Join on MTL_PULL_SEQ_SUPPLIERS.PULL_SEQUENCE_ID = MTL_KANBAN_PULL_SEQUENCES.PULL_SEQUENCE_ID.
  • MTL_PULL_SEQUENCES – Related pull sequence definition table by name and functional lineage.
  • MTL_KANBAN_CARDS / MTL_KANBAN_ITEM_INFO – Provide card-level detail that the NUMBER_OF_CARDS value summarizes.
  • PO_VENDORS / PO_VENDOR_SITES_ALL – Resolve SUPPLIER_ID and SUPPLIER_SITE_ID to vendor names and site codes.
  • ORG_ORGANIZATION_DEFINITIONS – Resolves ORGANIZATION_ID to a named inventory organization.
  • MTL_SYSTEM_ITEMS_B – Reached through the pull sequence to obtain the kanban item.