------------------- Get the itso_shell_account_sk (long card number) -------------------

select * from HOPS.ITSO_SHELL_ACCOUNT where isrn='633597011600255701';

194097

------------------ Check which location product going to currently. FLAG_LSTPROC_COMPLETE shows whether it has already been sent -----

select flag_lstproc_complete, send_to from cut.cut_al_request where itso_shell_Account_sk=161391;
select * from cut.cut_al_request where itso_shell_Account_sk=161391;

-- if more than on result, instead select result that matches details given from:

select * from cut.cut_al_request where itso_shell_Account_sk=161391 order by 1 desc;

------------------ find PUBLIC_SET_SK from list of locations, change wildcard as appropriate -------------------------

select * from AMS.public_set where DESCRIPTION like '%SHEPPERTON%'

122

----------------- get the CUT_AL_REQUEST_SK value to find the appropriate actionlist -----------------------

select * from cut.cut_al_request where itso_shell_Account_sk=161391;

302598

----------------- input the new location and the CUT_AL_REQUEST_SK to update AL and resend ------------------------

update cut.cut_al_request set flag_lstproc_complete='N', send_to=25 where cut_al_request_sk=343588;

commit;