: !/bin/sh

if [ -n "$1" ]; then
	outfile="$1"
else
	outfile="tbsseidtranslate.unl"
fi

# view created by Robyn 18/05/2010
tbssql >"$outfile" <<SQLCMD0
select * from vwRDBilmaxSEidTranslate
order by 1
SQLCMD0

exit 0

#----------------------------
# SQL for view is...
tbssql >"$outfile" <<SQLCMD0
SELECT dbo.tSystem.ID AS SysID, dbo.tElement.ElementCode, dbo.tSystem.System
FROM dbo.tServiceType INNER JOIN
dbo.tSystem ON dbo.tServiceType.SystemID = dbo.tSystem.ID INNER JOIN
dbo.tSupplier ON dbo.tServiceType.SupplierID = dbo.tSupplier.ID INNER JOIN
dbo.tElement ON dbo.tServiceType.RevenueElementID = dbo.tElement.ID
WHERE
 (dbo.tElement.ElementCode = '60016' OR dbo.tElement.ElementCode = '60003') 
 AND (dbo.tServiceType.Active = 1)
SQLCMD0