Get MR not complete.sql

-- get Mr draft
select kr.kst_receipt_id, kr.m_warehouse_id from
kst_receipt kr
join kst_invoicevendor ki on kr.kst_invoicevendor_id = ki.kst_invoicevendor_id
join kst_receiptline krl on kr.kst_receipt_id = krl.kst_receipt_id
join m_inoutline mil on krl.kst_receiptline_id = mil.kst_receiptline_id
join m_inout mi on mil.m_inout_id = mi.m_inout_id
where mi.docstatus in  ('DR', 'IP')