Search Results mrp_atp_properties_v




Overview
Explore in AI Chat

Overview

The MRP_ATP_PROPERTIES_V view is a reporting and integration construct within the Oracle E-Business Suite Master Scheduling/MRP (MRP) product. Owned by the APPS schema and validated against Oracle EBS 12.1.1 and 12.2.2, it exposes ATP (Available-to-Promise) planning attributes assembled during an ATP inquiry or scheduling session. The view's principal function is to present transient ATP computation results — lead times, capacity constraints, substitution windows, and operational attributes — in a de-normalized, human-readable form. This makes it suitable for diagnostic queries, custom concurrent programs, and downstream integrations that need to reconcile the numeric flags stored in the working table with their descriptive lookup meanings.

The view is of particular interest to implementers searching on atp_flag, because it resolves the raw ATP_FLAG and ATP_COMPONENT_FLAG code values into their FND_COMMON_LOOKUPS meanings directly in the SELECT list.

Underlying Base Objects

Per documented ETRM metadata for 12.2.2, the view is defined over the following objects:

Key Columns

Common Use Cases and Queries

Typical scenarios include validating that ATP flags were set as expected during an order-scheduling run, and integrating ATP attributes into custom dashboards. A representative query filtering on the very attribute users search for:

SELECT SESSION_ID, PEGGING_ID, ATP_FLAG, ATP_COMPONENT_FLAG, ATP_RULE_NAME, REQUIRED_QUANTITY, REQUIRED_DATE FROM APPS.MRP_ATP_PROPERTIES_V WHERE ATP_FLAG = 'Y';

Because the view already decodes flags, the ATP_FLAG column returns descriptive lookup meanings rather than the single-character codes; consumers should compare against the decoded value or join back to FND_COMMON_LOOKUPS when the raw code is required. Additional use cases include lead-time analysis across sessions, substitution-window reporting, and capacity constraint review via WEIGHT_CAPACITY and VOLUME_CAPACITY. Since the source is a temporary table, results are session-scoped and should not be treated as persistent historical records.