{"iTotalDisplayRecords":"0","query":"\r\n  SELECT SQL_CALC_FOUND_ROWS `vendor_advance_id`, `reference_number`, `vendor_id`, `vendor_type`, `company_id`, `project_id`, `payment_category`, `advance_status`, `requested_amount`, `approved_amount`, `paid_amount`, `requested_by`, `requested_on`, `requested_remark`, `stock_vendor_name`, `stock_vendor_code`, `project_manpower_agency_name`, `project_manpower_agency_code`, `project_machine_vendor_master_name`, `project_machine_vendor_master_code`, `project_name`, `company_name`, `vendor_type_name`, `requested_user_name`\r\n  FROM vendor_advance_view\r\n   Where (`advance_status` = 'Requested' OR `advance_status` = 'Approved' )\r\n  ORDER BY requested_on DESC\r\n  \r\n  ","aaData":[]}