Querying Activity Relationships
The activity relationship information is available in a dynamically created SQL view for each activity. The name of this view is
bam_< Activity >_AllRelationships
Where <Activity> is the Name attribute of the Activity element in the BAM definition XML, which is the same as the Activity name entered using the BAM Add-in for Excel.
The relationship events occur in the context of a specific activity. For example, if the relationship between Purchase Order and Shipment occurs in the context of the Purchase Order activity, the Relationship record will show up in bam_PurchaseOrder_AllRelationships, but not in bam_Shipment_AllRelationships. For more information, see Activity Relationships.
To find all the related activities to a purchase order you need to query both the view bam_PurchaseOrder_AllRelationships as well as all views bam_<OtherActivity>_AllRelationships, where <OtherActivity> is the activity in the same BAM view.
The relationship records are part of the activity instance and they are maintained in synchronization with the instance data as described in Activity Data Storage.