dbo.vw_ms_supplier_customer_for_manual_invoice

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE FUNCTION dbo.vw_ms_supplier_customer_for_manual_invoice (@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.invoice_ready,0) as invoice_ready
 , isnull(inv_info.invoice_total,0) as invoice_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
        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