MRP Planning Exception Sets
Description
- Categories
- BI Publisher
- Application
- Master Scheduling/MRP
- Source
- Planning Exception Sets Report (XML)
- Short Name
- MRPRPPES_XML
- DB package
- MRP_MRPRPPES_XMLP_PKG
Imported from BI Publisher
Planning Exception Sets Report
Planning Exception Sets Report
SQL 24 lines
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 |