MRP Planning Exception Sets

Description
Categories: BI Publisher, Manufacturing
Application: Master Scheduling/MRP
Source: Planning Exception Sets Report (XML)
Short Name: MRPRPPES_XML
DB package: MRP_MRPRPPES_XMLP_PKG
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
Parameter Name SQL text Validation
Organization
 
Number