Results for “to_subinventory_name”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The WMS_SELECTION_CRITERIA_TXN table is a Warehouse Management (WMS) repository object that stores the selection criteria and assignment matrix rules used to drive rule-based transaction processing within Oracle E-Business Suite. In the WMS module, this table acts as the governing configuration storefront that determines how inbound and outbound inventory transactions are routed, classified, or assigned to specific handling paths based on a rich set of dimension attributes. The table is owned by the WMS schema and is documented as VALID across both Oracle EBS 12.1.1 and 12.2.2 releases, holding approximately 41 columns in its documented physical schema.
From a data-modeling perspective, the ETRM heuristic classification for this object is standalone. This suggests that the table functions as an independent rule-definition entity rather than a classic Data Vault hub, link, or satellite. It is a configuration master whose rows participate as a referenced parent in downstream rule evaluation logic, but it does not sit on the core transactional fact path itself. Analysts modeling the WMS rule engine may therefore treat it as a reference/dimension-style entity.
Key Information Stored
The table's primary key is WMS_SELECTION_CRITERIA_TXN_PK1, defined on the composite of FROM_ORGANIZATION_ID, RULE_TYPE_CODE, and SEQUENCE_NUMBER. A separate unique index (documented as WMS_SELECTION_CRITERIA_TXN_PK1 on STG_ASSIGNMENT_ID) also appears in the business-key candidate list, indicating that the staging assignment identifier behaves as a unique business key in the documented schema.
The most significant columns include:
STG_ASSIGNMENT_ID— surrogate-style assignment identifier and documented unique-index candidate.RULE_TYPE_CODE— the type of selection rule being evaluated; part of the primary key.SEQUENCE_NUMBER— ordering key controlling rule precedence; part of the primary key.FROM_ORGANIZATION_ID/TO_ORGANIZATION_ID— source and destination organizations, scoping which inventories the rule applies to; part of the primary key.FROM_SUBINVENTORY_NAME/TO_SUBINVENTORY_NAME— subinventory-level scoping for the rule.ENABLED_FLAG— activation switch controlling whether the rule is applied.EFFECTIVE_FROM/EFFECTIVE_TO— date range governing rule validity.ASSIGNMENT_GROUP_ID— link to ABC assignment groups (MTL_ABC_ASSIGNMENT_GROUPS).ABC_CLASS_ID— ABC classification reference (MTL_ABC_CLASSES).ORDER_TYPE_ID— sales order type reference (SO_ORDER_TYPES_115_ALL).TRANSACTION_SOURCE_TYPE_ID— transaction source reference (MTL_TXN_SOURCE_TYPES).INVENTORY_ITEM_ID,CATEGORY_ID,CUSTOMER_ID,VENDOR_ID— item, category, and party-based rule conditions.PROJECT_ID,TASK_ID,USER_ID— project and user dimension conditions.
Common Use Cases and Queries
Typical reporting scenarios include auditing which rules are enabled for a given organization, tracing the rule sequence for a rule type, and reconciling rules against their referenced ABC classes or order types. A common query pattern retrieves active, currently effective rules for a source organization:
SELECT rule_type_code, sequence_number, from_organization_id, enabled_flag— filter byFROM_ORGANIZATION_ID,ENABLED_FLAG = 'Y', and date coverage betweenEFFECTIVE_FROMandEFFECTIVE_TO.- Join to
MTL_ABC_CLASSESonABC_CLASS_IDto report rule-to-class mappings. - Join to
SO_ORDER_TYPES_115_ALLonORDER_TYPE_IDto identify order-type-driven assignment rules.
Related Objects
The documented foreign-key relationships establish the table's dependency surface. The most significant related objects are:
MTL_ABC_ASSIGNMENT_GROUPS— referenced viaASSIGNMENT_GROUP_ID.MTL_ABC_CLASSES— referenced viaABC_CLASS_ID.SO_ORDER_TYPES_115_ALL— referenced viaORDER_TYPE_ID.MTL_TXN_SOURCE_TYPES— referenced viaTRANSACTION_SOURCE_TYPE_ID.- Inventory and category master tables implied by
INVENTORY_ITEM_IDandCATEGORY_ID.
-
Selection Criteria /Assignment Matrix Table
-
Selection Criteria /Assignment Matrix Table
-
- Retrofitted
APPS.INVFV_INVENTORY_SUPPLIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_PARAMETERS·Explore INV module →
-
- Retrofitted
APPS.INVBV_INVENTORY_SUPPLIES·↳ MTL_SUPPLY·Explore INV module →
-
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
- Retrofitted
APPS.INVBV_INVENTORY_SUPPLIES·↳ MTL_SUPPLY·Explore INV module →
-
This view shows information about the selection criteria for WMS Rules
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
- Retrofitted
APPS.INVFV_INVENTORY_SUPPLIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_PARAMETERS·Explore INV module →
-
eTRM - WMS Tables and Views 12.1.1
-
eTRM - WMS Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2