dbo.vw_ms_supplier_customer_for_manual_grn

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO


CREATE FUNCTION dbo.vw_ms_supplier_customer_for_manual_grn (@ms_manual_invoice_type_id int)  
RETURNS TABLE  
AS  
RETURN   
(    

 SELECT        
   dt_ms_supplier_customer.ms_supplier_customer_id
 , dt_ms_supplier_customer.supplier_customer_code
 , dt_ms_supplier_customer.supplier_customer_name
 , tblNegara.UrEdi AS supplier_customer_country_name
 , isnull(inv_info.grn_ready,0) as grn_ready
 , isnull(inv_info.grn_total,0) as grn_total
 , dt_ms_supplier_customer.supplier_customer_address
 , dt_ms_supplier_customer.supplier_customer_country 
 FROM            
 --vw_ms_manual_invoce_group_supplier(@ms_manual_invoice_type_id) as inv_info RIGHT OUTER JOIN
 vw_ms_manual_grn_group_supplier() as inv_info RIGHT OUTER JOIN
        dt_ms_supplier_customer ON inv_info.supplier_customer_id = dt_ms_supplier_customer.ms_supplier_customer_id LEFT OUTER JOIN
        tblNegara ON dt_ms_supplier_customer.supplier_customer_country = tblNegara.KdEdi      
);         
       

GO