***********************************For BW jobs
SELECT
OH_Client, OH_Name, JBA_IntAccount as 'Change Reuqest',
substring(Substring(OT_Content,0,charindex(',',OT_Content)),19,len(Substring(OT_Content,0,charindex(',',OT_Content)))) as 'Report\Variant',
Substring(OT_Content,charindex(',',OT_Content)+1,LEN(OT_Content)-charindex(',',OT_Content)) as 'Report\Variant',
LEFT(Substring(JBA_Rest,charindex('9',JBA_Rest)+3,charindex('=',Substring(JBA_Rest,charindex('9',JBA_Rest)+3,100))),LEN(Substring(JBA_Rest,charindex('9',JBA_Rest)+3,charindex('=',Substring(JBA_Rest,charindex('9',JBA_Rest)+3,100))))-3) as 'SM37 Job name',
CASE OH_MrtMethod
WHEN 0 THEN 'no audit'
WHEN 1 THEN 'fix in seconds'
WHEN 2 THEN 'fix time'
WHEN 4 THEN 'ERT+xx%'
WHEN 256 THEN 'Cancel'
WHEN 512 THEN 'Start Object'
WHEN 65536 THEN 'SRT in seconds'
WHEN 131072 THEN 'SRT ERT+xx%'
ELSE CAST(OH_MrtMethod as varchar(MAX))
END as 'MRT_Method', OH_Mrt, OH_MrtTime, OH_MrtErt, OH_MrtExecute
FROM OH
JOIN OT ON OH_IDNR = OT_OH_Idnr
JOIN JBA ON JBA_OH_Idnr = OH_Idnr
WHERE
OH_DELETEFLAG = 0
AND OT_Content LIKE '%R3_ACTIVATE_REPORT%';