USE [PRIXUS_76377910]
GO

create PROCEDURE sp_Api5_AppFac_VenEncabezadoRead
    @numinv INT,
    @codsii INT,
    @grudoc INT = 0,
    @coddoc INT = 0
AS
BEGIN
    SELECT 
        VenEncabezado.*,
        ven.nomdoc,	
		ISNULL((SELECT TOP 1 alias_doc FROM venDocumentos WHERE codsii = VenEncabezado.tipref1), '') AS aliasRef,
        ISNULL((SELECT TOP 1 nomdoc FROM venDocumentos WHERE codsii = VenEncabezado.tipref1), '') AS nomdocRef,
        cta.digcte,
        cta.nomcte
    FROM 
        VenEncabezado
        INNER JOIN venDocumentos AS ven ON VenEncabezado.codsii = ven.codsii
        INNER JOIN conCtacte AS cta ON VenEncabezado.rutcte = cta.rutcte
    WHERE 
        numinv = @numinv
        AND VenEncabezado.codsii = @codsii
        AND (@grudoc = 0 OR VenEncabezado.grudoc = @grudoc)
        AND (@coddoc = 0 OR VenEncabezado.coddoc = @coddoc)
END