SELECT 
	m.member_cd,
    cus.customer_code,
    cus.customer_name,
    ih.invoice_no, 
	sls.order_no,
	m.member_cd as 'Sales Order Created by',
	sls.created_date as 'Sales Order Created date',
    ih.invoice_balance,
	p.item_name,
	p.item_code,
    ih.invoice_status, 
    ih.created_date as 'Invoice Created date',
    ih.updated_date  as 'Invoice updated date',
	m.member_cd as 'Invoice Updated by',
	m.member_cd as 'Invoice Created by', 
    ih.invoice_status
	

FROM 
    txn_invoice_history_header ih
INNER JOIN 
    customer cus ON cus.customer_id = ih.customer_id
INNER JOIN 
    txn_invoice_history_detail b ON ih.invoice_id = b.invoice_id
INNER JOIN 
    txn_sales_order_header sls ON ih.sales_order_id = sls.ord_hdr_id

	INNER JOIN 
    product_item p ON b.item_id = p.item_id

	inner join member m on ih.member_id= m.member_id

WHERE 
    ih.invoice_no LIKE 'INWWV000001%'
    OR ih.invoice_no LIKE 'INWWV000003%'
    OR ih.invoice_no LIKE 'INWWV000004%'
    OR ih.invoice_no LIKE 'INWWV000005%'
ORDER BY 
    ih.invoice_no DESC;


-----------------------------------

Collection


 SELECT m.member_cd, c.customer_code, c.customer_name, ch.col_no,hh.invoice_no , hh.invoice_date, hh.invoice_status, cd.web_paid,cd.mobile_paid, ch.total_col_amt,ch.total_cn_amt
FROM txn_mobile_collection_header ch
inner join txn_mobile_collection_detail cd on ch.col_id= cd.col_id
inner join txn_mobile_collection_invoice ci on cd.col_id= ci.col_id
inner join txn_invoice_history_header hh on ci.inv_id= hh.invoice_id
inner join customer c on hh.customer_id= c.customer_id
inner join member m on hh.member_id= m.member_id
WHERE ch.col_no in (
'CCWWV000004-240130',
'CCWWV000003-240130',
'CCWWV000002-231214',
'CCWWV000001-231213'
)