SELECT c.store_no, b.store_name, c.entry_date_time, c.transaction_no, a.reference_no, SUM(a.gross_line_amount - a.pos_discount_amount)*a.db_cr_none) as SUM1,a.line_object, SUM(a.gross_line_amount * a.db_cr_none) as SUM2, a.line_action
FROM AUDITWORKS.sv_av_transaction_line a, AUDITWORKS.sv_store b,
AUDITWORKS.sv_av_transaction_header c
WHERE c.transaction_id=a.transaction_id
AND c.store_no=b.store_no
AND c.transaction_date >= '17/09/02')
AND 1=1
AND a.line_action not in 246
/* MY ADD-ON */
AND ( CASE when REF_NO<>0 and LINE_OBJECT in (11, 27) and LINE_ACTION =603 then 1
when REF_NO=0 and LINE_OBJECT=25 and LINE_ACTION=650
then 1
else 0 ) = 1
/* END ADDON */
GROUP BY c.store_no,b.store_name,c.transaction_date,c.entry_date_time,c.transaction_no,a.reference_no,a.line_ object,a.line_action