Results for “plan_cutoff_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDW_MRP_PNDM_PLN_LCV is a collection view belonging to the Plan Name level of the Plan Name dimension within Oracle Supply Chain Intelligence (ISC), the E-Business Suite data warehousing and analytics product. The suffix conventions used in the object name reflect its role: "EDW" identifies the Enterprise Data Warehouse layer, "MRP" indicates the source application is Oracle Master Scheduling/MRP, "PNDM" denotes the Plan Name dimension, and "LCV" signals a collection view used to stage dimension members for extraction into the warehouse. The view is documented as obsolete in the 12.1.1 and 12.2.2 ETRM repository and is not implemented in the database.
Its purpose is to present one row per planning compilation—a plan name qualified by organization and instance—enriched with descriptive and control attributes that describe how the plan was executed. This includes flags governing whether purchase orders and work in process are considered, whether reservations and safety stock are incorporated, and the plan completion and cutoff dates. A flat, denormalized projection of this kind is typical of ISC dimension staging views, which feed the extraction, transformation, and load routines that populate the Plan Name dimension in the Oracle Business Intelligence Applications and Supply Chain Intelligence schemas.
Underlying Base Objects
The view text defines joins across four base objects:
- MRP_PLANS (MPL) — the primary source, supplying plan compilation details such as COMPILE_DESIGNATOR, ORGANIZATION_ID, PLAN_TYPE, PLAN_COMPLETION_DATE, CUTOFF_DATE, CREATION_DATE, DESCRIPTION, and the consideration flags.
- MTL_PARAMETERS (MP) — supplies ORGANIZATION_CODE, used to construct readable organization-qualified plan names.
- MFG_LOOKUPS (ML1) — resolves PLAN_TYPE against the lookup type MRP_PLAN_TYPE, yielding the descriptive MEANING for the plan type.
- EDW_LOCAL_INSTANCE (INST) — provides the INSTANCE_CODE used to distinguish the source EBS instance in a multi-instance warehouse.
The join conditions link lookups by code and type and link organizations by ORGANIZATION_ID. A restrictive predicate, MPL.PLAN_COMPLETION_DATE IS NOT NULL, ensures only completed plan compilations are exposed. ETRM lists no documented referenced base objects for this view in 12.2.2, reflecting its deprecated status.
Key Columns
- PLAN_NAME_PK — concatenation of COMPILE_DESIGNATOR, ORGANIZATION_ID, and INSTANCE_CODE; the surrogate primary key for the Plan Name dimension.
- PLAN_NAME / NAME / PLAN_NAME_DP — descriptive and display-oriented plan name columns, built as COMPILE_DESIGNATOR with the organization code, used for dimension levels and display paths.
- PLAN_SAFETY_STOCK — the column of interest for users searching "plan_safety_stock," mapping to MRP_PLANS.PLAN_SAFETY_STOCK and indicating whether safety stock is included in the plan.
- PLAN_RESERVE_FLAG — corresponds to CONSIDER_RESERVATIONS, indicating whether reservations are considered.
- INCLUDE_PO_FLAG / INCLUDE_WIP_FLAG — from CONSIDER_PO and CONSIDER_WIP, indicating whether purchase orders and WIP are included.
- COMPLETION_DATE, PLAN_CUTOFF_DATE, CREATION_DATE, LAST_UPDATE_DATE — temporal attributes describing plan compilation and scheduling.
- PLAN_TYPE — the descriptive meaning of the plan type from MFG_LOOKUPS.
- USER_ATTRIBUTE1–5 — reserved placeholders for dimension extensibility.
Common Use Cases and Queries
Since this view is obsolete and unimplemented, its practical value lies in reference and migration contexts: historical ISC implementations may still reference it, and the underlying query pattern remains useful for building equivalent plan-level extracts directly against MRP_PLANS. Analysts investigating safety-stock behavior across plans, or comparing plan configurations across organizations and instances, can adapt the view logic. A representative query is:
SELECT PLAN_NAME_PK, PLAN_NAME, PLAN_SAFETY_STOCK, PLAN_RESERVE_FLAG, INCLUDE_PO_FLAG, INCLUDE_WIP_FLAG, PLAN_TYPE, COMPLETION_DATE FROM EDW_MRP_PNDM_PLN_LCV WHERE PLAN_SAFETY_STOCK = 1 ORDER BY COMPLETION_DATE DESC;
For supported releases, the equivalent extraction should query MRP_PLANS directly, joining MTL_PARAMETERS and MFG_LOOKUPS as shown in the documented view text.
-
View: EDW_MRP_PNDM_PLN_LCV 12.1.1
This is the collection view for the Plan Name level of the Plan Name dimension
APPS.EDW_MRP_PNDM_PLN_LCV·↳ EDW_LOCAL_INSTANCE·↳ MFG_LOOKUPS·↳ MRP_PLANS·Explore ISC module →
-
Table: EDW_MRP_PNDM_PLN_LTC 12.1.1
Plan level table
-
Interface table for Plan level
-
Kanban Plan Names table
-
View: MRP_KANBAN_PLANS_V 12.2.2
Kanban Plans View
APPS.MRP_KANBAN_PLANS_V·↳ MRP_FORECAST_DESIGNATORS·↳ MRP_KANBAN_PLANS·↳ MRP_SCHEDULE_DESIGNATORS·Explore MRP module →
-
View: MRP_KANBAN_PLANS_V 12.1.1
Kanban Plans View
APPS.MRP_KANBAN_PLANS_V·↳ MRP_FORECAST_DESIGNATORS·↳ MRP_KANBAN_PLANS·↳ MRP_SCHEDULE_DESIGNATORS·Explore MRP module →
-
Kanban Plan Names table
-
VIEW: MRP.MRP_KANBAN_PLANS# 12.2.2
-
VIEW: MSC.MSC_APCC_UPLOAD# 12.2.2
-
Not implemented in this database·Explore BIS module →
-
VIEW: MSC.MSC_PLAN_RUNS# 12.2.2
-
Not implemented in this database·Explore BIS module →
-
VIEW: MSC.MSC_APCC_UPLOAD# 12.2.2
-
VIEW: MSC.MSC_PLAN_RUNS# 12.2.2
-
VIEW: MRP.MRP_KANBAN_PLANS# 12.2.2
-
TABLE: MSC.MSC_PLAN_RUNS 12.2.2
-
TABLE: MSC.MSC_APCC_UPLOAD 12.2.2
-
TABLE: MRP.MRP_KANBAN_PLANS 12.2.2
-
TABLE: MRP.MRP_KANBAN_PLANS 12.1.1
-
View: EDW_MRP_PNDM_PLN_LCV 12.2.2
This is the collection view for the Plan Name level of the Plan Name dimension
Not implemented in this database·Explore ISC module →
-
PACKAGE: APPS.MSC_ITEM_PKG 12.2.2