[Home] [Help]
32: SUBSTR(sys_award_year,4) code,
33: award_year_status_code status,
34: sys_award_year_mean
35: FROM
36: igf_ap_batch_aw_map_v
37: WHERE
38: sys_award_year like 'LI%'
39: UNION
40: SELECT
41: '20'||SUBSTR(sys_award_year,0,2) code,
42: award_year_status_code status,
43: sys_award_year_mean
44: FROM
45: igf_ap_batch_aw_map_v
46: WHERE
47: Sys_award_year NOT LIKE 'LI%'
48: ORDER BY 1;
49: