{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `stock_indent_item_id`, `stock_indent_item_material_id`, `stock_indent_id`, `stock_indent_item_quantity`, `stock_po_quantity`, `stock_indent_item_status`, `stock_indent_item_required_date`, `stock_indent_item_remarks`, `stock_indent_item_approved_on`, `stock_indent_item_added_on`, `stock_indent_boq_material_plan_id`, `stock_indent_no`, `stock_indent_project`, `stock_indent_status`, `stock_material_code`, `stock_material_name`, `stock_material_price`, `stock_unit_id`, `stock_unit_name`, `stock_project_name`, `stock_quotation_id`, `stock_quote_number`, `stock_quotation_received_date`, `stock_quotation_approved_on`, `stock_quotation_added_on`, `purchase_order_id`, `purchase_order_number`, `purchase_order_date`, `purchase_order_status`, `purchase_order_vendor`, `purchase_order_approved_on`, `purchase_order_item_id`, `purchase_order_item_status`, `purchase_order_item_quantity`, `purchase_order_item_cost`, `purchase_order_item_added_on`, `stock_grn_qty`, `stock_grn_remaning_qty`, `stock_closing_qty`, `stock_indent_requested_user_name`, `project_process_master_id`, `project_process_master_name`, `stock_vendor_name`, `follow_up_remark`, `follow_up_date`, `grn_quantity`, `scheduled_date`, `scheduled_remark`\r\n    FROM procurement\r\n     Where `stock_indent_project` != '1' AND ((`stock_indent_item_status` != 'Completed') AND ( ((`purchase_order_item_status` != 'Completed') AND (`purchase_order_item_status` != 'ShortClose') ) OR `purchase_order_item_status` IS NULL ))\r\n    ORDER BY stock_indent_item_added_on DESC\r\n    \r\n    ","aaData":[]}