{"iTotalDisplayRecords":"0","query":"\r\n      SELECT SQL_CALC_FOUND_ROWS `vendor_advance_payment_detail_id`, `advance_payment_id`, `vendor_id`, `vendor_type`, `project_id`, `status`, `requested_amount`, `approved_amount`, `issued_amount`, `requested_by`, `approved_by`, `issued_by`, `rejected_by`, `requested_on`, `approved_on`, `issued_on`, `rejected_on`, `requested_remark`, `approved_remark`, `issue_remark`, `rejected_remark`, `vendor_advance_payment_document`, `vendor_advance_payment_mode`, `vendor_advance_payment_bank`, `vendor_advance_payment_instrument_detail`, `vendor_advance_payment_instrument_date`, `requested_user_name`, `approved_user_name`, `issued_user_name`, `rejected_user_name`, `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_master_name`, `stock_company_master_name`, `project_company_id`, `vendor_type_name`, `payment_mode_name`\r\n      FROM vendor_advance_payment_detail_view\r\n      \r\n      ORDER BY requested_on DESC\r\n      \r\n      ","aaData":[]}