MRP Planning Parameters
Description
- Categories
- BI Publisher
- Application
- Master Scheduling/MRP
- Source
- Planning Parameters Report (XML)
- Short Name
- MRPRUSUR_XML
- DB package
- MRP_MRPRUSUR_XMLP_PKG
Imported from BI Publisher
Planning Parameters Report
Planning Parameters Report
SQL 51 lines
SELECT mlu1.meaning C_plan_ss , mlu2.meaning C_consider_wip , mlu3.meaning C_consider_po , mlu4.meaning C_consider_reservations , mlu5.meaning C_demand_tf , mlu6.meaning C_planning_tf , mlu7.meaning C_oper_sched_type , mlu8.meaning C_part_include_type , mlu10.meaning C_period_type , aag.assignment_group_name C_assign_group_name , mpa.repetitive_anchor_date C_anchor_date , mpa.repetitive_horizon1 C_horizon1 , mpa.repetitive_horizon2 C_horizon2 , mpa.repetitive_bucket_size1 C_bucket_size1 , mpa.repetitive_bucket_size2 C_bucket_size2 , mpa.repetitive_bucket_size3 C_bucket_size3 , mlu9.meaning C_snapshot_lock FROM mfg_lookups mlu1 , mfg_lookups mlu2, mfg_lookups mlu3 , mfg_lookups mlu4 , mfg_lookups mlu5 , mfg_lookups mlu6 , mfg_lookups mlu7 , mfg_lookups mlu8 , mfg_lookups mlu9 , mfg_lookups mlu10 , mtl_abc_assignment_groups aag , mrp_parameters mpa WHERE mlu1.lookup_type = 'SYS_YES_NO' AND mlu1.lookup_code = mpa.plan_safety_stock AND mlu2.lookup_type = 'SYS_YES_NO' AND mlu2.lookup_code = mpa.consider_wip AND mlu3.lookup_type = 'SYS_YES_NO' AND mlu3.lookup_code = mpa.consider_po AND mlu4.lookup_type = 'SYS_YES_NO' AND mlu4.lookup_code = mpa.consider_reservations AND mlu5.lookup_type = 'SYS_YES_NO' AND mlu5.lookup_code = mpa.demand_time_fence_flag AND mlu6.lookup_type = 'SYS_YES_NO' AND mlu6.lookup_code = mpa.planning_time_fence_flag AND mlu7.lookup_type = 'MRP_OPERATION' AND mlu7.lookup_code = mpa.operation_schedule_type AND mlu8.lookup_type = 'MRP_PART_INCLUDE_TYPE' AND mlu8.lookup_code = mpa.part_include_type AND mlu9.lookup_type = 'SYS_YES_NO' AND mlu9.lookup_code = mpa.snapshot_lock AND mlu10.lookup_type = 'MRP_REP_PERIOD_TYPE' AND mlu10.lookup_code = mpa.period_type AND aag.assignment_group_id (+) = mpa.default_abc_assignment_group AND mpa.organization_id = :P_ORG_ID |