...
| Code Block |
|---|
AND A.SCBCRSE_SUBJ_CODE NOT IN
('CLEP','TRNS','AP','AML1','CAR1','BB','CED1','CER1','HFW1','MED1') -- COS change ADDED
AND (SCBCRSE_SUBJ_CODE || SCBCRSE_CRSE_NUMB <> 'LIBR490AB')
--COS Above 2 lines added |
- Jordan Lamb Ask Daniel Alvarado if any
SCBCRSE_SUBJ_CODE= ('CLEP', ‘TRNS’, ‘AP’, ‘AML1’, ‘CAR1’, ‘BB’. ‘CED1’, ‘CER1’, ‘HFW1’,'MED1’) are still active on the catalog level. If not, then we can remove this line of code.
...