MRP Planning Parameters

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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