MRP Planned Order

Description
Categories: BI Publisher
Application: Master Scheduling/MRP
Source: Planned Order Report (XML)
Short Name: MRPRPPLO_XML
DB package: MRP_MRPRPPLO_XMLP_PKG
SELECT   null                       C_item    
,        sys.description                        C_item_description
,        par.organization_code	      C_organization
,        req.uom_code                           C_uom
,        req.planner_code                       C_planner
,        req.buyer_name                         C_buyer
,        NVL(rec.schedule_compression_days, 0)  C_compression_days
,        rec.new_order_placement_date           C_order_date
,        rec.new_wip_start_date                 C_start_date
,        rec.new_dock_date                      C_dock_date
,        rec.new_schedule_date                  C_due_date
,        round(rec.new_order_quantity,:P_QTY_PRECISION) C_quantity
,        round(rec.new_order_quantity 
         * NVL(req.standard_cost, 0),:P_PRECISION) C_value
         &C_SORT_COLUMN, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM
FROM     mtl_item_categories  ic
,        mrp_system_items     req
,        mtl_system_items     sys
,        mrp_recommendations  rec
,        mrp_plan_organizations_v org_v
,        mtl_parameters       par
         &C_CATEGORY_FROM
         &C_ABC_FROM
WHERE    sys.organization_id        = rec.organization_id 
AND      sys.inventory_item_id      = rec.inventory_item_id 
         &C_PLANNER_RANGE
         &C_BUYER_RANGE
         &C_ABC_RANGE
         &C_CATEGORY_WHERE
         &C_ABC_WHERE
AND      &P_ITEM_RANGE
AND      &P_CAT_RANGE
AND      ic.inventory_item_id       = req.inventory_item_id
AND      ic.organization_id         = req.organization_id
AND      ic.category_set_id         = :P_CAT_SET
AND      req.organization_id        = rec.organization_id
AND      req.planning_make_buy_code = NVL(:P_ITEM_SELECT,req.planning_make_buy_code)
AND      req.compile_designator     = rec.compile_designator
AND      req.inventory_item_id      = rec.inventory_item_id 
AND      req.wip_supply_type       != 6
AND      &C_CUTOFF_COLUMN          <= :P_CUTOFF_DATE 
AND      rec.order_type             = 5
AND      rec.organization_id        = org_v.planned_organization
AND      par.organization_id        = rec.organization_id
AND      rec.compile_designator      = org_v.compile_designator
AND      DECODE(:P_ORG_TYPE,1,org_v.planned_organization, org_v.organization_id)        = :P_ORG_ID
AND      org_v.compile_designator     = :P_PLAN_NAME
ORDER BY &CP_ORDER_BY_1 &C_ORDER_BY
Parameter Name SQL text Validation
Plan Name
 
LOV Oracle
Item Selection
 
LOV Oracle
Include Costs
 
LOV Oracle
Sort
 
LOV Oracle
Planner
 
LOV Oracle
Buyer
 
LOV Oracle
Items From
 
To
 
Category Set
 
LOV Oracle
Categories From
 
To
 
ABC Assignment Group
 
LOV Oracle
ABC Class
 
LOV Oracle
Cutoff Type
 
LOV Oracle
Cutoff Date
 
LOV Oracle
Org id
 
Number
Category Structure
 
Number
Currency Code
 
LOV Oracle
Quantity Precision
 
Number