project BLF > class BBusinessComponent > business logic query BusActivityByActCompDefault
Description
BusActivityByActCompDefault; query on table busActivity (with join to buComponent) with parameters on busAct.busActCode, BusAct.BusActIsDefault and busComp.BusCompCode
Parameters
| icBusActitvityCode | character | |
| icBusComponentCode | character | |
| ilBusActiivtyIsDefault | logical | |
| ilBusActivytIsActive | logical | |
query condition
each BusActivity where
BusActivity.BusActivityCode = icBusActitvityCode AND
BusActivity.BusActivityIsDefault = ilBusActiivtyIsDefault AND
BusActivity.BusActivityIsActive = ilBusActivytIsActive
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode
each Resources (inner-join) where
Resources.BusActivity_ID = BusActivity.BusActivity_ID AND
query resultset tqBusActivityByActCompDefault
| field name | data type | db field | description |
|---|
| tiResource_ID | integer | Resources.Resource_ID | Record ID |
| tiBusComponent_ID | integer | BusActivity.BusComponent_ID | Business Component |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tiBusActivity_ID | integer | BusActivity.BusActivity_ID | Record ID |
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tiBusActivitySequence | integer | BusActivity.BusActivitySequence | Seq |
| tlBusActivityIsActive | logical | BusActivity.BusActivityIsActive | Active |
| tlBusActivityIsDefault | logical | BusActivity.BusActivityIsDefault | Default |
Internal usage
BLF
QadFinancials