MRP Planning Exception Sets

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Planning Exception Sets Report
Application: Master Scheduling/MRP
Source: Planning Exception Sets Report (XML)
Short Name: MRPRPPES_XML
DB package: MRP_MRPRPPES_XMLP_PKG
Run MRP Planning Exception Sets and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   pes.exception_set_name, 
         pes.excess_quantity, 
         pes.user_time_fence, 
         pes.repetitive_variance, 
         lu1.meaning shortage_type, 
         lu2.meaning excess_type, 
         lu3.meaning rep_variance_type,
         lu4.meaning overpromised_type
FROM     mrp_planning_exception_sets pes,
         mfg_lookups lu1,
         mfg_lookups lu2,
         mfg_lookups lu3,
         mfg_lookups lu4
WHERE    pes.organization_id = :P_ORG_ID
AND      lu1.lookup_type = 'MRP_EXCEPTION_TIME_PERIOD'
AND      lu1.lookup_code = pes.shortage_type
AND      lu2.lookup_type = 'MRP_EXCEPTION_TIME_PERIOD'
AND      lu2.lookup_code = pes.excess_type
AND      lu3.lookup_type = 'MRP_EXCEPTION_TIME_PERIOD'
AND      lu3.lookup_code = pes.rep_variance_type
AND      lu4.lookup_type = 'MRP_EXCEPTION_TIME_PERIOD'
AND      lu4.lookup_code = pes.overpromised_type
ORDER BY pes.exception_set_name
Download
 
Related Blitz Reports
CAC Sourcing Rule CST Supply Chain Indented Bills of Material Cost MSC Horizontal Plan CAC User-Defined and Rolled Up Costs CAC Cost vs. Planning Item Controls CAC Item vs. Component Include in Rollup Controls CAC Calculate ICP PII Item Costs CAC Intercompany SO Price List vs. Item Cost Comparison CAC Calculate ICP PII Item Costs by Where Used
Blitz Report™

Blitz Report™ provides multiple benefits: