Пользовательские отчеты СуперМаг (Oracle Reports) : Супермаг Плюс (Супермаг 2000)

SELECT doc.namegroup, doc.NAME, doc.article, doc.abbrev, doc.quantity,
doc.totalprice
FROM (SELECT (sacc.tree || ' ' || sacc.NAME) AS namegroup, smc.NAME,
smc.article,
(CASE
WHEN smau.rate IS NULL OR smau.rate = 0
THEN sam.abbrev
ELSE smau.abbrev
END
) AS abbrev,
SUM (CASE
WHEN smau.rate IS NULL OR smau.rate = 0
THEN sms.quantity
ELSE sms.quantity * smau.rate
END
) AS quantity,
SUM (sms.totalprice) AS totalprice
FROM ((smspec sms LEFT JOIN smdocuments smd
ON (sms.docid = smd.ID AND sms.doctype = smd.doctype))
LEFT JOIN
(((smcard smc LEFT JOIN sacardclass sacc
ON smc.idclass = sacc.ID)
LEFT JOIN
sameasurement sam ON smc.idmeasurement = sam.ID)
LEFT JOIN
(SELECT smaltunits.article, smaltunits.rate,
sameasurement.abbrev
FROM (smaltunits LEFT JOIN sameasurement
ON sameasurement.ID = smaltunits.altunit)
RIGHT JOIN
smcardproperties
ON smcardproperties.article = smaltunits.article
WHERE smcardproperties.propid = TO_CHAR ('0')
AND ( smcardproperties.propval <> 0
OR smcardproperties.propval IS NOT NULL
)) smau ON smc.article = smau.article)
ON sms.article = smc.article)
WHERE sms.doctype = 'CS'
AND (smd.createdat BETWEEN :createdatn AND :createdatk)
AND smd.locationfrom = :locationfrom
GROUP BY sacc.tree,
sacc.NAME,
smc.NAME,
smc.article,
CASE
WHEN smau.rate IS NULL OR smau.rate = 0
THEN sam.abbrev
ELSE smau.abbrev
END
ORDER BY sacc.tree) doc