Help

[luv2ski]

Could someone tell me what this statement is doing?

AND CASE WHEN pcl.clec_dspch_type_cd = ''ZZZZZZ''
THEN ''ZZZZZZ''
ELSE DECODE(SUBSTR(pcl.clec_dspch_type_cd, 4, 1), NULL, SUBSTR(dm.dspch_type_cd, 1, 3)
, DECODE(dm.prod_id, 1, ''ZZZZZZ'', dm.dspch_type_cd))
END = pcl.clec_dspch_type_cd

[gandolf989]

I'm guessing that the section "pcl.clec_dspch_type_cd = ''ZZZZZZ''" is only there so that the else clause would fire when code ZZZZZZ does not appear. Its way to filter the logic based on the data.