UFN_RECONCILERELATION_GETAPPLICATIONWITHCHILDREN_FROMITEMLISTXML

            create function dbo.UFN_RECONCILERELATION_GETAPPLICATIONWITHCHILDREN_FROMITEMLISTXML(@ITEMLISTXML xml)
          returns table as
          return (
            select
            T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') as 'REVENUESPLITID',
            T.c.value('(APPLIED)[1]','money') as 'APPLIED',
            T.c.value('(TYPECODE)[1]','tinyint') as 'TYPECODE',
            T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') as 'DESIGNATIONID'
            FROM @ITEMLISTXML.nodes('/RELATIONREVENUESTREAMS/ITEM') T(c)
      )