USE T26A001

UPDATE CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SET JOBSENDSRNO=T1.F2 FROM (SELECT SEND_TO_JOB_ITEM_DETAIL.LotNo AS F1, SEND_TO_JOB_ITEM_DETAIL.SrNo AS F2, SEND_TO_JOB_ITEM_DETAIL.ItemSrNo AS F3, SEND_TO_JOB.ChallanNo AS F4 FROM SEND_TO_JOB_ITEM_DETAIL INNER JOIN SEND_TO_JOB ON SEND_TO_JOB_ITEM_DETAIL.SrNo = SEND_TO_JOB.SrNo) AS T1 WHERE  JOBSENDCHNO = T1.F4 AND JOBSENDSRNO = ''

UPDATE SEND_TO_JOB_ITEM_DETAIL SET LOTNO = '9'+ RIGHT(SRNO,4)+CONVERT(VARCHAR(1),ITEMSRNO) WHERE LOTNO=0 AND ITEMSTATUS='P' and 
SrNo IN ('000842','000844','000846','000851','000854','000856','000857','000858','000860','000861','000862','000863','000864','000865','000866','000867','000868','000869','000870','000871','000873','000874','000875','000876','000877')



----YEAR AEND TRANSFER

USE T27A001


UPDATE CRFJCD SET JobSendItmSrNo = T1.F2, LotNo = T1.F3 FROM CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL CRFJCD INNER JOIN CHALLAN_RECEIVED_FROM_JOB CRFJ ON CRFJ.SRNO = CRFJCD.SrNo INNER JOIN (
SELECT OSJD.SrNo AS F1, OSJD.ItemSrNo AS F2, OSJD.LotNo AS F3, OSJ.ChallanNo AS F4, OSJ.JobCode AS F5, OSJD.ItemRangeDesp AS F6 FROM OPENING_SEND_TO_JOB_ITEM_DETAIL OSJD INNER JOIN OPENING_SEND_TO_JOB OSJ ON OSJD.SrNo = OSJ.SrNo
) AS T1 ON CRFJ.JobCode = T1.F5 AND CRFJCD.JobSendChNo = T1.F4 and JobSendSrNo = T1.F1 and Screen=t1.f6;


UPDATE SEND_TO_JOB_ITEM_DETAIL SET LOTNO = T1.F1 FROM (SELECT LOTNO AS F1, SRNO AS F2, ITEMSRNO AS F3 FROM CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL) AS T1 WHERE T1.F2 = RECSRNO AND RECISRNO = T1.F3

UPDATE CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SET LOTNO = T1.F1 FROM (SELECT LOTNO AS F1, SRNO AS F2, ITEMSRNO AS F3 FROM SEND_TO_JOB_ITEM_DETAIL) AS T1 WHERE T1.F2 = JOBSENDSRNO AND JOBSENDITMSRNO = T1.F3