project BLF > class BBusinessComponent > business logic query BusComponentForResources
Parameters
icBusComponentCode | character | |
query condition
each BusComponent where
BusComponent.BusComponentCode = icBusComponentCode
each BusActivity (inner-join) where
BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND
each Resources (inner-join) where
Resources.BusActivity_ID = BusActivity.BusActivity_ID AND
query resultset tqBusComponentForResources
field name | data type | db field | description |
tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
tiResource_ID | integer | Resources.Resource_ID | Record ID |
tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
Internal usage
BLF