working in 10g but not in 12c SELECT * FROM ( SELECT ABS (SUM (DECODE (CM, 5, D.MPRef.mass, 0.0))) "Calculated", DECODE (GROUPING_ID (S1), 1, '*** Grand Total ***', 0, (SELECT title FROM TEST_979_title T WHERE TitleSubfile = '33' AND T.code = S1)) title, S1 FROM (WITH FindAssemblies AS (SELECT AssemblyModelCode "M", AssemblyPartnum "Assembly" FROM TEST_979_effect E WHERE AssemblyModelCode = 'N' AND ('123' BETWEEN E.firstEffect AND E.lastEffect)) SELECT MPRef, ConsideredMaturity CM, NVL (LOADCODE, '-') S1 FROM TEST_979_Detail WHERE AssemblyModelCode = 'N' AND AssemblyPartNum IN (SELECT "Assembly" FROM FindAssemblies)) D GROUP BY ROLLUP (S1));
... View more