Search Results group_available_date




Overview
Explore in AI Chat

Overview

APPS.MRP_SCATP_SUPPLY_SOURCES_V is a supplementary database view in the Oracle E-Business Suite Applications schema (APPS). It is owned by APPS and carries the FND Design Data identifier MRP.MRP_SCATP_SUPPLY_SOURCES_V. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. According to the ETRM metadata, the view is classified as "a supplementary view used to simplify forms coding," with the explicit warning that Oracle does not recommend querying or altering data through this view because its definition may change dramatically in subsequent minor or major releases.

Functionally, the view belongs to the supply chain ATP (Available-to-Promise) and scheduling family within Oracle Advanced Supply Chain Planning / Global Order Promising. It surfaces supply-source context — organization, supplier, supplier site, ship method, and intransit lead time — alongside group-level ATP attributes such as GROUP_AVAILABLE_DATE and GROUP_ATP_CHECK. The name prefix MRP_SCATP indicates its association with Supply Chain ATP processing. The inclusion of a GROUP_AVAILABLE_DATE column is directly relevant to the user search term "group_available_date," since that column represents the earliest date by which all requested quantities for every item or resource within a scheduling/ATP group can be satisfied.

Underlying Base Objects

The documented dependency list for APPS.MRP_SCATP_SUPPLY_SOURCES_V includes the following base objects:

The view therefore joins supply-side vendor and site data with inventory organization context and demand interface records, while FND_GLOBAL and FND_COMMON_LOOKUPS supply session and lookup translation values. This composite structure reflects the view's role in supporting grouped ATP checks for third-party or externally sourced supply.

Key Columns

  • SESSION_ID (NUMBER) — the session identifier for the ATP/scheduling run.
  • SCHEDULE_GROUP_ID (NUMBER) — the scheduling group identifier.
  • ATP_GROUP_ID (NUMBER) — identifies a group of items and/or resources passed to the ATP function as a single group.
  • ORGANIZATION_ID / ORGANIZATION_CODE — the inventory organization identifier and code.
  • SHIP_METHOD / SHIP_METHOD_TEXT — the ship method code (up to 30 characters) and its description (up to 80 characters).
  • INTRANSIT_LEAD_TIME (NUMBER) — the intransit lead time applied to the supply source.
  • VENDOR_ID / VENDOR_NAME — the supplier identifier and name (up to 240 characters).
  • VENDOR_SITE_ID / VENDOR_SITE_CODE — the supplier site identifier and site code (up to 15 characters).
  • GROUP_AVAILABLE_DATE (DATE) — the earliest date that all the requested quantity for each item/resource in the group can be satisfied. This is the central column associated with the user's search.
  • GROUP_ATP_CHECK (NUMBER) — a flag indicating whether all items under the same group ID are treated as group ATP, meaning they return the same GROUP_AVAILABLE_DATE.

Common Use Cases and Queries

The primary use case for this view is supporting grouped ATP checks and diagnosing why a set of items or resources returns a particular consolidated availability date. Supply chain analysts commonly query GROUP_AVAILABLE_DATE in conjunction with ATP_GROUP_ID and GROUP_ATP_CHECK to understand grouped avail ability outcomes across suppliers and organizations. A representative query is:

SELECT session_id, schedule_group_id, atp_group_id, organization_code,
      vendor_name, vendor_site_code, ship_method_text,
      intransit_lead_time, group_available_date, group_atp_check
  FROM apps.mrp_scatp_supply_sources_v
 WHERE group_available_date IS NOT NULL
 ORDER BY atp_group_id, group_available_date;

Because the view is documented as a forms-simplification view, direct querying is discouraged for production reporting; consumers should prefer the underlying integrated APIs or certified concurrent program outputs. Nevertheless, for troubleshooting and ad hoc analysis, filtering on GROUP_AVAILABLE_DATE, ATP_GROUP_ID, and GROUP_ATP_CHECK provides the most direct insight into grouped supply availability and the supplier or organization responsible for the binding constraint.