Results for “resource_basis_type”

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

Overview

MRP_ATP_ITEMS_ALL_V is an APPS-owned database view in the Oracle E-Business Suite Master Scheduling/MRP (MRP) product, documented with a status of VALID in ETRM 12.2.2 and equally applicable to 12.1.1. Its description is simply "ATP all items view," and it serves as the consolidated read interface for Available-to-Promise (ATP) item and resource data. The view resolves ATP information across multiple ATP groupings, organizations, and inventory items without requiring the caller to join the individual ATP sub-views directly. It is a UNION ALL of three distinct query branches, which explains the "ALL" in its name: it presents the union of ATP item-resource lines, ATP base entities, and CTP (Capable-to-Promise) routing-derived items.

Underlying Base Objects

The view is defined over three documented referenced objects:

• MRP_ATP_ITEMS_RESOURCE_V (VIEW) — the first UNION ALL branch, aliased implicitly, supplying ATP Group, Organization, Inventory Item, Department, Resource, Line, Entity, ATP Rule, and related resource columns directly.
• MRP_ATP_BASE_V (VIEW) — the second and third branches, each filtered (the second by ENTITY_ID > 0, the third joined to BOM_OPERATIONAL_ROUTINGS with CTP_FLAG = 1), supplying the base ATP entity rows and the CTP routing rows respectively.
• BOM_OPERATIONAL_ROUTINGS (SYNONYM) — joined in the third branch on ORGANIZATION_ID and LINE_ID, providing the assembly item (RTG.ASSEMBLY_ITEM_ID) for CTP-enabled routings.

The second and third branches pad several columns with TO_NUMBER(NULL) for RESOURCE_OFFSET_PERCENT, OPERATION_SEQ_NUM, and OPTION_DEPENDENT_FLAG, since those attributes are only populated by the resource branch.

Key Columns

The view exposes eighteen columns. The most significant include:

• ATP_GROUP_ID — the ATP grouping key that ties an item and resource combination to its planning rules.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, DEPARTMENT_ID — the standard inventory and routing context for the ATP line.
• RESOURCE_ID, LINE_ID, ENTITY_ID — identify the resource, production line, and ATP entity driving availability.
• ATP_RULE_ID, AVAILABLE_TO_ATP, ATP_CALENDAR_ORGANIZATION_ID — the ATP rule, quantity available, and calendar organization used in the availability calculation.
• DEMAND_CLASS, RESOURCE_BASIS_TYPE, RESOURCE_USAGE_RATE_OR_AMOUNT, RESOURCE_OFFSET_PERCENT — resource consumption and timing attributes.
• AVAILABLE_24_HOURS_FLAG — indicates whether the resource is available on a 24-hour basis.
• OPERATION_SEQ_NUM and OPTION_DEPENDENT_FLAG — routing operation sequencing and whether the operation is option-dependent. Because the user searched for option_dependent_flag, note that this column is populated only in the first UNION ALL branch (from MRP_ATP_ITEMS_RESOURCE_V); the second and third branches return NULL for it.

Common Use Cases and Queries

Typical uses include ATP inquiry reporting, CTP analysis, and integration extracts that need a single flattened set of ATP-eligible items. The view is commonly queried to list ATP-available resources by organization or to identify which items participate in CTP-enabled routings.

SELECT organization_id,
       inventory_item_id,
       resource_id,
       option_dependent_flag,
       available_to_atp
  FROM apps.mrp_atp_items_all_v
 WHERE organization_id = :org_id
   AND option_dependent_flag = 'Y';

Because the view is a UNION ALL, callers should also expect rows where OPTION_DEPENDENT_FLAG is NULL, reflecting the base and CTP branches.