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