Results for “inv_rule_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_INV_PICKING_RULES is an Inventory module table owned by the INV schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the picking rule definitions that Oracle Inventory and Oracle Warehouse Management use to determine how material is selected, sorted, and allocated when a picking transaction is generated. Each row represents a named picking rule that governs lot selection, revision control, shelf-life enforcement, subinventory and locator sequencing, and whether partial or single-lot picks are permitted. The table therefore acts as the configuration backbone for outbound material handling strategies across order management, shipping, and warehouse execution flows.
The primary key is MTL_INV_PICKING_RULES_PK, defined on the INV_RULE_ID column. Under a heuristic Data Vault classification, MTL_INV_PICKING_RULES is best modeled as a hub candidate, since INV_RULE_ID serves as the unique business key and is referenced by multiple downstream tables as a foreign key. The rule attributes themselves behave as satellite-style descriptive columns attached to that hub.
Key Information Stored
The documented physical schema contains 56 columns. The most operationally significant are:
- INV_RULE_ID — the surrogate and business key (MTL_INV_PICKING_RULES_PK) uniquely identifying each rule.
- SHELF_DAYS — minimum remaining shelf life required for a lot to be eligible for picking.
- SINGLE_LOT — indicates whether the rule restricts picking to a single lot.
- PARTIAL_ALLOWED_FLAG — controls whether partially available quantities may be picked.
- CUST_SPEC_MATCH_FLAG — enforces customer specification matching during selection.
- LOT_SORT and LOT_SORT_RANK — define lot-level sort criteria and their priority order.
- REVISION_SORT and REVISION_SORT_RANK — govern revision sequencing and priority.
- SUBINVENTORY_SORT and SUBINVENTORY_SORT_RANK — control subinventory selection order.
- LOCATOR_SORT and LOCATOR_SORT_RANK — control locator (bin) selection order.
- WMS_RULE_ID and WMS_STRATEGY_ID — link the rule to Oracle Warehouse Management rule and strategy definitions.
- APPLY_TO_SOURCE — determines whether the rule applies at the source level.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–30 — the standard EBS descriptive flexfield columns.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY and the WHO audit columns — standard concurrency and audit tracking.
Common Use Cases and Queries
Picking rules are typically queried to audit allocation behavior, to resolve why a particular lot or subinventory was chosen, or to replicate rule configurations across organizations. A common pattern joins the rule to WMS strategy data:
- Listing all picking rules with their shelf-life and single-lot constraints for a review of outbound policy.
- Identifying rules that allow partial picks where business policy requires full-lot fulfillment.
- Reporting on lot, revision, subinventory, and locator sort ranks to verify prioritization logic.
- Tracing a picking rule reference back from order management or payment terms tables to confirm configuration lineage.
A representative query selects INV_RULE_ID, SHELF_DAYS, SINGLE_LOT, PARTIAL_ALLOWED_FLAG, LOT_SORT, SUBINVENTORY_SORT, and LOCATOR_SORT from MTL_INV_PICKING_RULES, filtered by the relevant rule identifiers. Because the table is configuration-driven, reporting is usually read-only.
Related Objects
INV_RULE_ID is referenced as a foreign key by several objects across Inventory, Order Management, and Payments:
- OKC_K_LINES_B and OKC_K_LINES_BH (INV_RULE_ID) — contract line rule assignments.
- OKI_SALES_K_HDRS (INV_RULE_ID) — sales contract header references.
- PN_PAYMENT_TERMS_ALL and PN_PAYMENT_TERMS_HISTORY (INV_RULE_ID) — payment terms linkage.
- PN_TERM_TEMPLATES_ALL (INV_RULE_ID) — term template references.
These relationships confirm that the table is a referenced master, reinforcing its classification as a hub-style entity whose INV_RULE_ID drives dependent link and satellite structures.
-
Inventory Picking rules
-
View: PN_TERM_TEMPLATES_V 12.2.2
Form view used to enter/view term template information.
APPS.PN_TERM_TEMPLATES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: OKC_K_HEADERS_HV 12.1.1
History view for OKC_K_HEADERS.
APPS.OKC_K_HEADERS_HV·↳ OKC_K_HEADERS_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_UTIL·Explore OKC module →
-
View: PN_PAYMENT_ITEMS_V 12.2.2
APPS.PN_PAYMENT_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_LOOKUP_VALUES·Explore PN module →
-
View: OKC_K_LINES_V 12.1.1
View for table OKC_CONTRACT_LINES_B
APPS.OKC_K_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKC module →
-
View: OKC_K_LINES_V 12.2.2
View for table OKC_CONTRACT_LINES_B
APPS.OKC_K_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKC module →
-
Inventory Picking rules
-
View: OKS_AUTH_HEADERS_V 12.2.2
APPS.OKS_AUTH_HEADERS_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_STATUSES_V·Explore OKS module →
-
View: PN_TERM_TEMPLATES_V 12.1.1
Form view used to enter/view term template information.
APPS.PN_TERM_TEMPLATES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: OKC_K_HEADERS_ALL_HV 12.2.2
APPS.OKC_K_HEADERS_ALL_HV·↳ OKC_K_HEADERS_ALL_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_UTIL·Explore OKC module →
-
View: OKC_K_HEADERS_V 12.1.1
View for table OKC_CONTRACT_HEADERS_B
APPS.OKC_K_HEADERS_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKC module →
-
View: PN_PAYMENT_ITEMS_V 12.1.1
APPS.PN_PAYMENT_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_LOOKUP_VALUES·Explore PN module →
-
PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults.
-
View: OKC_K_LINES_HV 12.1.1
History view for OKC_K_LINES.
APPS.OKC_K_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·Explore OKC module →
-
View: OKC_K_HEADERS_ALL_V 12.1.1
APPS.OKC_K_HEADERS_ALL_V·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKC module →
-
View: OKC_K_HEADERS_ALL_V 12.2.2
APPS.OKC_K_HEADERS_ALL_V·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKC module →
-
View: OKC_K_HEADERS_V 12.2.2
View for table OKC_CONTRACT_HEADERS_B
APPS.OKC_K_HEADERS_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKC module →
-
View: OKS_AUTH_LINES_HV 12.1.1
APPS.OKS_AUTH_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·↳ OKS_K_LINES_BH·Explore OKS module →
-
View: OKS_AUTH_HEADERS_HV 12.2.2
APPS.OKS_AUTH_HEADERS_HV·↳ OKC_K_HEADERS_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_STATUSES_V·Explore OKS module →
-
Term History table.
-
Payment and billing terms defined in a lease
-
View: OKL_K_HEADERS_FULL_V 12.1.1
OKL_K_HEADERS_FULL_V is fulll View on tables OKC_K_HEADERS_B OKL_K_HEADERS. This combines the contracts core and lease managment header attributes into one view.
APPS.OKL_K_HEADERS_FULL_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKL_K_HEADERS_FULL_UV 12.2.2
APPS.OKL_K_HEADERS_FULL_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKS_AUTH_LINES_V 12.2.2
APPS.OKS_AUTH_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKS_K_LINES_B·Explore OKS module →
-
Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract
-
This is a mirror image of base table OKC_K_HEADERS_ALL_B, please refer to the base table for detailed column level information
-
History table for OKC_K_LINES_B.
-
View: OKC_K_LINES_HV 12.2.2
History view for OKC_K_LINES.
APPS.OKC_K_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·Explore OKC module →
-
This is a mirror image of base table OKC_K_LINES_B, please refer to the base table for detailed column level information.
-
PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults.
-
View: OKC_K_HEADERS_ALL_HV 12.1.1
APPS.OKC_K_HEADERS_ALL_HV·↳ OKC_K_HEADERS_ALL_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_UTIL·Explore OKC module →
-
View: OKC_K_HEADERS_HV 12.2.2
History view for OKC_K_HEADERS.
APPS.OKC_K_HEADERS_HV·↳ OKC_K_HEADERS_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_UTIL·Explore OKC module →
-
Term History Form View.
APPS.PN_PAYMENT_TERMS_HISTORY_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_PAYMENT_TERMS_V 12.2.2
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
OKL_K_HEADERS_FULL_V is fulll View on tables OKC_K_HEADERS_B OKL_K_HEADERS. This combines the contracts core and lease managment header attributes into one view.
APPS.OKL_K_HEADERS_FULL_ALL_V·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKS_AUTH_LINES_HV 12.2.2
APPS.OKS_AUTH_LINES_HV·↳ OKC_K_LINES_BH·↳ OKC_K_LINES_TLH·↳ OKS_K_LINES_BH·Explore OKS module →
-
OKL_K_HEADERS_FULL_V is fulll View on tables OKC_K_HEADERS_B OKL_K_HEADERS. This combines the contracts core and lease managment header attributes into one view.
APPS.OKL_K_HEADERS_FULL_ALL_V·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKS_AUTH_HEADERS_HV 12.1.1
APPS.OKS_AUTH_HEADERS_HV·↳ OKC_K_HEADERS_BH·↳ OKC_K_HEADERS_TLH·↳ OKC_STATUSES_V·Explore OKS module →
-
Term History Form View.
APPS.PN_PAYMENT_TERMS_HISTORY_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_PAYMENT_TERMS_V 12.1.1
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: OKS_AUTH_HEADERS_V 12.1.1
APPS.OKS_AUTH_HEADERS_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_STATUSES_V·Explore OKS module →
-
View: OKL_K_HEADERS_FULL_V 12.2.2
OKL_K_HEADERS_FULL_V is fulll View on tables OKC_K_HEADERS_B OKL_K_HEADERS. This combines the contracts core and lease managment header attributes into one view.
APPS.OKL_K_HEADERS_FULL_V·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKL_K_HEADERS_FULL_UV 12.1.1
APPS.OKL_K_HEADERS_FULL_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_UTIL·Explore OKL module →
-
View: OKS_AUTH_LINES_V 12.1.1
APPS.OKS_AUTH_LINES_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKS_K_LINES_B·Explore OKS module →
-
Information about contracts of the sell intent.
-
Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification.
-
Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification.
-
Term History table.
-
View: OKL_K_LINES_FULL_V 12.2.2
OKL_K_LINES_FULL_V is the full view on tables OKC_K_LINES_B and OKL_K_LINES. It combines the attributes of contracts core and lease management contract line tables.
APPS.OKL_K_LINES_FULL_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKL_K_LINES·Explore OKL module →
-
View: OKL_K_LINES_FULL_V 12.1.1
OKL_K_LINES_FULL_V is the full view on tables OKC_K_LINES_B and OKL_K_LINES. It combines the attributes of contracts core and lease management contract line tables.
APPS.OKL_K_LINES_FULL_V·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·↳ OKL_K_LINES·Explore OKL module →