{"iTotalDisplayRecords":"0","query":"\r\nSELECT SQL_CALC_FOUND_ROWS `purchase_order_id`, `purchase_order_number`, `purchase_order_date`, `purchase_order_status`, `purchase_order_vendor`, `purchase_order_location`, `purchase_order_project`, `purchase_order_company`, `purchase_order_terms`, `purchase_order_credit_duration`, `purchase_order_due_date`, `purchase_order_remarks`, `purchase_order_added_by`, `purchase_order_added_on`, `purchase_order_approved_by`, `purchase_order_approved_on`, `purchase_order_added_user_name`, `purchase_order_approved_user_name`, `purchase_order_vendor_name`, `purchase_order_vendor_code`, `purchase_order_project_name`, `stock_company_master_name`, `stock_location_name`\r\nFROM purchase_order_view\r\n Where `purchase_order_status` != 'Waiting'\r\nORDER BY purchase_order_added_on DESC\r\n\r\n","aaData":[]}