cleanup joins, don't need to join to transam asset tables as that is in default scope and other joins must be explicitly as might not be child table
cleanup joins, don't need to join to transam asset tables as that is in default scope and other joins must be explicitly as might not be child table

camsys/transam_transit,camsys/transam_transit,camsys/transam_transit,camsys/transam_transit