Hello everyone. I have a job set up that executes certain procedures and I run it when there are changes to a facility. This is what I have and I'm wondering if any of this will need to change for v12. Does anyone know?
execute up_populate_tx_perf_seat
execute up_rebuild_all_bsmaps
execute up_update_bsmap_sequence
execute up_update_comp_maps
execute up_update_logical_nos
execute up_update_zone_no
Delete TX_PERF_SEAT where not exists (select * from T_SEAT where SEAT_NO = TX_PERF_SEAT.SEAT_NO and IS_SEAT = 1)
Delete TX_COMPOSITE_SEAT where not exists (select * from T_SEAT where SEAT_NO = TX_COMPOSITE_SEAT.SEAT_NO and IS_SEAT = 1)
update tx_perf_seat
set seat_num = s.seat_num, seat_row = s.seat_row
from tx_perf_seat ps, t_seat s
where ps.seat_no = s.seat_no
and (ps.seat_num <> s.seat_num or ps.seat_row <> s.seat_row)
I am not totally sure as I have not personally used those, but this documentation may help #mce_temp_url#