Results for “mrp_order_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.MSC_FLP_END_DEMAND_V is a reporting and integration view within the Oracle Advanced Supply Chain Planning (ASCP) schema, exposed through the APPS account. The suffix "FLP" denotes its association with the Full Pegging and end-demand analysis functionality used in the MSC (MSC = Manufacturing Scheduling and Constraint) planning tables. The view consolidates end-demand records against their associated supply, pegged requirement, and item context, producing a flattened, human-readable representation of planning pegging relationships. It is consumed by planner workbenches, pegging reports, and downstream supply-demand reconciliation queries that need to translate numeric type codes (order types, demand types, supply types) into descriptive lookup meanings.
Because the view calls the MSC_GET_NAME package and applies DECODE logic, it is one of the mechanisms by which internal supply-demand type codes are surfaced as readable labels. This makes it directly relevant to the search term mrp_order_type, since the view resolves MRP_ORDER_TYPE lookup meanings for supply records.
Underlying Base Objects
The view is defined over the following documented base objects:
- MSC_DEMANDS (synonym) — source of demand records.
- MSC_FULL_PEGGING (synonym) — the core pegging table holding allocated quantities, pegging IDs, and prior pegging references (aliased MFP in the view text).
- MSC_SUPPLIES (synonym) — supply records referenced through pegging.
- MSC_ITEMS (synonym) — item master information used for item names and descriptions.
- MSC_GET_NAME (package) — supplies lookup_meaning, supply_order, org_code, item_desc, project, and task functions used to decode codes into labels.
The view joins the pegging table (MFP) to demand/requirement rows (aliased MGR/MR) so that each pegged allocation is presented alongside its originating requirement quantity, order quantity, and associated dates.
Key Columns
- ORGANIZATION_ID, PLAN_ID — planning context for the record.
- PEGGING_ID, DEMAND_ID, TRANSACTION_ID — pegging and demand identity keys.
- INVENTORY_ITEM_ID — item reference, resolved via MSC_ITEMS.
- Allocated / Using Requirement / New Order Quantity — numeric measures rounded to two decimals, providing supply-demand quantities.
- Date column — returns schedule date or assembly demand date depending on whether DEMAND_ID equals -1.
- Type label column — a DECODE-driven string combining MRP_FLP_SUPPLY_DEMAND_TYPE and MRP_ORDER_TYPE lookup meanings. This is the column most closely tied to the mrp_order_type search, since supply types 10, 13, 18, and others are translated via MRP_ORDER_TYPE.
- Order number / supply order — resolved by MSC_GET_NAME.supply_order.
- Item name / org code — concatenated display field from MSC_ITEMS and org_code.
- Item description — first 20 characters of the item description.
- Project / Task — project and task context carried from pegging or requirement rows.
Common Use Cases and Queries
Typical uses include end-demand pegging reports, supply-demand reconciliation, and translating supply type codes for planners. Sample SQL:
SELECT organization_id, plan_id, inventory_item_id, allocated_quantity, new_order_quantity FROM apps.msc_flp_end_demand_v WHERE plan_id = :plan;SELECT inventory_item_id, mrp_order_type_label FROM apps.msc_flp_end_demand_v WHERE organization_id = :org;(using the decoded type label column to inspect MRP_ORDER_TYPE meanings).SELECT project, task, demand_id, allocated_quantity FROM apps.msc_flp_end_demand_v WHERE project IS NOT NULL;
Because the view invokes package functions for each row, performance on large plans can be significant; filters on PLAN_ID and ORGANIZATION_ID should always be applied to constrain the pegging set.
-
Lookup Type: MRP_ORDER_TYPE 12.1.1
-
Lookup Type: MRP_ORDER_TYPE 12.2.2
-
View: MSC_FLP_END_DEMAND_V 12.2.2
APPS.MSC_FLP_END_DEMAND_V·↳ MSC_DEMANDS·↳ MSC_FULL_PEGGING·↳ MSC_GET_NAME·Explore MSC module →
-
View: MSC_FLP_END_DEMAND_V 12.1.1
APPS.MSC_FLP_END_DEMAND_V·↳ MSC_DEMANDS·↳ MSC_FULL_PEGGING·↳ MSC_GET_NAME·Explore MSC module →
-
View of detailed resource requirements
APPS.CRP_RESOURCE_REQUIREMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CRP_RESOURCE_PLAN·Explore CRP module →
-
VIEW: APPS.MRP_ATP_SD_TEMP_V 12.2.2
-
VIEW: APPS.MRP_ATP_SD_TEMP_V 12.1.1
-
View of detailed resource requirements
APPS.CRP_RESOURCE_REQUIREMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CRP_RESOURCE_PLAN·Explore CRP module →
-
View: MRP_ATP_SD_TEMP_V 12.2.2
APPS.MRP_ATP_SD_TEMP_V·↳ MFG_LOOKUPS·↳ MRP_ATP_DETAILS_TEMP·↳ MSC_SCH_WB·Explore MRP module →
-
View: MRP_ATP_SD_TEMP_V 12.1.1
APPS.MRP_ATP_SD_TEMP_V·↳ MFG_LOOKUPS·↳ MRP_ATP_DETAILS_TEMP·↳ MSC_SCH_WB·Explore MRP module →
-
VIEW: APPS.MRPBV_PLAN_PEGS 12.2.2
-
An Integration Toolkit view supporting the information for firm planned orders
Not implemented in this database·Explore MRP module →
-
VIEW: APPS.MRPBV_PLAN_PEGS 12.1.1
-
VIEW: APPS.MRP_FLP_SUPPLY_V 12.1.1
-
VIEW: APPS.MRPFV_PLAN_PEGS 12.1.1
-
An Integration Toolkit view supporting the information for firm planned orders
Not implemented in this database·Explore MRP module →
-
VIEW: APPS.MSC_FLP_SUPPLY_V 12.1.1
-
View: MRPBV_PLAN_PEGS 12.2.2
APPS.MRPBV_PLAN_PEGS·↳ MFG_LOOKUPS·↳ MRP_FULL_PEGGING·Explore MRP module →
-
VIEW: APPS.MSC_FLP_SUPPLY_V 12.2.2
-
VIEW: APPS.MRPFV_PLAN_PEGS 12.2.2
-
VIEW: APPS.MRP_FLP_SUPPLY_V 12.2.2
-
View: MRPBV_PLAN_PEGS 12.1.1
APPS.MRPBV_PLAN_PEGS·↳ MFG_LOOKUPS·↳ MRP_FULL_PEGGING·Explore MRP module →
-
View: MSC_FLP_SUPPLY_ATP_V 12.1.1
View of supply information
APPS.MSC_FLP_SUPPLY_ATP_V·↳ MSC_GET_NAME·↳ MSC_ITEMS·↳ MSC_SUPPLIES·Explore MSC module →
-
View: MSC_FLP_SUPPLY_ATP_V 12.2.2
View of supply information
APPS.MSC_FLP_SUPPLY_ATP_V·↳ MSC_GET_NAME·↳ MSC_ITEMS·↳ MSC_SUPPLIES·Explore MSC module →
-
View: MRP_FLP_SUPPLY_V 12.2.2
View of supply information
APPS.MRP_FLP_SUPPLY_V·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·↳ MRP_ITEM_PURCHASE_ORDERS·Explore MRP module →
-
VIEW: APPS.CRP_FORM_QUERY_V 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.CRP_FORM_QUERY_V 12.2.2
-
View: MSC_FLP_SUPPLY_V 12.1.1
View of supply information
APPS.MSC_FLP_SUPPLY_V·↳ MSC_GET_NAME·↳ MSC_PLANS·↳ MSC_SUPPLIES·Explore MSC module →
-
12.2.2 FND Design Data 12.2.2
-
View: MRP_FLP_SUPPLY_V 12.1.1
View of supply information
APPS.MRP_FLP_SUPPLY_V·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·↳ MRP_ITEM_PURCHASE_ORDERS·Explore MRP module →
-
View: MRPFV_PLAN_PEGS 12.1.1
- Retrofitted
APPS.MRPFV_PLAN_PEGS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MRP_FULL_PEGGING·Explore MRP module →