MRP Supply Chain Schedule Status
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
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 |