1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| SELECT COUNT (DISTINCT CASE
WHEN t32385.opty_wid > 0
THEN t32385.opty_wid
END) AS c1,
t32577.stg_name AS c2, t43873.camp_name AS c3,
t220742.attrib_01 AS c4, t43873.camp_src_num AS c5,
t43873.camp_type AS c6, t220742.attrib_21 AS c7
FROM w_opty_d t31547,
w_revn_f t32385,
w_sstage_d t32577,
w_source_d t43873,
w_opty_dx t204383,
w_source_dx t220742
WHERE ( t32385.source_wid = t43873.row_wid
AND
--T32385.OPTY_WID = T204383.ROW_WID and
t31547.row_wid = t32385.opty_wid
AND t31547.row_wid = t204383.row_wid
AND
--T32385.SOURCE_WID=T220742.ROW_WID and
t43873.row_wid = t220742.row_wid
AND t32385.curr_sstage_wid = t32577.row_wid
)
GROUP BY t32577.stg_name,
t43873.camp_name,
t43873.camp_src_num,
t43873.camp_type,
t220742.attrib_21,
t220742.attrib_01 |
Partager