{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `crm_marketing_expenses_payment_id`, `crm_marketing_expenses_id`, `crm_marketing_expenses_payment_type`, `crm_marketing_expenses_requested_amount`, `crm_marketing_expenses_approved_amount`, `crm_marketing_expenses_issued_amount`, `crm_marketing_expenses_payment_mode`, `crm_marketing_expenses_payment_bank`, `crm_marketing_expenses_payment_instrument_detail`, `crm_marketing_expenses_payment_instrument_date`, `crm_marketing_expenses_payment_status`, `crm_marketing_expenses_payment_request_remark`, `crm_marketing_expenses_payment_approve_remark`, `crm_marketing_expenses_payment_issue_remark`, `crm_marketing_expenses_payment_requested_by`, `crm_marketing_expenses_payment_requested_on`, `crm_marketing_expenses_payment_approved_by`, `crm_marketing_expenses_payment_approved_on`, `crm_marketing_expenses_payment_issued_by`, `crm_marketing_expenses_payment_issued_on`, `crm_marketing_expenses_number`, `crm_marketing_expenses_type`, `crm_marketing_expenses_company`, `crm_marketing_expenses_project`, `crm_marketing_expenses_source`, `crm_marketing_expenses_from_date`, `crm_marketing_expenses_to_date`, `crm_marketing_expenses_amount`, `crm_marketing_expenses_leads`, `crm_marketing_expenses_status`, `crm_marketing_expenses_vendor`, `crm_marketing_expenses_payment_requested_user_name`, `crm_marketing_expenses_payment_approved_user_name`, `crm_marketing_expenses_payment_issued_user_name`, `project_name`, `crm_marketing_expenses_type_name`, `stock_vendor_name`, `stock_vendor_code`, `enquiry_source_master_name`, `enquiry_source_type_name`, `enquiry_source_category_name`, `company_name`, `payment_mode_name`\r\n    FROM crm_marketing_expenses_payment_view\r\n     WHERE (crm_marketing_expenses_status = 'Approved' || crm_marketing_expenses_status = 'Issued')\r\n    ORDER BY crm_marketing_expenses_payment_requested_on DESC\r\n    \r\n    ","aaData":[]}