MRP Planned Order

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