Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
blg_argmnt_name	CHAR	varchar		81			Name of billing arrangement
blg_argmnt_objid	LONG	int	3			DIRECT	Blg_argmnt Internal record number
is_primary	LONG	int				DIRECT	Billing Entity Objid
site_ba_role_name	CHAR	varchar		80			Name of the role
site_ba_role_objid	LONG	int				DIRECT	Site_ba_role Internal record number
site_objid	LONG	int				DIRECT	Site Internal record number

SQL:

((
select 1 as is_primary,
table_blg_argmnt.objid as blg_argmnt_objid,
table_blg_argmnt.name as blg_argmnt_name,
table_blg_argmnt.primary_blg_argmnt2site as site_objid,
0 as site_ba_role_objid,
'Primary' as site_ba_role_name
from table_blg_argmnt)
union (
select 0 as is_primary,
table_blg_argmnt.objid as blg_argmnt_objid,
table_blg_argmnt.name as blg_argmnt_name,
table_site_ba_role.site_ba_role2site as site_objid,
table_site_ba_role.objid as site_ba_role_objid,
table_site_ba_role.role_name as site_ba_role_name
from table_blg_argmnt, table_site_ba_role
where table_blg_argmnt.objid = table_site_ba_role.site_ba_role2blg_argmnt))