Search Results mass_transfer_id

Overview

The PJM_MASS_TRANSFERS table is a core data object within the Oracle E-Business Suite Project Manufacturing (PJM) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master header table for storing and managing Project Mass Transfer requests. These requests facilitate the bulk movement of material between projects, tasks, or other inventory locations, a critical operation in project-centric manufacturing and fulfillment environments. The table acts as the parent entity in the mass transfer process, holding the overarching request information, while detailed line-level data is stored in related child tables.

Key Information Stored

The primary identifier for a mass transfer request is the MASS_TRANSFER_ID column, which serves as the table's primary key. While the provided metadata does not list all columns, typical columns in such a header table would include data points to define the transfer's scope and status. This likely encompasses fields for the requesting user, creation date, last update date, a request number or name, a status flag (such as 'Pending', 'In Process', 'Complete', 'Error'), the source and destination project or organization context, and a description of the transfer. The MASS_TRANSFER_ID is the critical column used to join to all associated transaction details.

Common Use Cases and Queries

The primary use case is the creation, tracking, and reporting of bulk material transfers between projects. Common operational queries involve listing all pending transfers, summarizing transfers by status or project, and diagnosing errors. For reporting, one might join this header to its task details to analyze transfer volumes. A fundamental query pattern retrieves header information for a specific request or a set of requests within a date range.

• Finding all incomplete transfers: SELECT * FROM pjm.pjm_mass_transfers WHERE status NOT IN ('COMPLETE', 'CANCELLED');
• Joining to child task details: SELECT h.mass_transfer_id, h.request_date, t.task_id, t.inventory_item_id FROM pjm.pjm_mass_transfers h, pjm.pjm_mass_transfer_tasks t WHERE h.mass_transfer_id = t.mass_transfer_id;

Related Objects

The PJM_MASS_TRANSFERS table has a documented one-to-many relationship with the PJM_MASS_TRANSFER_TASKS table. This is the primary foreign key relationship, where the MASS_TRANSFER_ID in the PJM_MASS_TRANSFER_TASKS table references the MASS_TRANSFER_ID in the PJM_MASS_TRANSFERS table. This structure allows a single mass transfer request header to manage multiple individual transfer line items or tasks. The integrity of this relationship is enforced by the PJM_MASS_TRANSFERS_PK primary key constraint. Understanding this link is essential for any reporting or data extraction involving the complete mass transfer process.