MRP Supply Chain Schedule Status

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Supply Chain Schedule Status Report
Application: Master Scheduling/MRP
Source: Supply Chain Schedule Status Report (XML)
Short Name: MRPRPSSS_XML
DB package: MRP_MRPRPSST_XMLP_PKG
Run MRP Supply Chain Schedule Status and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Organization Selection 
 
 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 Master 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: