project QadFinancials > class BDomain > business logic query DomainSharedSetForMfgAddress
Parameters
| iiSharedSetId | integer | |
| icDomainCode | character | |
| icAddress | character | |
query condition
each DomainSharedSet where
DomainSharedSet.SharedSet_ID = iiSharedSetId
first Domains (inner-join) where
Domains.Domain_ID = DomainSharedSet.Domain_ID AND
Domains.DomainCode = icDomainCode
each ad_mstr (inner-join) where
ad_mstr.ad_domain = Domains.DomainCode AND
ad_mstr.ad_addr = icAddress
query resultset tqDomainSharedSetForMfgAddress
| field name | data type | db field | description |
|---|
| tcad_addr | character | ad_mstr.ad_addr | Address |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiSharedSet_ID | integer | DomainSharedSet.SharedSet_ID | Shared Set |
Internal usage
QadFinancials