MRP Master Schedule Status

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Master Schedule Status Report
Application: Master Scheduling/MRP
Source: Master Schedule Status Report (XML)
Short Name: MRPRPSST_XML
DB package: MRP_MRPRPSST_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT   NVL(SUM(NVL(NVL(dates.schedule_quantity,
                                   dates.repetitive_daily_rate), 0)), 0) C_sched
            FROM     bom_calendar_dates  cal,
                     mrp_schedule_dates  dates
            WHERE    cal.calendar_date           BETWEEN
                                                GREATEST(NVL(dates.schedule_workdate,
                                                             trunc(:C_period_start)),
                                                             trunc(:C_period_start))
                                                     AND
                                                   LEAST(NVL
                                                        (NVL(dates.rate_end_date,
                                                             dates.schedule_workdate),
                                                             trunc(:C_period_start)),
                                                             trunc(:C_period_end)
                                                             - 1)
            AND    ( dates.rate_end_date             IS NULL
                 OR  cal.seq_num                 IS NOT NULL)
            AND      cal.calendar_code                = :P_CAL_CODE
            AND      cal.exception_set_id             = :P_CAL_EXCEPTION_SET_ID
            AND      NVL(dates.rate_end_date(+),
                         dates.schedule_workdate(+)) >= :C_period_start
            AND      dates.schedule_workdate(+)       < :C_period_end
            AND      dates.supply_demand_type(+)      = DECODE(:P_SCHED_TYPE,
                                                               1, 1, 2)
            AND      dates.schedule_level(+)          = :P_SCHED_VERSION
            AND      dates.schedule_designator(+)     = :P_SCHED_NAME
            AND      dates.organization_id(+)         = :C_PLANNED_ORG
            AND      dates.inventory_item_id(+)       = :C_item_id_master
Parameter Name SQL text Validation
Schedule Name 
 
 LOV Oracle
Schedule Version 
 
 LOV Oracle
MRP_SRS_REPORT_START_DATE_STANDARD 
 
 Date
Periods 
 
 LOV Oracle
Weeks 
 
 LOV Oracle
Sort 
 
 LOV Oracle
Items From 
 
 Char
To 
 
 Char
Category Set 
 
 LOV Oracle
Categories From 
 
 Char
To 2 
 
 Char
Download
 
Related Blitz Reports
MRP Supply Chain Schedule Status MRP Supply Chain Late Order MRP Pegging MRP Late Order WIP Repetitive Pick List WIP Repetitive Schedule Shortage BOM Calendars MRP Horizontal Plan INV Item Supply/Demand
Blitz Report™

Blitz Report™ provides multiple benefits: