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
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 NameSQL textValidation
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 MRP Horizontal Plan MRP Item Forecast Item_Forecast
Blitz Report™