UFN_REVENUEBATCH_GETAPPLICATIONBUSINESSUNITS_FROMITEMLISTXML

create function dbo.UFN_REVENUEBATCH_GETAPPLICATIONBUSINESSUNITS_FROMITEMLISTXML(@ITEMLISTXML xml)
    returns table as
    return (
        select
            T.c.value('(APPLICATIONID)[1]','uniqueidentifier') AS 'APPLICATIONID',
            T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
            T.c.value('(OVERRIDEBUSINESSUNITS)[1]','bit') AS 'OVERRIDEBUSINESSUNITS',
         T.c.value('(REASON)[1]','uniqueidentifier') AS 'REASON',
           case when T.c.exist('./BUSINESSUNITS/ITEM') = 1 then T.c.query('(BUSINESSUNITS)[1]') else null end as 'BUSINESSUNITS'
        from @ITEMLISTXML.nodes('/APPLICATIONBUSINESSUNITS/ITEM') T(c)
    )