USP_DATALIST_PDACCOUNTCODEMAPSUBLEDGER

CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPSUBLEDGER
as
    set nocount on;

       select ID,
            SUBLEDGER,
            SUBLEDGERTYPE,
            DESCRIPTION,
            SITEID
      from dbo.PDACCOUNTCODEMAPSUBLEDGER 
      where SUBLEDGERTYPE in (1,3,4)
union       
      select ID,
            SUBLEDGER,
            SUBLEDGERTYPE,
            DESCRIPTION,
            SITEID
      from dbo.PDACCOUNTCODEMAPSUBLEDGER 
      where SUBLEDGERTYPE = 2 and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('BB1C17BC-9E0B-4683-B490-EE40D511FA05') = 1
      order by SUBLEDGERTYPE