UFN_PDCOMPOSITESEGMENTTABLES_TOITEMLISTXML

create function dbo.UFN_PDCOMPOSITESEGMENTTABLES_TOITEMLISTXML(
  @PDACCOUNTSTRUCTUREID uniqueidentifier
)
returns xml
with execute as caller
as begin
  return (

select 
    CSTL.PDACCOUNTTABLESAVAILABLEFORSEGMENTID
    ,CSST.FRIENDLYTABLENAME 
    ,dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(CSST.ID) as [SHOWSIMPLE]
    ,CSTL.SEQUENCE as [SEQUENCE]
from dbo.PDACCOUNTSTRUCTURE as S
    inner join dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT as ST
        on S.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = ST.ID
    inner join dbo.PDCOMPOSITESEGMENT as CS
        on ST.TABLEID = CS.ID
    inner join dbo.PDCOMPOSITESEGMENTTABLELIST as CSTL
        on CS.ID = CSTL.PDCOMPOSITESEGMENTID
    inner join dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT as CSST 
        on CSTL.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = CSST.ID
where
    S.ID = @PDACCOUNTSTRUCTUREID
order by CSTL.SEQUENCE asc
for xml raw('ITEM'),type,elements,root('TABLESTRUCTURE'),BINARY BASE64
  );  
end