project QadFinancials > class BDomain > business logic query DomainSharedSetForLsMstr
Parameters
| iiSharedSetId | integer | |
| icDomainCode | character | |
| icAddress | character | |
| icAddressType | 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 ls_mstr (inner-join) where
ls_mstr.ls_domain = Domains.DomainCode AND
ls_mstr.ls_addr = icAddress AND
ls_mstr.ls_type = icAddressType
query resultset tqDomainSharedSetForLsMstr
| field name | data type | db field | description |
|---|
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcls_addr | character | ls_mstr.ls_addr | Address |
| tcls_type | character | ls_mstr.ls_type | List Type |
| tiSharedSet_ID | integer | DomainSharedSet.SharedSet_ID | Shared Set |
Internal usage
QadFinancials