Search Results flm_mmm_lines_pk

Overview

The FLM_MMM_LINES table is a core data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Flow Manufacturing (FLM) module. It serves as the master table for defining and storing Mixed Model Map (MMM) lines. A Mixed Model Map is a foundational planning tool in flow manufacturing that defines the sequence and rate of production for multiple products on a single assembly line. This table is essential for modeling the physical production lines where mixed-model scheduling and takt time calculations are performed, enabling lean manufacturing principles. Its integrity is maintained through a primary key constraint and it acts as a parent to related operational data.

Key Information Stored

The table stores the fundamental identifiers that link a production line to a specific manufacturing plan and calculation context within an organization. The primary key columns define the unique record: ORGANIZATION_ID identifies the manufacturing facility; PLAN_ID specifies the associated production plan; CALCULATION_OPERATION_TYPE denotes the type of MMM calculation (e.g., for scheduling or capacity analysis); and LINE_ID is a foreign key to the WIP_LINES table, which defines the physical production line in the system. Together, these columns establish the exact context for which mixed-model sequencing is defined. The table's structure is primarily relational, with minimal descriptive attributes, as its main purpose is to establish the valid line-plan-organization relationships for downstream MMM calculations and operations.

Common Use Cases and Queries

This table is primarily accessed during the setup, execution, and reporting of Mixed Model Mapping processes. Common use cases include validating which production lines are included in a specific MMM plan, generating lists of lines available for mixed-model scheduling, and serving as the basis for joins to detailed operation sequences. A typical reporting query would join this table to WIP_LINES to fetch line descriptions and to FLM_MMM_OPERATIONS for detailed scheduling data.

• Sample Query: List all MMM lines for a plan:
  SELECT mmm.line_id, wl.line_code, wl.description
FROM flm_mmm_lines mmm, wip_lines wl
WHERE mmm.line_id = wl.line_id
AND mmm.organization_id = :p_org_id
AND mmm.plan_id = :p_plan_id
AND mmm.calculation_operation_type = :p_op_type;
• Integration Point: Data from this table is critical when launching the "Generate Mixed Model Map" concurrent program, as it defines the scope of lines to be processed.

Related Objects

The FLM_MMM_LINES table maintains defined relationships with several key EBS objects, as documented in the ETRM metadata.

• Primary Key: FLM_MMM_LINES_PK (ORGANIZATION_ID, PLAN_ID, CALCULATION_OPERATION_TYPE, LINE_ID).
• Foreign Keys (Referenced By This Table):
  • WIP_LINES: The LINE_ID column in FLM_MMM_LINES references WIP_LINES, linking the MMM definition to the master definition of a production line.
• Foreign Keys (Referencing This Table):
  • FLM_MMM_OPERATIONS: The child table FLM_MMM_OPERATIONS references FLM_MMM_LINES via its composite key (ORGANIZATION_ID, PLAN_ID, OPERATION_TYPE, LINE_ID). This is a critical relationship where FLM_MMM_LINES acts as the parent for all sequenced operations defined on a mixed-model line.