Search Results source_item_restrict_loc

Overview

MTL_KANBAN_PULL_SEQUENCES_V is a public Oracle EBS view owned by the APPS schema and classified under the INV (Inventory) product. It exposes the kanban pull sequence configuration that drives replenishment of kanban-controlled items across an organization. A pull sequence defines how a kanban card is replenished when it is emptied, specifying the source type (for example, intra-org transfer, supplier, or work in process), the source organization, subinventory, and locator, and the sizing rules used to determine card quantity. In Oracle EBS 12.1.1 and 12.2.2 the view is treated as retrofitted, meaning it is a compatibility layer over the base table rather than the primary data entry mechanism; the base table MTL_KANBAN_PULL_SEQUENCES continues to hold the authoritative row data.

The view enriches the plain pull sequence record with denormalized descriptive attributes drawn from adjacent setup entities, so callers do not need to join to item master, subinventory, organization, and lookup tables themselves. This makes it suitable for reporting, extracts, and programmatic consumption of kanban definitions. Because it is a view and not a table, it is read-only; any insertion or update must target the base table through the appropriate Inventory forms or APIs.

Underlying Base Objects

The ETRM documentation lists the following referenced objects: HR_GENERAL (package), HR_ORGANIZATION_UNITS (view), HR_SECURITY (package), MFG_LOOKUPS (view), MTL_KANBAN_PULL_SEQUENCES (synonym), MTL_PARAMETERS (synonym), MTL_SECONDARY_INVENTORIES (synonym), MTL_SYSTEM_ITEMS (synonym), PO_VENDORS (view), and WIP_LINES (synonym).

MTL_KANBAN_PULL_SEQUENCES supplies the core pull sequence attributes and is the driving table. MTL_SYSTEM_ITEMS provides item-level location control flags and subinventory/locator restriction codes for the kanban item. MTL_SECONDARY_INVENTORIES is referenced twice to describe the destination subinventory and, separately, the source subinventory locator type. MTL_PARAMETERS supplies organization-level locator control, negative inventory receipt control, and the organization code. HR_ORGANIZATION_UNITS (guarded by HR_SECURITY and HR_GENERAL) supplies the source organization name. MFG_LOOKUPS decodes the source type into a meaningful value, and PO_VENDORS and WIP_LINES support the supplier and WIP line identifiers exposed by the view.

Key Columns

• PULL_SEQUENCE_ID, ORGANIZATION_ID, KANBAN_PLAN_ID, INVENTORY_ITEM_ID — primary identifiers of the pull sequence and its owning plan, organization, and item.
• SUBINVENTORY_NAME, LOCATOR_ID, SUB_LOCATOR_TYPE — destination stocking location and its locator type.
• SOURCE_TYPE, SOURCE_TYPE_MEANING — the replenishment source category with its decoded meaning.
• SOURCE_ORGANIZATION_ID, SOURCE_ORG_CODE, SOURCE_ORG_NAME — supplying organization identifiers and description.
• SOURCE_ITEM_LOC_CONTROL, SOURCE_ITEM_RESTRICT_SUB, SOURCE_ITEM_RESTRICT_LOC, SOURCE_ORG_LOCATOR_CONTROL, SOURCE_ORG_NEGATIVE_CONTROL — control flags governing whether subinventory and locator values may be manually overridden during replenishment.
• SOURCE_SUBINVENTORY, SOURCE_LOCATOR_ID, SOURCE_SUB_LOCATOR_TYPE — the source stocking location for transfer-type pull sequences.
• SUPPLIER_ID, SUPPLIER_SITE_ID, SUPPLIER_NAME — supplier information for supplier-sourced sequences; SUPPLIER_NAME is returned as NULL in the documented view text and must be resolved separately.
• WIP_LINE_ID, WIP_LINE_CODE — work in process line reference for WIP-sourced sequences; WIP_LINE_CODE is likewise NULL in the view definition.
• REPLENISHMENT_LEAD_TIME, CALCULATE_KANBAN_FLAG, KANBAN_SIZE, FIXED_LOT_MULTIPLIER, SAFETY_STOCK_DAYS, NUMBER_OF_CARDS, MINIMUM_ORDER_QUANTITY — the sizing and planning parameters. CALCULATE_KANBAN_FLAG, the column most directly associated with the search term, indicates whether card quantity should be recalculated by the kanban planning process rather than held at a fixed size.
• AGGREGATION_TYPE, ALLOCATION_PERCENT, RELEASE_KANBAN_FLAG, AUTO_REQUEST, AUTO_ALLOCATE_FLAG — card aggregation, allocation, and automatic request behavior.
• ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield segments.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, UPDATED_FLAG — standard concurrent program and audit columns.

Common Use Cases and Queries

The most frequent use is reporting on kanban pull sequences for a given item or organization, particularly to audit which sequences have automatic recalculation enabled. The following query returns all sequences with the calculate kanban flag set, joined to organization context.

SELECT pull_sequence_id, organization_id, inventory_item_id, subinventory_name, source_type_meaning, calculate_kanban_flag, kanban_size, number_of_cards FROM apps.mtl_kanban_pull_sequences_v WHERE calculate_kanban_flag = 'Y' AND organization_id = :org_id ORDER BY inventory_item_id, pull_sequence_id;

Another common scenario is reconciling source and destination control settings to determine whether users may override the source subinventory or locator at replenishment time.

SELECT pull_sequence_id, inventory_item_id, source_subinventory, source_item_restrict_sub, source_item_restrict_loc, source_org_locator_control FROM apps.mtl_kanban_pull_sequences_v WHERE source_type = 1;

Because SUPPLIER_NAME and WIP_LINE_CODE are NULL in the view text, queries that require those descriptions must join to PO_VENDORS or WIP_LINES on SUPPLIER_ID and WIP_LINE_ID respectively. Reports should also prefer ORGANIZATION_ID filters, since the view is not inherently partitioned by operating unit and relies on HR security for organization visibility when HR_ORGANIZATION_UNITS is accessed.