USP_SIMPLEDATALIST_PDCOMPOSITESEGMENT

        CREATE procedure dbo.USP_SIMPLEDATALIST_PDCOMPOSITESEGMENT as        
      select distinct t1.ID as VALUE, t1.FRIENDLYTABLENAME as LABEL
      from dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT t1 left join dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENTPRODUCTFLAG t2 on t1.ID = t2.PDACCOUNTTABLESAVAILABLEFORSEGMENTID
      left join dbo.INSTALLEDPRODUCTLIST t3 on t2.PRODUCTFLAGID = t3.ID
      where (t2.ID is null
      or t3.ID is not null)
      and ISCODETABLE != 3
      and t1.ID not in ('1013131F-C3A1-4B73-BA39-174953B919F9','E27FB5F2-A56F-424A-9E9F-72EA9B8FA816','1BA6F27F-8454-4FC4-A830-3FDA8CD35D04')
      order by FRIENDLYTABLENAME