String 	ls_where

Choose Case as_column
	Case "mtr_mst_received_status"
		ls_where = 	" (		SELECT CASE " +&
						" 		WHEN Sum(mtr_ls1_req_qty) = Sum(mtr_ls1_rcv_qty + COALESCE(mtr_ls1_clear_qty, 0)) THEN 'Fully Issued' " +&
						" 		WHEN Sum(mtr_ls1_req_qty) > Sum(mtr_ls1_rcv_qty + COALESCE(mtr_ls1_clear_qty, 0)) AND Sum(mtr_ls1_rcv_qty + COALESCE(mtr_ls1_clear_qty, 0)) > 0 THEN 'Partial Issued' " +&
						" 		WHEN Sum(mtr_ls1_rcv_qty + COALESCE(mtr_ls1_clear_qty, 0)) = 0 THEN 'Not Issue' END " +&
						" 		FROM mtr_ls1 " +&
						" 		WHERE mtr_mst.rowid = mtr_ls1.mst_rowid " +&
						" 		GROUP BY mst_rowid ) "
																		
	Case "pur_mst_convert_status"
		ls_where = 	" (	SELECT CASE " +&
						"	WHEN Sum(CASE WHEN pur_ls1_po_no IS NULL THEN 1 ELSE 0 END) = 0 THEN 'Fully Converted' " +&
						"	WHEN Sum(CASE WHEN pur_ls1_po_no IS NOT NULL THEN 1 ELSE 0 END) < Sum(1) AND Sum(CASE WHEN pur_ls1_po_no IS NOT NULL THEN 1 ELSE 0 END) > 0 THEN 'Partial Converted' " +&
						"	WHEN Sum(CASE WHEN pur_ls1_po_no IS NOT NULL THEN 1 ELSE 0 END) = 0 THEN 'Not Convert' END " +&
						"	FROM  pur_ls1 " +&
						"	WHERE pur_mst.rowid =  pur_ls1.mst_rowid " +&
						"	GROUP BY mst_rowid ) "	
		
	Case "puo_mst_received_status"
		ls_where = 	" (	SELECT CASE " +&
						" 	WHEN Sum(COALESCE(puo_ls1_ord_qty, 0)) = Sum(COALESCE(puo_ls1_rcv_qty, 0) - COALESCE(puo_ls1_invoice_qty, 0)) THEN 'Fully Received' " +&
						" 	WHEN Sum(COALESCE(puo_ls1_ord_qty, 0)) > Sum(COALESCE(puo_ls1_rcv_qty, 0) - COALESCE(puo_ls1_invoice_qty, 0)) AND Sum(COALESCE(puo_ls1_rcv_qty, 0) - COALESCE(puo_ls1_invoice_qty, 0)) > 0 THEN 'Partial Received' " +&
						" 	WHEN Sum(COALESCE(puo_ls1_rcv_qty, 0) - COALESCE(puo_ls1_invoice_qty, 0)) = 0 THEN 'Not Receive' END " +&
						" 	FROM puo_ls1 " +&
						" 	WHERE puo_mst.rowid = puo_ls1.mst_rowid " +&
						" 	GROUP BY puo_ls1.mst_rowid ) "
						
	Case "pur_mst_approver"
		ls_where = 	" (	SELECT 	pur_app_empl_id " +&
						" 	FROM 	pur_app " +&
						" 	WHERE	pur_mst.rowid = pur_app.mst_rowid " +&
						"   AND 		pur_mst_cur_app_level + 1 = pur_app_level " +&
						"	AND 		pur_app_status = 'P'" +&
						"	AND 		pur_app_empl_id = '" + as_value + "')"		
End Choose

Return ls_where