Search Results ps_schd_dtl




Overview
Explore in AI Chat

Overview

The PS_SCHD_DTL table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for Process Planning. It functions as the schedule detail table, storing granular information related to production schedules. Its primary role is to hold the detailed parameters and organizational context for a production schedule, acting as a child record to the schedule header (PS_SCHD_HDR). The table is integral to the scheduling engine, enabling the planning and management of manufacturing operations within specific organizational units.

Key Information Stored

The table's structure centers on linking a schedule to an organization and storing associated planning parameters. The provided metadata indicates the primary key is a composite of SCHEDULE_ID and ORGN_CODE, establishing that a schedule can have distinct detail records for different organizations. Key columns include SCHEDULE_ID, which links to the PS_SCHD_HDR table; ORGN_CODE, which links to the organization master tables (SY_ORGN_MST and SY_ORGN_MST_B); CALENDAR_ID, which links to a manufacturing calendar (MR_SHCL_HDR) to define working days and shifts; and TEXT_CODE, which links to descriptive text (PS_TEXT_HDR). This design allows for organization-specific scheduling rules, calendars, and instructions to be attached to a master production schedule.

Common Use Cases and Queries

This table is central to queries that retrieve the organizational scope and detailed constraints of a production schedule. Common use cases include generating reports on which organizations are included in a specific schedule, identifying the manufacturing calendar applied to a schedule for a given plant, and fetching schedule details for capacity planning or shop floor dispatching. A typical query would join PS_SCHD_DTL to the header and organization master tables.

  • Sample Query: To list all organizations and their assigned calendars for a specific schedule:
    SELECT d.ORGN_CODE, o.ORGN_NAME, d.CALENDAR_ID
    FROM GMP.PS_SCHD_DTL d,
         SY_ORGN_MST o
    WHERE d.SCHEDULE_ID = :schedule_id
    AND d.ORGN_CODE = o.ORGN_CODE;

Related Objects

PS_SCHD_DTL maintains critical relationships with several other EBS objects, as defined by its foreign keys. The primary parent table is PS_SCHD_HDR, which contains the high-level schedule definition. It references MR_SHCL_HDR for calendar information and PS_TEXT_HDR for attached notes or instructions. The dual foreign keys to SY_ORGN_MST and SY_ORGN_MST_B anchor the schedule detail to the organization structure. Understanding these relationships is essential for any data extraction, integration, or extension involving manufacturing schedules in Oracle Process Manufacturing.