project QadFinancials > class BDomain > business logic query DomainForSharedSet


Parameters


iiDomainIDintegerDomain ID
icDomainCodecharacterDomain Code


query condition


  each Domains where
Domains.Domain_ID = iiDomainID AND
Domains.DomainCode = icDomainCode

      each DomainSharedSet (inner-join) where
DomainSharedSet.Domain_ID = Domains.Domain_ID AND

          first SharedSet (inner-join) where
SharedSet.SharedSet_ID = DomainSharedSet.SharedSet_ID AND


query resultset tqDomainForSharedSet


field namedata typedb fielddescription
tiDomain_IDintegerDomains.Domain_IDRecord ID
tcDomainCodecharacterDomains.DomainCodeDomain
tiDomainSharedSet_IDintegerDomainSharedSet.DomainSharedSet_IDRecord ID
tiSharedSet_IDintegerSharedSet.SharedSet_IDRecord ID
tcSharedSetCodecharacterSharedSet.SharedSetCodeShared Set Code
tcSharedSetDescriptioncharacterSharedSet.SharedSetDescriptionShared Set Description
tlSharedSetIsActivelogicalSharedSet.SharedSetIsActiveActive
tcSharedSetTypeCodecharacterSharedSet.SharedSetTypeCodeShared Set Type


Internal usage


QadFinancials
method BCOACrossRef.ApiDomainsWithSameSharedSets
method BCOACrossRef.GetTargetSharedSets
method BCOAMask.COAMaskSelectAll
method BCostCentre.ApiLoadCostCentre
method BCostCentre.ApiLoadCostCentreV01
method BDivision.ApiLoadDivision
method BFRWChart.GetDomainSharedSetsByDomain