Search Results flm_seq_task_lines




Overview
Explore in AI Chat

Overview

The FLM_SEQ_TASK_LINES table is a core transactional entity within the Oracle E-Business Suite Flow Manufacturing (FLM) module. It functions as a junction table that associates flow sequencing tasks with specific production lines. Its primary role is to store the detailed line-level execution context for a sequencing task, enabling the system to manage and schedule production across multiple manufacturing lines. This table is integral to the operational logic of flow sequencing, which governs the order and timing of work order releases onto the shop floor to optimize flow and meet demand.

Key Information Stored

The table's structure centers on a composite primary key and several foreign key relationships that define its context. The primary key, FLM_SEQ_TASK_LINES_PK, consists of LINE_ID and SEQ_TASK_ID, enforcing a unique relationship between a production line and a sequencing task. Key columns include SEQ_TASK_ID, which links to the parent task definition in FLM_SEQ_TASKS, and LINE_ID, which references a specific production line in WIP_LINES. The ORGANIZATION_ID column ties the record to an inventory organization via MTL_PARAMETERS, while the RULE_ID column optionally links to a specific sequencing rule defined in the FLM_SEQ_RULES table, allowing for rule-based line assignment.

Common Use Cases and Queries

This table is central to queries that analyze or report on line-specific sequencing assignments. A common use case involves generating a list of all production lines assigned to a particular sequencing task for capacity review. Another scenario is identifying which sequencing rule is applied to a task on a given line. A typical reporting query would join this table to its related master data to provide a comprehensive view.

Sample Query Pattern:
SELECT fstl.seq_task_id,
fstl.line_id,
wl.line_code,
fstl.rule_id,
fsr.rule_name
FROM flm_seq_task_lines fstl,
wip_lines wl,
flm_seq_rules fsr
WHERE fstl.line_id = wl.line_id
AND fstl.organization_id = wl.organization_id
AND fstl.rule_id = fsr.rule_id(+)
AND fstl.seq_task_id = :p_seq_task_id;

Related Objects

The FLM_SEQ_TASK_LINES table maintains documented foreign key relationships with several critical EBS objects, positioning it as a nexus for manufacturing sequencing data.

  • FLM_SEQ_TASKS: References via SEQ_TASK_ID. This is the primary parent table defining the sequencing task.
  • WIP_LINES: References via LINE_ID. Provides the production line master information.
  • MTL_PARAMETERS: References via ORGANIZATION_ID. Defines the inventory organization context.
  • FLM_SEQ_RULES: References via RULE_ID. Links to the optional sequencing rule applied for this task and line.
  • FLM_SEQ_TASK_CONSTRAINTS: Child table referenced by (LINE_ID, SEQ_TASK_ID). Stores specific constraints for the task-line combination.
  • FLM_SEQ_TASK_DEMANDS: Child table referenced by (LINE_ID, SEQ_TASK_ID). Stores demand details scheduled for this task on this line.