dbo.QER_FTPWOOrderPerson_100

1create function dbo.QER_FTPWOOrderPerson_100 (@UID_PersonOrdered varchar(38) , @dummyUID_ITShopOrgPR varchar(38) , @dummyUID_ACCProduct varchar(38) , @ValidFrom
2 datetime , @ValidUntil datetime , @CountRecords int ) returns table as return ( select distinct top (@CountRecords) cum.UID_Person as UID_PersonOrdered
3 , pr.UID_Org as UID_ITShopOrgPR , bo.UID_Org as UID_ITShopOrgBO , bo.UID_ParentOrg as UID_ITShopOrgSH , a.UID_AccProduct as UID_AccProduct , ba.IsReusePossible
4 , a.Ident_AccProduct as Ident_AccProduct , a.Description as Description , a.UID_AccProductGroup as UID_AccProductGroup from BaseTree pr join BaseTree 
5bo on bo.ITShopInfo = 'BO' and bo.uid_Org = pr.UID_ParentOrg and pr.uid_PWODecisionMethod > ' ' and pr.ITShopInfo = 'PR'     join BaseTree cu on bo.UID_ParentOrg
6 = cu.UID_ParentOrg and cu.ITShopInfo = 'CU' join PersonInBaseTree cum on cu.uid_org = cum.uid_org and cum.XOrigin > 0 and cum.UID_Person = @UID_PersonOrdered
7 join AccProduct a on pr.uid_accproduct = a.uid_accproduct and a.IsInactive = 0     join BaseTreeAssign ba with (readpast) on ba.IsITShopEnabled = 1 join
8 DialogTable t with (readpast) on ba.UID_DialogTableElement = t.UID_DialogTable join BaseTreeHasObject bho on pr.UID_Org = bho.UID_Org and bho.InheritInfo
9 = 1  and bho.ObjectKey like '<Key><T>' + t.TableName + '</T>%'  left outer join QERAssign qa on bho.ObjectKey = qa.XObjectKey where 1 = case   when ((sign
10(len(isnull(qa.ObjectKeyAssignTarget, ''))) ^1 ) & ba.IsReusePossible) = 1 and @ValidFrom is null and @ValidUntil is null then 1 when ((sign(len(isnull
11(qa.ObjectKeyAssignTarget, ''))) ^1 ) & ba.IsReusePossible) = 1 then dbo.QER_FGIPwoValidDateRangesExist(@UID_PersonOrdered, pr.UID_Org, @ValidFrom, @ValidUntil
12) when dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QER\ITShop\GapBehavior\GapFitting'), 0) = 2 then 1  else dbo.QER_FGIPwoValidDateRangesExist(@UID_PersonOrdered
13, pr.UID_Org, @ValidFrom, @ValidUntil) end ) 
14