Results for “selection_list_type”

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

Overview

MRP_LOAD_SELECTIONS is a table in the MRP schema belonging to the Master Scheduling / MRP product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the selection lists used by the MRP load process. Each row defines a named selection list scoped to a particular organization and selection list type, allowing planners to control which items, schedules, or demand records are included when planning data is loaded into the MRP engine. The table is central to the reproducible execution of planning loads because selection lists parameterize what the load programs process.

Under a heuristic Data Vault classification derived from its foreign key structure, MRP_LOAD_SELECTIONS is hub-leaning: its primary key of SELECTION_LIST_NAME, ORGANIZATION_ID, and SELECTION_LIST_TYPE forms a natural business key that other tables reference. This should be treated as a modeling suggestion rather than a definitive classification.

Key Information Stored

The documented schema exposes nine columns. The primary key, MRP_LOAD_SELECTIONS_PK, spans SELECTION_LIST_NAME, ORGANIZATION_ID, and SELECTION_LIST_TYPE. A unique index, MRP_LOAD_SELECTIONS_U1, covers ORGANIZATION_ID, SELECTION_LIST_NAME, and SELECTION_LIST_TYPE, confirming these three attributes as the business-key candidates that uniquely identify a selection list within the MRP schema.

• SELECTION_LIST_NAME — the identifier of the selection list, which also participates in the foreign key relationship with MRP_LOAD_PARAMETERS.
• ORGANIZATION_ID — the inventory organization to which the selection list applies.
• SELECTION_LIST_TYPE — the category or classification of the selection list, distinguishing how the list is interpreted by the load process.
• DESCRIPTION — a free-text description of the selection list's purpose.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard audit columns recording when and by whom the row was most recently changed.
• CREATION_DATE, CREATED_BY — the standard audit columns recording row creation.

The three identifying columns constitute the business key; the remaining columns are descriptive or audit-oriented and do not uniquely identify a record.

Common Use Cases and Queries

Typical use cases include identifying which selection lists exist for a given organization, auditing recently modified selection definitions, and joining to MRP_LOAD_PARAMETERS to determine which load program invocations reference a list. A representative query lists selection lists for an organization:

• SELECT SELECTION_LIST_NAME, SELECTION_LIST_TYPE, DESCRIPTION FROM MRP.MRP_LOAD_SELECTIONS WHERE ORGANIZATION_ID = :org_id;
• SELECT p.* FROM MRP.MRP_LOAD_PARAMETERS p JOIN MRP.MRP_LOAD_SELECTIONS s ON p.SELECTION_LIST_NAME = s.SELECTION_LIST_NAME AND p.ORGANIZATION_ID = s.ORGANIZATION_ID AND p.SELECTION_LIST_TYPE = s.SELECTION_LIST_TYPE;
• SELECT * FROM MRP.MRP_LOAD_SELECTIONS WHERE LAST_UPDATE_DATE > SYSDATE - 30;

These patterns support reconciliation reporting, change auditing, and impact analysis before deleting or renaming a selection list.

Related Objects

The documented foreign key relationship shows MRP_LOAD_PARAMETERS referencing MRP_LOAD_SELECTIONS on the combined columns SELECTION_LIST_NAME, ORGANIZATION_ID, and SELECTION_LIST_TYPE. Because a selection list is meaningless without the load parameters that consume it, MRP_LOAD_PARAMETERS is the primary dependent object and should be queried alongside this table. The MRP_LOAD_SELECTIONS_PK and MRP_LOAD_SELECTIONS_U1 indexes enforce uniqueness and support lookups during the load process. Broader MRP planning tables and views that resolve selection list membership through the load parameters are also relevant consumers, though their direct dependency is mediated by MRP_LOAD_PARAMETERS rather than by a direct foreign key to MRP_LOAD_SELECTIONS.