Search Results pjm_unit_numbers




Overview
Explore in AI Chat

Overview

The PJM_UNIT_NUMBERS table is a core data structure within the Oracle E-Business Suite Project Manufacturing (PJM) module. It serves as the master repository for end item model and unit numbers, which are critical identifiers for uniquely tracking manufactured assets, such as complex equipment, vehicles, or machinery, throughout their production lifecycle. This table enables the association of specific serialized units with project deliverables, ensuring traceability from a sales order or project requirement through manufacturing and final shipment. Its role is integral to managing build-to-order and engineer-to-order manufacturing processes within the EBS environment.

Key Information Stored

The table's primary key is the UNIT_NUMBER column, which stores the unique identifier for the end item unit. Based on the documented foreign key relationships, other significant columns include END_ITEM_ID and MASTER_ORGANIZATION_ID. These columns link the unit number to a specific inventory item (in MTL_SYSTEM_ITEMS_B) and define the master inventory organization context. The table's structure supports the tracking of which discrete job or flow schedule is building a particular unit, as evidenced by its foreign key relationships to WIP_DISCRETE_JOBS and WIP_FLOW_SCHEDULES.

Common Use Cases and Queries

A primary use case is tracing the manufacturing history of a specific unit. For instance, to find the work order building a particular unit number, a common query would join PJM_UNIT_NUMBERS to WIP_DISCRETE_JOBS. Another critical scenario is serial number history tracking, where the table links to MTL_SERIAL_NUMBERS and the PJM_UNIT_SERIAL_HISTORY table to audit changes. Reporting on all unit numbers associated with a specific project item would involve filtering on END_ITEM_ID. Data integrity checks are also common, such as identifying unit numbers in PJM_UNIT_NUMBERS that are not linked to a valid inventory item.

  • Sample Query: Retrieve the work order and item details for a unit number.
    SELECT pun.unit_number, wdj.wip_entity_name, msib.segment1 item_code
    FROM pjm.pjm_unit_numbers pun
    JOIN wip.wip_discrete_jobs wdj ON pun.unit_number = wdj.end_item_unit_number
    JOIN inv.mtl_system_items_b msib ON pun.end_item_id = msib.inventory_item_id AND pun.master_organization_id = msib.organization_id;

Related Objects

The PJM_UNIT_NUMBERS table has extensive relationships with other EBS entities, as detailed in its foreign key metadata. Key dependencies include:

  • MTL_SYSTEM_ITEMS_B: Validates the end item being manufactured.
  • MTL_SERIAL_NUMBERS: Links the unit number to specific serialized inventory.
  • PJM_UNIT_SERIAL_HISTORY: Tracks changes to the unit-serial association over time.
  • WIP_DISCRETE_JOBS & WIP_FLOW_SCHEDULES: Identifies the manufacturing work order building the unit.
  • WIP_JOB_SCHEDULE_INTERFACE: Supports the import of jobs for the unit via open interfaces.
  • MTL_PARAMETERS: Establishes organizational context via the master organization.

These relationships underscore the table's central position in the manufacturing execution and serial control workflows of Project Manufacturing.