1218: , null --"settlement_type_id"
1219: , inv.invoice_num --"settlement_number"
1220: , inv.invoice_date --"settlement_date"
1221: , inv.invoice_amount --"settlement_amount"
1222: , AP_INVOICES_PKG.GET_APPROVAL_STATUS( INV.INVOICE_ID, INV.INVOICE_AMOUNT, INV.PAYMENT_STATUS_FLAG, INV.INVOICE_TYPE_LOOKUP_CODE) --"status_code"
1223: , 'AP_DEBIT' --"payment_method"
1224: , NULL
1225: , inv.invoice_amount
1226: FROM ap_invoices_all inv