Results for “seq_num”

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

Overview

MRP_ATP_PERIOD_V is a valid, published APPS schema view within the Oracle E-Business Suite Master Scheduling/MRP (MRP) product. It exposes aggregated Available-to-Promise (ATP) information at the ATP period level, combining the period-based supply, demand, and net availability calculations of the ATP engine with descriptive item, organization, resource, department, and line context. The view is defined in both Oracle EBS 12.1.1 and 12.2.2, and its status is recorded as VALID in the ETRM metadata.

The view is primarily intended for reporting, inquiry, and integration scenarios in which an implementer needs to retrieve ATP results broken down by ATP period without directly decoding the underlying staging structures. Because it joins the ATP base view to key flexfield item views and organization parameters, it presents human-readable identifiers such as INVENTORY_ITEM_NUMBER, REQUEST_ITEM_NUMBER, and ORGANIZATION_CODE alongside numeric identifiers. This makes it especially useful when a user or report must resolve an item from a concatenated segment value, for example when searching on inventory_item_number.

Underlying Base Objects

The view is defined over the following documented base objects:

• MTL_SUPPLY_DEMAND_TEMP (SYNONYM) — the temporary supply/demand work table holding ATP period rows, aliased TEMP, filtered to RECORD_TYPE = 'ATP'.
• MRP_ATP_BASE_V (VIEW) — the base ATP view providing ATP_GROUP_ID, entity, resource, department, line, UOM, and grouping attributes, aliased ATP.
• MTL_SYSTEM_ITEMS_KFV (SYNONYM), used twice as ITEM1 and ITEM2 — the key flexfield item view supplying CONCATENATED_SEGMENTS for the request item and the inventory item.
• MTL_PARAMETERS (SYNONYM), aliased P — the organization parameters table supplying ORGANIZATION_CODE.
• FND_PROFILE (PACKAGE) — used via FND_PROFILE.VALUE('BOM:CONFIG_ITEM_DELIMITER') to resolve the configured item delimiter for configuration/resource naming.

Joins bind TEMP.SEQ_NUM to ATP.ATP_GROUP_ID, TEMP.INVENTORY_ITEM_ID to ATP.ENTITY_ID, and TEMP.ORGANIZATION_ID to ATP.ORGANIZATION_ID, with additional item and organization joins to MTL_SYSTEM_ITEMS_KFV and MTL_PARAMETERS. The view uses DISTINCT on the joined result.

Key Columns

• ROW_ID — row identifier derived from TEMP.ROWID.
• SEQ_NUM / ATP_GROUP_ID — grouping keys that bind the temporary supply/demand rows to the ATP base rows.
• ATP_PERIOD_START_DATE / ATP_PERIOD_END_DATE — the period window over which ATP values are aggregated.
• ATP_PERIOD_TOTAL_SUPPLY / ATP_PERIOD_TOTAL_DEMAND — total supply and demand within the period.
• PERIOD_NET_AVAILABLE / ATP — net available quantity and the resulting available-to-promise quantity for the period.
• ENTITY_ID / ENTITY_NAME — the ATP entity (item or resource) and its resolved name.
• ORGANIZATION_ID / ORGANIZATION_CODE — the inventory organization and its code.
• REQUEST_ITEM_ID / REQUEST_ITEM_NUMBER — the requested item and its concatenated flexfield segments.
• INVENTORY_ITEM_ID / INVENTORY_ITEM_NUMBER — the inventory item identifier and its concatenated segment value, the attribute commonly searched as inventory_item_number.
• RESOURCE_ID / RESOURCE_CODE, DEPARTMENT_ID / DEPARTMENT_CODE, LINE_ID / LINE_CODE — resource, department, and line context.
• UOM_CODE, GROUP_AVAILABLE_DATE — unit of measure and the date the grouped quantity becomes available.

Common Use Cases and Queries

Typical uses include ATP period reporting, resolving ATP results to item numbers, and integration extracts. Filtering by INVENTORY_ITEM_NUMBER allows users to locate ATP periods for a specific concatenated item segment value.

• List ATP periods for a specific item in an organization.
• Report net available and ATP by period for planning review.
• Extract ATP supply/demand totals for downstream integration.

Sample query:

SELECT inventory_item_number, organization_code, atp_period_start_date, atp_period_end_date, atp_period_total_supply, atp_period_total_demand, period_net_available, atp FROM apps.mrp_atp_period_v WHERE inventory_item_number = :item AND organization_id = :org ORDER BY atp_period_start_date;