{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `schedule_id`, `boq_material_plan_quantity_id`, `schedule_quantity`, `schedule_date`, `schedule_remark`, `stock_indent_item_id`, `received_quantity`, `schedule_status`, `schedule_added_by`, `schedule_added_on`, `boq_material_plan_id`, `material_quantity`, `quantity_plan_remark`, `quantity_plan_status`, `approved_by`, `approved_on`, `boq_material_id`, `material_planned_quantity`, `material_used_quantity`, `process_plan_id`, `stock_material_name`, `stock_material_code`, `stock_material_indicator`, `stock_material_price`, `stock_material_lead_time_procurement`, `stock_material_lead_time_vendor_finalization`, `family_name`, `added_user_name`, `approved_user_name`, `project_process_master_name`, `project_plan_process_plan_id`, `project_plan_process_name`, `project_plan_project_id`, `project_master_name`, `material_id`, `stock_material_unit_of_measure`, `stock_unit_name`, `stock_indent_no`, `stock_indent_item_status`, `purchase_order_item_status`\r\n FROM boq_material_plan_quantity_schedule_view\r\n WHERE stock_indent_item_id > 0\r\n ORDER BY schedule_date ASC\r\n \r\n ","aaData":[]}