MRP Planning Parameters

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Planning Parameters Report
Application: Master Scheduling/MRP
Source: Planning Parameters Report (XML)
Short Name: MRPRUSUR_XML
DB package: MRP_MRPRUSUR_XMLP_PKG
Run MRP Planning Parameters and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
CAC Inventory Organization Summary MRP Late Order MRP Supply Chain Late Order CST Inventory Value Report - by Cost Group CAC Sourcing Rule 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: