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 COPY OF: MRP Horizontal Plan MRP Horizontal Plan INV Item Supply/Demand
Blitz Report™

Blitz Report™ provides multiple benefits: