UFN_REVENUE_GETADJUSTMENTSTATUS

CREATE function dbo.UFN_REVENUE_GETADJUSTMENTSTATUS
(
    @REVENUEID uniqueidentifier
)
returns table

as 
return
(
    select
        ADJUSTMENT.ID,
        POSTSTATUSCODE,
        ADJUSTMENT.DATEADDED
    from 
        dbo.ADJUSTMENT
    where 
        ADJUSTMENT.REVENUEID = @REVENUEID

    union all

    select
        STOCKSALEADJUSTMENT.ID,
        POSTSTATUSCODE,
        STOCKSALEADJUSTMENT.DATEADDED
    from 
        dbo.STOCKSALEADJUSTMENT 
    inner join 
        dbo.STOCKSALE_EXT STOCKSALE on STOCKSALEADJUSTMENT.STOCKSALEID = STOCKSALE.ID
    inner join 
        dbo.REVENUEPAYMENTMETHOD on STOCKSALE.STOCKDETAILID = REVENUEPAYMENTMETHOD.ID
    where 
        REVENUEPAYMENTMETHOD.REVENUEID = @REVENUEID

    union all

    select
        PROPERTYDETAILADJUSTMENT.ID,
        POSTSTATUSCODE,
        PROPERTYDETAILADJUSTMENT.DATEADDED
    from 
        dbo.PROPERTYDETAILADJUSTMENT 
    inner join 
        dbo.REVENUEPAYMENTMETHOD on PROPERTYDETAILADJUSTMENT.PROPERTYDETAILID = REVENUEPAYMENTMETHOD.ID
    where 
        REVENUEPAYMENTMETHOD.REVENUEID = @REVENUEID

    union all

    select
        GIFTINKINDSALEADJUSTMENT.ID,
        POSTSTATUSCODE,
        GIFTINKINDSALEADJUSTMENT.DATEADDED
    from 
        dbo.GIFTINKINDSALEADJUSTMENT 
    inner join 
        dbo.GIFTINKINDSALE_EXT GIFTINKINDSALE on GIFTINKINDSALEADJUSTMENT.GIFTINKINDSALEID = GIFTINKINDSALE.ID
    inner join 
        dbo.REVENUEPAYMENTMETHOD on GIFTINKINDSALE.GIFTINKINDPAYMENTMETHODDETAILID = REVENUEPAYMENTMETHOD.ID
    where 
        REVENUEPAYMENTMETHOD.REVENUEID = @REVENUEID
)